JAVA DESKTOP MYSQL CRUD

Create Java Swing Project to CREATE UPDATE DELETE EDIT AND JTABLE

Getting Started

Download and open in Netbean 8.xx IDE

Prerequisites

• Java SDK 8.xx
• NetBean IDE
• Connector/J https://dev.mysql.com/downloads/connector/j/
• JDBC CONNECTOR
• MYSQL Database Server https://dev.mysql.com/downloads/mysql/
• XAMPP Server https://www.apachefriends.org/index.html

//////////CREATE DATABASE AND TABLE ////////////
CREATE DATABASE `wbeducar_java`;--
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_status` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entry` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
INSERT INTO `user` (`id`, `username`, `password`, `user_status`, `entry`) VALUES
(1, 'admin', 'admin', 'Active', '2018-02-14 22:22:29');
//////////  IMPORT /////////////////////
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
//////Others in JFrame //////
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
/////////// Database Connection in DBConnection.Java/////////
private Connection DBConnection;
    public Connection connect(){
try{
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Driver Success");            
        }
 catch(ClassNotFoundException cnfe){
            System.out.println("Driver not found" + cnfe);
        }  
        String url="jdbc:mysql://localhost:3306/wbeducar_java";        
try{
          DBConnection=DriverManager.getConnection(url,"root","YOUR PASSWORD");
          System.out.println("Database Connected");
        }
catch(SQLException se){
          System.out.println("Database Not Found");  
        }
        return DBConnection;       
 }     
////// CALL CONNECTION IN OTHER FORM////////////
 Connection conn=new DBConnection().connect();
 //////////////// CHECK SELECT QUERY ON BUTTON CLICK EVENT  ///////////////// 
  String sql="Select * FROM user where username=? AND password=?";
      try{
          PreparedStatement ps=conn.prepareStatement(sql);
          ps.setString(1,txtUser.getText());
          ps.setString(2,txtPass.getText());
          ResultSet rs=ps.executeQuery();
         if(rs.next()){
             this.dispose();
              MainMenu mm = new MainMenu();
             mm.show();
         }
         else {
             JOptionPane.showMessageDialog(null,"User Credential invalid");
         }
      }
      catch(HeadlessException | SQLException e){
       JOptionPane.showMessageDialog(null,"User Credential invalid" + e);   
      }
 /////////////////// EXIT FROM APPLICATION ///////////
 System.exit(0);

Installing

Clone git and open dist folder and run javaapp.jar in windows environment

Built With

• Netbeans - Netbeans IDE
• Java SDK - as per your OS

Contributing & Issue

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.

Authors

• Prativas Basu

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments

• Bartosz Firyn