JAVA Program to create login page with Database Connectivity

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

class Framelogin extends JFrame implements ActionListener
{
    JTextField username;
    JPasswordField password;
    JLabel unm, pass;
    JButton submit,clear,login;
    Framelogin()
    {
        setTitle("Login Frame");
        setSize(500,300);
        setLocation(500,200);
        setLayout(null);
        unm=new JLabel("Username");
        pass=new JLabel("Password");
        username=new JTextField(20);
        password=new JPasswordField(10);
        submit=new JButton("Submit");
        clear=new JButton("Clear");
        login=new JButton("Login");
        unm.setBounds(50,50,100,20);
        username.setBounds(180,50,200,20);
        pass.setBounds(50,90,100,20);
        password.setBounds(180,90,200,20);
        login.setBounds(50,130,100,30);
        submit.setBounds(200,130,100,30);
        clear.setBounds(350,130,100,30);
        add(unm);
        add(username);
        add(pass);
        add(password);
        add(submit);
        add(clear);
        add(login);
        login.addActionListener(this);
        clear.addActionListener(this);
        submit.addActionListener(this);
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
       
    }
    public void actionPerformed(ActionEvent e)
    {

        if(e.getSource()==clear)
        {
            username.setText("");
            password.setText("");
        }
        else if(e.getSource()==login)
        {
            String s1=username.getText();
            String s2=password.getText();
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                System.out.println("Driver loaded");
                Connection con = DriverManager.getConnection("jdbc:odbc:mydsn","","");
                  System.out.println("Connection created");
                   Statement st = con.createStatement();
                   System.out.println("Statment Created");
                   String query="select passworddd from Loginn where usernameee='"+s1+"'";
                    ResultSet rs=st.executeQuery(query);
                    System.out.println("Query executed");
                    rs.absolute(1);
                    String pa=rs.getString(1);
                    System.out.println(pa);
                    if(pa.equals(s2))
                     JOptionPane.showMessageDialog(null,"Login Successfully");
                     else
                JOptionPane.showMessageDialog(null,"incorrect password", "Error", JOptionPane.ERROR_MESSAGE);
            }
            catch(Exception ee)s
            {

            }
               
           
        }
        else if(e.getSource()==submit)
        {
            String s1=username.getText();
            String s2=password.getText();
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                System.out.println("Driver loaded");
                Connection con = DriverManager.getConnection("jdbc:odbc:mydsn","","");
                 System.out.println("Connection created");
                   Statement st = con.createStatement();
                    System.out.println("Statment Created");
                    st.execute("insert into Loginn values('"+s1+"','"+s2+"')");
                    System.out.println("Record Inserted");
            }
            catch(Exception ee)
            {

            }
        }
    }
}

class Login
{
    public static void main(String argsp[])
    {
        new Framelogin();
    }

}

Comments

Post a Comment

Popular posts from this blog

Simulator Program of Addition of TWO Number

we have a given smaco program .then we generate opcod of these program & it stored in a one new file dot txt(.txt) . next is write c progarmming to corresponding smaco program & opcode list. The Opcode List of Addition of Two number   030007 011007 051008 061008 051009 063009 040079 111000 The C program of Addition of Two number(of given smaco program) #include<stdio.h> #include<string.h> void main() {     FILE *fp;     char a[10]; long int b; int op; int x[2],i=0; register mem; register areg;        fp=fopen("opcode.txt","r");     while((fgets(a,4096,fp))!=NULL)        {         //puts(a);         //b='a'+0;         sscanf(a,"%ld",&b);     op=b/10000;         switch(op)       ...
Read more

JAVA Appelet program

import java.awt.*; import java.applet.*; import javax.swing.*; /* <applet code="ak" width=500 height=300> </applet> */ public class ak extends Applet     {     JLabel ak,sg;     JTextField aj,sp;         public void init()     {     ak=new JLabel("Enter Name");     sg=new JLabel("Enter LASTNAME");     aj=new JTextField(50);     sp=new JTextField(50);     setLayout(null);     add(ak);     add(aj);     add(sg);     add(sp);     ak.setBounds(30,50,100,30);     aj.setBounds(150,50,250,30);     sg.setBounds(30,100,300,30);     sp.setBounds(150,100,250,30);                        }    public void distr...
Read more

simulator program of Number is minimun or maximun greater than zero

here in this program the smaco program is given .firstly generate there opcode and save as file name dot txt (.txt).write c program accese by file handling . Opcode of program is given below 090007 090008 041007 011008 051010 100010 110000 C program is given below #include<stdio.h> #include<string.h> void main() {     FILE *fp;     char a[10]; long int b; int op; int x; int NM; register areg;        fp=fopen("op.txt","r");     while((fgets(a,4096,fp))!=NULL)        {         //puts(a);         //b='a'+0;         sscanf(a,"%ld",&b);     op=b/10000;         switch(op)         {             case 1:            ...
Read more