Nemo-Ships

Converting a complicated requirements to an ERD Diagram , Building a database on SQL Server using DDL to match it , Writing DML stored procedures to be used by the application layer to access the data and developing a full featured desktop JAVA application using MVC architecture and DAO design pattern allowing different types of users to view/manipulate the data of the system through a FXML GUI built with scene builder and JavaFX .

admin authentication : username :admin , password: admin user authentication : username : # use any person id from the database , password: abc123

in order to use the application you need to import the .bak database file to your SQL Server and then go to model/DataBaseConnection and add your sql server user name , password and url if needed :

public static void initConn() throws Exception {

	String userName = "------";
	String password = "------";
	String url = "jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=Nemo_Ships";
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	conn = DriverManager.getConnection(url, userName, password);

}