Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LAB 2 : Login
- package loginP;
- import java.awt.*;
- import java.applet.*;
- import java.awt.event.*;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import com.mysql.jdbc.PreparedStatement;
- public class loginP extends Applet implements ActionListener
- {
- /**
- *
- */
- private static final long serialVersionUID = 1L;
- Applet second;
- TextField pass,name;
- Connection con;
- String url="jdbc:mysql://localhost/user",uname="root",passw="student";
- Button b1,b2;
- public void init()
- {
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- con= DriverManager.getConnection(url, uname, passw);
- Label n=new Label("Name:",Label.CENTER);
- Label p=new Label("password:",Label.CENTER);
- name=new TextField(20);
- pass=new TextField(20);
- pass.setEchoChar('*');
- b1=new Button("submit");
- b2=new Button("register");
- add(n);
- add(name);
- add(p);
- add(pass);
- add(b1);
- add(b2);
- n.setBounds(70,90,90,60);
- p.setBounds(70,130,90,60);
- name.setBounds(280,100,90,20);
- pass.setBounds(200,140,90,20);
- b1.setBounds(100,260,70,40);
- b2.setBounds(180,260,70,40);
- b1.addActionListener(this);
- b2.addActionListener(this);
- }
- catch(Exception ae)
- {
- ae.printStackTrace();
- }
- }
- public void paint(Graphics g)
- {
- repaint();
- }
- @Override
- public void actionPerformed(ActionEvent e) {
- if (e.getSource() == b1)
- {
- try {
- Statement ps1=con.createStatement();
- String sql="select name,password from login";
- ResultSet rs = ps1.executeQuery(sql);
- String un,pw;
- un=name.getText();
- pw=pass.getText();
- int f=0,g=0;
- while(rs.next())
- {
- if((rs.getString(1).compareTo(un)==0) )
- {
- f=1;
- if((rs.getString(2).compareTo(pw)==0) )
- g=1;
- break;
- }
- }
- if(g==1&&f==1)
- {
- System.out.println("Welcome "+un+".!!!!");
- }
- else if(g==1&f==0)
- {
- System.out.println("Wrong password!!");
- }
- else
- System.out.println("User does not exist!!");
- }
- catch (SQLException e1) {
- // TODO Auto-generated catch block
- e1.printStackTrace();
- } }
- else
- {
- System.out.println("Button 2 was pressed");
- String uname,passw;
- uname=name.getText();
- passw=pass.getText();
- String a="INSERT into login values(?,?,?,?)";
- try{
- Statement ps1=con.createStatement();
- PreparedStatement pstmt = (PreparedStatement) con.prepareStatement(a);
- pstmt.setString(1,uname);
- pstmt.setString(2, passw);
- pstmt.setInt(3,25);
- pstmt.setString(4,"Teacher");
- pstmt.executeUpdate();
- System.out.println("Record is inserted into LOGIN table!");
- }catch(SQLException e1) {
- System.out.println(e1.getMessage());
- }
- second=null;
- second= getAppletContext().getApplet("Register");
- }
- }
- }
Add Comment
Please, Sign In to add comment