Part 3: How to create a MYSQL Data Base in wamp server and connect login fom with Data Base
code:
Connection con; PreparedStatement ps; try { con=DriverManager.getConnection("jdbc:mysql://localhost/APP1", "root", ""); ps=con.prepareStatement("SELECT `nom`,`password` FROM `ADMIN` WHERE `nom`=? AND `password`=?;"); ps.setString(1,jTextField1.getText()); ps.setString(2, String.valueOf(PASWORD.getPassword())); ResultSet rs=ps.executeQuery(); if(rs.next()) { ADMIN main=new ADMIN(); main.setVisible(true); this.setVisible(false); } else { JOptionPane.showMessageDialog(null, "Invalid Username or Password"); } } catch (SQLException ex) { Logger.getLogger(LOGIN.class.getName()).log(Level.SEVERE, null, ex); }
import :
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JOptionPane;