JDBC ODBC Bridge

import java.io.*;
import java.util.Scanner;
import java.sql.*;

class database {
	Connection con;
	Statement st;
	ResultSet res;

	database() {
		try {

			/* Connect database with JDBC and ODBC bridge connection */
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/record.mdb");
		}
		catch(Exception ex) {
			System.out.println(ex);
		}
	}

	void insert(String name, String ph) throws Exception {

		/* Insert record into the database */
		String sql="INSERT INTO friend (f_name, f_ph) VAlUES('"+name+"','"+ph+"')";
		st = con.createStatement();
		st.execute(sql);
		System.out.println("Data Inserted Successfully!");
		st.close();
	}

	void select(String name) throws Exception {

		/* Fetch record from database */
		String sql="SELECT * FROM friend WHERE f_name ='"+name+"'";
		st = con.createStatement();
		res = st.executeQuery(sql);
		boolean rec = res.next();
		while(rec) {
			System.out.println("Name: "+res.getString("f_name"));
			System.out.println("Phone: "+res.getString("f_ph"));
			rec=res.next();
		}
		res.close();
		st.close();
	}

	void select() throws Exception {

		/* Fetch records from database */
		String sql="SELECT * FROM friend";
		st = con.createStatement();
		res = st.executeQuery(sql);
		boolean rec = res.next();
		while(rec) {
			System.out.println("Name: "+res.getString("f_name"));
			System.out.println("Phone: "+res.getString("f_ph"));
			rec=res.next();
		}
		res.close();
		st.close();
	}

	void update(String name, String ph) throws Exception {

		/* Update record in the database */
		String sql="UPDATA friend SET f_ph = '"+ph+"' WHERE f_name = '"+name+"'";
		st = con.createStatement();
		st.execute(sql);
		System.out.println("Data Updated Successfully!");
		st.close();
	}

	void delete(String name) throws Exception {

		/* Delete record from database */
		String sql="DELETE FROM friend WHERE f_name = '"+name+"'";
		st = con.createStatement();
		st.execute(sql);
		System.out.println("Data Deleted Successfully!");
		st.close();
	}
}

class jdbcodbc {
	public static void main(String args[ ]) throws Exception {
		database db = new database();
		Scanner scan = new Scanner(System.in);
		String name, ph;
		int opt = 0;
		while(opt != 6) {
			System.out.println("1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit");
			System.out.println("Enter your choice:");
			opt = Integer.parseInt(scan.nextLine());
			switch(opt) {
				case 1:
					System.out.println("Please Enter Name:");
					name = scan.nextLine();
					System.out.println("Please Enter Phone:");
					ph = scan.nextLine();
					db.insert(name, ph);
					break;
				case 2:
					System.out.println("Please Enter the Name:");
					db.select(scan.nextLine());
					break;
				case 3:
					db.select();
					break;
				case 4:
					System.out.println("Please Enter Name which you want to update:");
					name = scan.nextLine();
					System.out.println("Please Enter new Phone no:");
					ph = scan.nextLine();
					db.update(name, ph);
					break;
				case 5:
					System.out.println("Please Enter Name which you want to delete:");
					name = scan.nextLine();
					db.delete(name);
					break;
				case 6:
					System.out.println("Bye Bye!");
					db.con.close();
					System.exit(0);
					break;
				default:
					System.out.println("Invalid choice!");
			}
		}
	}
}






/* Output */
1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit
1

Please Enter Name:
ABC

Please Enter Phone:
1234

Data Inserted Successfully!

1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit
1

Please Enter Name:
DEF

Please Enter Phone:
5678

1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit
2

Please Enter the Name:
ABC

Name: ABC
Phone: 1234

1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit
3

Name: ABC
Phone: 1234
Name: DEF
Phone: 5678

1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit
4

Please Enter Name which you want to update:
ABC

Please Enter new Phone no:
4321

Data Updated Successfully!
1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit
5

Please Enter Name which you want to delete:
ABC

Data Deleted Successfully!

1. Insert 2. Select by Name 3. Select All 4. Update 5. Delete 6. Exit
6

Bye Bye!

Comments (0)

  • To add your comment please or

We use cookies to improve your experience on our site and to show you personalised advertising. Please read our cookie policy and privacy policy.

Got It!