commit 4a84ce114eec4b6818ec7f1f378c08a188cf61c5
parent 612cb3593fb6dcb34b8717141a721b3084b9bca0
Author: William Lindholm <william_lindholm@outlook.com>
Date: Thu, 7 Nov 2024 12:47:55 +0000
Imported project files, and created maven project.
Diffstat:
6 files changed, 146 insertions(+), 0 deletions(-)
diff --git a/ET4437 - Project Specification.pdf b/ET4437 - Project Specification.pdf
Binary files differ.
diff --git a/TicTacToeClient/pom.xml b/TicTacToeClient/pom.xml
@@ -0,0 +1,14 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+ <modelVersion>4.0.0</modelVersion>
+ <groupId>com.groupproject</groupId>
+ <artifactId>TicTacToeClient</artifactId>
+ <version>1.0-SNAPSHOT</version>
+ <packaging>jar</packaging>
+ <properties>
+ <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
+ <maven.compiler.source>22</maven.compiler.source>
+ <maven.compiler.target>22</maven.compiler.target>
+ <exec.mainClass>com.groupproject.tictactoeclient.TicTacToeClient</exec.mainClass>
+ </properties>
+</project>
+\ No newline at end of file
diff --git a/TicTacToeClient/src/main/java/com/groupproject/tictactoeclient/TicTacToeClient.java b/TicTacToeClient/src/main/java/com/groupproject/tictactoeclient/TicTacToeClient.java
@@ -0,0 +1,16 @@
+/*
+ * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
+ */
+
+package com.groupproject.tictactoeclient;
+
+/**
+ *
+ * @author Willi
+ */
+public class TicTacToeClient {
+
+ public static void main(String[] args) {
+ System.out.println("Hello World!");
+ }
+}
diff --git a/TicTacToeWS.zip b/TicTacToeWS.zip
Binary files differ.
diff --git a/flowchart.jpg b/flowchart.jpg
Binary files differ.
diff --git a/tictactoe.sql b/tictactoe.sql
@@ -0,0 +1,115 @@
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+DROP DATABASE IF EXISTS tictactoe;
+CREATE DATABASE tictactoe;
+USE tictactoe;
+
+--
+-- Table structure for table `users`
+--
+
+DROP TABLE IF EXISTS `users`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `users` (
+ `autokey` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(50) NOT NULL,
+ `surname` varchar(50) DEFAULT NULL,
+ `username` varchar(25) NOT NULL,
+ `password` varchar(255) NOT NULL,
+ `isactive` tinyint(4) DEFAULT '0',
+ `registered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ PRIMARY KEY (`autokey`)
+) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `users`
+--
+
+LOCK TABLES `users` WRITE;
+/*!40000 ALTER TABLE `users` DISABLE KEYS */;
+INSERT INTO `users` VALUES (1,'John','Doe','johnD96','79a7eaf60787bf0a9eb73e7b8c92e428906df538',1,'2023-11-22 09:21:53');
+/*!40000 ALTER TABLE `users` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+--
+-- Table structure for table `games`
+--
+
+DROP TABLE IF EXISTS `games`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `games` (
+ `autokey` int(11) NOT NULL AUTO_INCREMENT,
+ `p1` int(11) DEFAULT NULL,
+ `p2` int(11) DEFAULT NULL,
+ `gamestate` tinyint(4) DEFAULT '0',
+ `started` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ PRIMARY KEY (`autokey`),
+ KEY `p1` (`p1`),
+ KEY `p2` (`p2`),
+ CONSTRAINT `games_ibfk_1` FOREIGN KEY (`p1`) REFERENCES `users` (`autokey`),
+ CONSTRAINT `games_ibfk_2` FOREIGN KEY (`p2`) REFERENCES `users` (`autokey`)
+) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `games`
+--
+
+LOCK TABLES `games` WRITE;
+/*!40000 ALTER TABLE `games` DISABLE KEYS */;
+/*!40000 ALTER TABLE `games` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `moves`
+--
+
+DROP TABLE IF EXISTS `moves`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `moves` (
+ `autokey` int(11) NOT NULL AUTO_INCREMENT,
+ `pId` int(11) DEFAULT NULL,
+ `x` int(11) DEFAULT NULL,
+ `y` int(11) DEFAULT NULL,
+ `played` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `gId` int(11) DEFAULT NULL,
+ PRIMARY KEY (`autokey`),
+ KEY `pId` (`pId`),
+ KEY `gId` (`gId`),
+ CONSTRAINT `moves_ibfk_1` FOREIGN KEY (`pId`) REFERENCES `users` (`autokey`),
+ CONSTRAINT `moves_ibfk_2` FOREIGN KEY (`gId`) REFERENCES `games` (`autokey`)
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `moves`
+--
+
+LOCK TABLES `moves` WRITE;
+/*!40000 ALTER TABLE `moves` DISABLE KEYS */;
+/*!40000 ALTER TABLE `moves` ENABLE KEYS */;
+UNLOCK TABLES;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
