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");
			}

		}

	}