CS619 Test Phase – JAVA Login System with Netbeans and MS SQL Server Spring 2020

CS619 Test Phase Netbeans and SQL Server Login - Test Phase

CS619 Test Phase – JAVA Login System with Netbeans and MS SQL Server Spring 2020 #CS619 #TestPhase #JAVA. For CS619 Test Phase, login system and user management system assigned to the students of Final year project which are to be made using Java PHP Android ASP and python.

In this video I will demonstrate login system form designing in NetBeans and JAVA application and then will lead to you how to connect with there Microsoft SQL server database with NetBeans and perform query based operation.

Topics of video

1. CS619 Test Phase Spring 2020
2. Java and MS Sql Server Test Phase
3. Netbeans and SQL Server login system
4. How to add controls in Netbeans in JAVA Form
5. How to make GUI forms in JAVA Test Phase

Task Develop an application for Library Management system in Java or PHP language using MySQL server or MS SQL server. You have to design and develop login screen and Admin Functions screen. Login screen will be connected with Database and username, password filed will be verified from Database upon clicking Login button.

If Username and Password do not match the records in the database then it will throw an error message “Invalid User and Password. Try Again” For your convenience sample Screen shots are given below. So, once a user logs in, he or she will be redirected to the admin menu as below. You have to draw the same Admin Function screen and no functionality required against each button in Admin Functions screen.

You should only add a message box against click event of each button showing this statement “Welcome to Library Management System and this is __________ Class Function” ____________ should be filled with either “Users” or “Books” word depending upon which class function it was called.


import java.sql.Connection;
import java.sql.DriverManager;
import javax.swing.JOptionPane;


/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 *
 * @author Khayoo
 */
public class MyConnection {
    // create a function to connect with mysql database
    
    public static Connection getConnection(){
     
        Connection con = null;
        try {
           //Class.forName("com.mysql.jdbc.Driver");
           //con = DriverManager.getConnection("jdbc:mysql://localhost/java_login_register", "root", "");
            String url = "jdbc:sqlserver://localhost;databaseName=userMgt;integratedSecurity=true";
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
             con = DriverManager.getConnection(url);
             JOptionPane.showMessageDialog(null, "Connected");
             
            
        } catch (Exception ex) {
            //System.out.println(ex.getMessage());
            JOptionPane.showMessageDialog(null, "not connected");

        }
        
        return con;
    }
    
}