Address Book Using Java Database Msaccess

  • Uploaded by: Vignesh
  • 0
  • 0
  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Address Book Using Java Database Msaccess as PDF for free.

More details

  • Words: 815
  • Pages: 7
address book using java database connectivity(jdbc-msaccess) -------------------------------------------------------------------------------Description : address book using java in frontnd and msaccess in backend.myprojects.address is the package,consists of four classes loginb,start,search,add. //loginb is the main class of the package. //there are total four classes(loginb,start,search,add) //this address book is made with the help of jdbc-odbc //frontend is java //backend is ms access //compile all the classes and then run the loginb class //it authenticates the user entry then proceeds //shekhar's address book package myprojects.addressbook; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class loginb{ public static void main(String args[]){ try{ final TextField tf1,tf2; Label l1,l2,l3; Button b1; final JFrame f = new JFrame("address book"); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); f.setSize(800,800); f.setLayout(null); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); final Connection con = DriverManager.getConnection("jdbc:odbc:student","","");//student is the (data source name) /*procedure:go to cntrl panel,then select administrative services ,then select odbc,then select or add the dsn.*/ final Statement st = con.createStatement(); Font f1 = new Font("sansserif",Font.BOLD,24); l3 = new Label("SHEKHAR'S ADDRESS BOOK"); l3.setBounds(150,10,800,40); l3.setFont(f1); f.add(l3); l1= new Label("USER NAME :"); l1.setBounds(200,200,100,30); f.add(l1); tf1 = new TextField(); tf1.setBounds( 400,200,100,30);

f.add(tf1); l2= new Label("PASSWORD :"); l2.setBounds(200,250,100,30); f.add(l2); tf2 = new TextField(); tf2.setEchoChar('*'); tf2.setBounds( 400,250,100,30); f.add(tf2); b1 = new Button("LOGIN"); b1.setBounds(300,350,50,30); f.add(b1); b1.addActionListener( new ActionListener(){ public void actionPerformed(ActionEvent e){ try{ String s1 = tf1.getText(); String s2 = tf2.getText(); System.out.println("got data "); ResultSet rs = st.executeQuery("Select * From login"); System.out.println("table select"); while(rs.next()) {String s3= rs.getString(1); String s4=rs.getString(2); System.out.println("data entered"+s1+" "+s2); System.out.println("inside while"+s3+" "+s4); if(s3.equals(s1) && s4.equals(s2)) { try{ f.hide(); Start s = new Start();

} }

} catch(Exception e3){}

tf1.setText(""); tf2.setText(""); } catch(Exception e1){System.out.println("ERROR 1"+e1);} } });

f.show(); } catch(Exception e2){System.out.println("ERROR 2"+e2);} } } __________________________________________________________________________ ______ //class start package myprojects.addressbook; import java.awt.*; import java.awt.event.*; import javax.swing.*; //import address.*; public class Start { public Start() throws Exception{

Button b1,b2; JFrame jf; jf=new JFrame("START"); jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); jf.setSize(800,800); jf.setLayout(null); Font f1 = new Font("sansserif",Font.BOLD,24); Label l3 = new Label("SHEKHAR'S ADDRESS BOOK"); l3.setBounds(150,10,800,40); l3.setFont(f1); jf.add(l3); b1 = new Button("ADD"); b1.setBounds(250,150,100,40); b1.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e) { try{ Add a = new Add(); } catch(Exception e2){} } }); b2 = new Button("SEARCH"); b2.setBounds(250,100,100,40); b2.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e1) { try{ Search b = new Search(); } catch(Exception e3){} } }); jf.add(b1); jf.add(b2); jf.show(); } } __________________________________________________________________________ _______ ///class search package myprojects.addressbook; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class Search{ public Search(){ final JFrame jf = new JFrame("Search"); jf.setSize(800,800); jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); jf.setLayout(null);

Font f1 = new Font("sansserif",Font.BOLD,24); Label l3 = new Label("SHEKHAR'S ADDRESS BOOK"); l3.setBounds(150,10,800,40); l3.setFont(f1); jf.add(l3); final TextArea ta = new TextArea(); ta.setBounds(10,120,1000,600); ta.setEditable(false); jf.add(ta); Label l = new Label ("search by name:"); l.setBounds(10,60,100,30); jf.add(l); final TextField tf = new TextField(); tf.setBounds(120,60,100,30); jf.add(tf); Label l1 = new Label ("TELEPHONE:"); l1.setBounds(240,60,100,30); jf.add(l1); final TextField tf1 = new TextField(); tf1.setBounds(360,60,100,30); jf.add(tf1); Button b1 = new Button("SEARCH"); b1.setBounds(480,60,50,30); b1.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e) { try{ String s6,s,s1,s3,s4,s0="1233"; Date d; Long s2,s5; s = tf.getText(); s6=tf1.getText(); if(s6.equals("")) s5=Long.parseLong(s0); else s5 = Long.parseLong(tf1.getText()); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); final Connection con = DriverManager.getConnection("jdbc:odbc:student","",""); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("Select * From addressb"); while(rs.next()){ s1 = rs.getString(1); s2 = rs.getLong(2); s3 = rs.getString(3); s4 = rs.getString(4); d = rs.getDate(5); System.out.println("gotstring"); if((s1.equals(s))||(s2.equals(s5))){ System.out.println("string equal");

ta.append(s1+" "+d);

"+ s2+ "

" + s3+ "

" + s4 + "

ta.append("
); }//eoif }//eowhlie } catch(Exception e1){System.out.println("ERROR="+e1);} } });

jf.add(b1); Button b2 = new Button("ADD"); b2.setBounds(550,60,50,30); b2.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e) { try{ Add a = new Add(); } catch(Exception e2){} } }); jf.add(b2); Button b3 = new Button("EXIT"); b3.setBounds(620,60,50,30); b3.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e2) { try{ System.exit(0); } catch(Exception e3){} } }); jf.add(b3); jf.show(); } } _________________________________________________________________________ //class add package myprojects.addressbook; import java.awt.*; import java.awt.event.*; import java.sql.*; import javax.swing.*; public class Add { public Add() throws Exception{ final TextField tf1,tf2,tf3,tf4,tf5; Label l1,l2,l3,l4,l5,l6; Button b1,b2,b3; final JFrame f; f= new JFrame("ADDRESS BOOK"); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); f.setSize(800,800); f.setLayout(null);

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); final Connection con = DriverManager.getConnection("jdbc:odbc:student","",""); Font f1 = new Font("sansserif",Font.BOLD,24); l6 = new Label("SHEKHAR'S ADDRESS BOOK"); l6.setBounds(150,10,800,40); l6.setFont(f1); f.add(l6); l1= new Label("NAME :"); l1.setBounds(200,200,100,30); //l1.setFont(f1); f.add(l1); tf1 = new TextField(); tf1.setBounds( 400,200,100,30); f.add(tf1); l2= new Label("PHONE NO. :"); l2.setBounds(200,250,100,30); f.add(l2); tf2 = new TextField(); tf2.setBounds( 400,250,100,30); f.add(tf2); l3= new Label("Address :"); l3.setBounds(200,300,100,30); f.add(l3); tf3 = new TextField(); tf3.setBounds( 400,300,100,30); f.add(tf3); l4= new Label("Email id:"); l4.setBounds(200,350,100,30); f.add(l4); tf4 = new TextField(); tf4.setBounds( 400,350,100,30); f.add(tf4); l5= new Label("Birth date:"); l5.setBounds(200,400,100,30); f.add(l5); tf5 = new TextField(); tf5.setBounds( 400,400,100,30); f.add(tf5); b1 = new Button("ENTER"); b1.setBounds(300,450,50,30); b1.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent e){

try{ String s1,s2,s3,s4,s5; s1 = tf1.getText(); s2 = tf2.getText(); s3 = tf3.getText(); s4 = tf4.getText(); s5 = tf5.getText(); PreparedStatement ps = con.prepareStatement("insert into addressb values(?,?,?,?,?)"); ps.setString(1,s1); ps.setString(2,s2); ps.setString(3,s3); ps.setString(4,s4); ps.setString(5,s5); int i = ps.executeUpdate(); System.out.println("Row Updated:"+i); tf1.setText(""); tf2.setText(""); tf3.setText(""); tf4.setText(""); tf5.setText(""); } catch(Exception e1){System.out.println("ERROR:"+e1);} } }); f.add(b1); b2 = new Button("SEARCH"); b2.setBounds(400,450,50,30); b2.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e2) { try{ Search b = new Search(); } catch(Exception e3){} } }); f.add(b2); b3 = new Button("EXIT"); b3.setBounds(480,450,50,30); b3.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e2) { try{ System.exit(0); } catch(Exception e3){} } }); f.add(b3); f.show(); } }

Related Documents

Address Book In Java
June 2020 8
Java Database
June 2020 8
Address Book
June 2020 12
Address Book
April 2020 17
Using Java
October 2019 25

More Documents from ""