Applet to check for valid username and password using data in db
import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class JdbcCon extends Applet implements ActionListener{
String un="",pw="";
TextField tf;
JPasswordField p ;
public void init(){
Button b=new Button("LOGIN");
b.setBounds(10, 110, 70, 30);
tf= new TextField(10);
tf.setBounds(10, 40, 100, 20);
setLayout(null);
p = new JPasswordField(10);
p.setBounds(10, 80, 100, 20);
p.setEchoChar('X');
add(b);
add(tf);
add(p);
b.addActionListener(this);
}
public void paint(Graphics g){
g.drawString("USERNAME", 10, 30);
g.drawString("PASSWORD", 10, 70);
}
@Override
public void actionPerformed(ActionEvent arg0) {
// TODO Auto-generated method stub
try {
un=tf.getText();
pw=p.getText();
new A(un,pw);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
class A {
A(String un,String pw) throws SQLException{
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/jdbc","root","root");
//use your db details
Statement st =con.createStatement();
ResultSet rs = st.executeQuery("select * from login");
while(rs.next()){
if((rs.getString(1).equals(un))&&(rs.getString(2).equals(pw))){
//in ny login table i had first column as username and second as password
System.out.println("login successfull");
pw="0000";
}
}
if(pw.equals("000"))
System.out.println("Failed");
}
}
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class JdbcCon extends Applet implements ActionListener{
String un="",pw="";
TextField tf;
JPasswordField p ;
public void init(){
Button b=new Button("LOGIN");
b.setBounds(10, 110, 70, 30);
tf= new TextField(10);
tf.setBounds(10, 40, 100, 20);
setLayout(null);
p = new JPasswordField(10);
p.setBounds(10, 80, 100, 20);
p.setEchoChar('X');
add(b);
add(tf);
add(p);
b.addActionListener(this);
}
public void paint(Graphics g){
g.drawString("USERNAME", 10, 30);
g.drawString("PASSWORD", 10, 70);
}
@Override
public void actionPerformed(ActionEvent arg0) {
// TODO Auto-generated method stub
try {
un=tf.getText();
pw=p.getText();
new A(un,pw);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
class A {
A(String un,String pw) throws SQLException{
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/jdbc","root","root");
//use your db details
Statement st =con.createStatement();
ResultSet rs = st.executeQuery("select * from login");
while(rs.next()){
if((rs.getString(1).equals(un))&&(rs.getString(2).equals(pw))){
//in ny login table i had first column as username and second as password
System.out.println("login successfull");
pw="0000";
}
}
if(pw.equals("000"))
System.out.println("Failed");
}
}
Comments
Post a Comment