JDBC - Application 5
1) CreateTableLogin.java
import java.sql.*;
class TableCreateLogin
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("Jdbc:Odbc:Maya");
Statement s = c.createStatement();
s.execute("create Table Login(login char, pass char)");
System.out.println("Table Created");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
2) Welcome.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class Welcome implements ActionListener
{
Frame f1;
Button b1,b2;
Welcome()
{
f1= new Frame("welcome java");
b1 = new Button("Register");
b2 = new Button("Login");
f1.add(b1);
f1.add(b2);
f1.setLayout(new FlowLayout());
b1.addActionListener(this);
b2.addActionListener(this);
f1.setVisible(true);
f1.setSize(200,200);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource() == b1)
{
f1.setVisible(false);
Register r = new Register();
}
if(e.getSource() == b2)
{
f1.setVisible(false);
LoginRegister lr = new LoginRegister();
}
}
public static void main(String [] args)
{
Welcome n = new Welcome();
}
}
3) Register.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class Register implements ActionListener
{
Frame f2;
Button b3;
TextField tf1, tf2;
Label l1, l2;
Statement s;
Connection c;
String s1, s2;
Register()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c = DriverManager.getConnection("Jdbc:Odbc:Maya");
s = c.createStatement();
f2= new Frame("Register");
b3 = new Button("OK");
tf1 = new TextField(10);
tf2 = new TextField(10);
l1 = new Label("Login");
l2 = new Label("Password");
f2.add(l1);
f2.add(tf1);
f2.add(l2);
f2.add(tf2);
f2.add(b3);
tf2.setEchoChar('*');
f2.setLayout(new FlowLayout());
b3.addActionListener(this);
f2.setVisible(true);
f2.setSize(200,200);
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
public void actionPerformed(ActionEvent e1)
{
if(e1.getSource() == b3)
{
try
{
s1=tf1.getText();
s2=tf2.getText();
s.execute("insert into Login values('"+s1+"','"+s2+"')");
tf1.setText("");
tf2.setText("");
f2.setVisible(false);
Register1 r = new Register1();
}
catch(Exception ee2)
{
ee2.printStackTrace();
}
}
}
}
4) Register1.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class Register1 implements ActionListener
{
Frame f3;
Button b4;
Label l3;
Register1()
{
f3= new Frame("Register1");
b4 = new Button("Click Here");
l3 = new Label("Registered");
f3.add(l3);
f3.add(b4);
f3.setLayout(new FlowLayout());
b4.addActionListener(this);
f3.setVisible(true);
f3.setSize(200,200);
}
public void actionPerformed(ActionEvent e2)
{
if(e2.getSource() == b4)
{
f3.setVisible(false);
LoginRegister l = new LoginRegister();
}
}
}
5) LoginRegister.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class LoginRegister implements ActionListener
{
Frame f4;
Button b5;
Label l4, l5;
TextField tf3, tf4;
Connection c1;
Statement ss;
public String s3;
ResultSet rs;
LoginRegister()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c1 = DriverManager.getConnection("Jdbc:Odbc:Maya");
ss = c1.createStatement();
f4= new Frame("Login");
b5 = new Button("OK");
l4 = new Label("Login");
l5 = new Label("Password");
tf3 = new TextField(10);
tf4 = new TextField(10);
f4.add(l4);
f4.add(tf3);
f4.add(l5);
f4.add(tf4);
f4.add(b5);
tf4.setEchoChar('*');
f4.setLayout(new FlowLayout());
b5.addActionListener(this);
f4.setVisible(true);
f4.setSize(200,200);
}
catch(Exception ee2)
{
ee2.printStackTrace();
}
}
public void actionPerformed(ActionEvent e3)
{
if(e3.getSource() == b5)
{
try
{
rs = ss.executeQuery("select * from Login where login = '"+tf3.getText()+"'and pass ='"+tf4.getText()+"'");
if(rs.next())
{
f4.setVisible(false);
Valid v = new Valid(tf3.getText());
}
else
{
InValid iv = new InValid();
}
}
catch(Exception ee1)
{
ee1.printStackTrace();
}
}
}
}
6) InValid.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class InValid implements ActionListener
{
Frame f6;
Label l6;
Button b6;
InValid()
{
f6= new Frame("Invalid");
l6 = new Label("Invalid Login");
b6 = new Button("Click Here");
f6.add(l6);
f6.add(b6);
f6.setLayout(new FlowLayout());
b6.addActionListener(this);
f6.setVisible(true);
f6.setSize(200,200);
}
public void actionPerformed(ActionEvent e4)
{
if(e4.getSource() == b6)
{
LoginRegister l = new LoginRegister();
}
}
}
7) Valid.java
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class Valid
{
Frame f5;
Label l5;
TextField tf5;
Valid(String ss1)
{
f5= new Frame("Login");
l5 = new Label("Welcome");
tf5 = new TextField(ss1);
f5.add(l5);
f5.add(tf5);
f5.setLayout(new FlowLayout());
f5.setVisible(true);
f5.setSize(200,200);
}
}