address book using java database connectivity(jdbc-msaccess) - JDBC (Java Database Connectivity) Source Code in Java

Special : Web Developer's Collection CD-ROM
50,000+ Web Templates, Logos, Cliparts, Scripts. Order Now!

Add to Favorites Make Home Page

18124 Online

Language Categories

Source Codes Home
Project Ideas New!
Interview Questions
FAQs Home
ASP Home: ASP Source Codes; ASP Script Directory New!; ASP .Net Script Directory New!; ASP Interview Questions; ASP FAQs; ASP How Tos
C Home: C Source Codes; C Script Directory New!; C Interview Questions; C FAQs; C How Tos
C++ Home: C++ Source Codes; C++ Script Directory New!; C++ Interview Questions; C++ FAQs; C++ How Tos
Java Home: Java Source Codes; Java Directory New!; Java Interview Questions; Java FAQs; Java How Tos
JavaScript Home: JavaScript Directory New!; JavaScript Source Codes; JavaScript FAQs; JavaScript How Tos
COBOL Home: COBOL Source Codes; COBOL FAQs; COBOL How Tos
Pascal Home: Pascal Source Codes; Pascal FAQs; Pascal How Tos
PHP Script Directory New!
Python Script Directory New!
Perl & CGI Script Directory New!
Flash Script Directory New!
CFML Script Directory New!
Remotely Hosted Scripts New!
Tools & Utilities Directory New!
XML Script Directory New!
Best Programmers: Amit Mathur; Vishal Bhardwaj; Deepesh Jain
Vyom NetWork

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

9500+ Pages
9000 Question & Answers
All Tech. Categories

14 MB Content

Get it now !!

Home » Java Home » JDBC (Java Database Connectivity) Home » address book using java database connectivity(jdbc-msaccess)

A D V E R T I S E M E N T

Title	address book using java database connectivity(jdbc-msaccess)
Author	shekhar bansal
Author Email	shekhar.bansal [at] yahoo.co.in
Description	address book using java in frontnd and msaccess in backend.myprojects.address is the package,consists of four classes loginb,start,search,add.
Category	Java » JDBC (Java Database Connectivity)
Hits	474510
Code	Select and Copy the Code
//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+" "+ s2+ " " + s3+ " " + s4 + " "+d); 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 Source Codes

Script Name Author

Sending mail Using JavaMail to Yahoo and Gmail accounts sai prasad

Simple Program in Java to Implement Multithreading Satish.K

Simple Calculator in Java Using Remote Method Invocation Satish.K

Guest Book Application Using Servlets Satish.K

String Manipulation Using Stringification Satish.K

String Manipulation Using Stringification Satish.K

Moving Ball Application Using Java Beans Satish.K

Rapid Roll game subrahmanyeswararao

student mgm arpan

Sourav Datta

Download Manager Sagar

Address Book in Java Rahul Chouhan

sun Steganography B.Rajavel

Connecting Java with MS-Access - Inserting data in Aseem

Address Book in Java Rahul Chouhan

A D V E R T I S E M E N T

Google Groups Subscribe to SourceCodesWorld - Techies Talk

Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
Discuss Programming Problems and Freshers Jobs related issues here.
Discuss Final Year Project Ideas here.