Inserts Records into Access/SQL table - Java Database Connectivity

Home	»	Java	»	Advance Java	»	Java Database Connectivity	»	Inserts Records

This example inserts records into the Access table 'SchoolClasses' on the harddisk, using classes of the java.sql package the rows inserted.

•  A JDBC-ODBC bridge driver is loaded
•  A Connection to the database is made, using getConnection method()
•  Using the Connection object, SQL's 'Insert into' statement is sent to the database
•  A message is printed on the command line indicating the command was successful
•  Minimal exception handling is done

To insert rows into the table 'StudentTable' the executeUpdate() method is used. To display the results retrieved from the table the rs.next() method is used.

/* =========================================================== File Name : InsertRecords.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ //Inserting rows in to the Access table 'StudentTable' using Java code import java.sql.*; public class InsertRecords { public static void main(String args[ ] ) { Connection conn; Statement stmt; String query = "select * From StudentTable"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { System.err.print("ClassNotFoundException : "); System.err.println(e.getMessage( )); } try { conn = DriverManager.getConnection("jdbc:odbc:MyDsn"); stmt = conn.createStatement( ); //Inserting five records into the table 'StudentTable', using the INSERT statement stmt.executeUpdate("insert into StudentTable " +"values(1006, 'Gurmail', '12th', 'Muktsar')"); stmt.executeUpdate("insert into StudentTable " +"values(1007, 'Raman', '12th', 'Muktsar')"); stmt.executeUpdate("insert into StudentTable " +"values(1008, 'Laura', '12th', 'Muktsar')"); stmt.executeUpdate("insert into StudentTable " +"values(1009, 'Mirella', '12th', 'Muktsar')"); //Printing a message at the system prompt indicating rows inserted System.out.println("\nRecords Inserted\n\n"); //Querying the Access database to view the data inserted //using the RecordSet object rs ResultSet rs = stmt.executeQuery(query); //Printing a static 'Row Header' at the system prompt System.out.println("RollNo \t\t Name \t\tClass \t\t City\n"); //Retrieving records from the RecordSet rs and displaying them at the system prompt //This code uses a column name to extract a column value from the RecordSet while (rs.next( ) ) { int stu_rollno = rs.getInt("Stu_RollNO"); String stu_name = rs.getString("Stu_Name"); String stu_class = rs.getString("Stu_Class"); String stu_city = rs.getString("Stu_City"); System.out.println(stu_rollno + "\t\t" + stu_name + "\t\t" +stu_class+ "\t\t" +stu_city); } //Closing the Statement object stmt stmt.close( ); //Closing the connection object conn conn.close( ); } // End of try block // Minimal exception handling done here catch(SQLException ex) { System.err.println("SQLException: " + ex.getMessage( )); } } // End of main() method } // End of class InsertRecords


The Output of InsertRecords is as shown below:

Diagram 22.16 Inserts Records into Access StudentTable table

	Create the Database.
	Creating a DSN.
	Connecting to a Database.
	Creating & Executing Statements.
	Closing a database connection.

JDBC - Programming:

	View records from the Access table.
	Inserts records into the Access table.
	Updates records into the Access/SQL table.
	Deletes records from the Access table.
	Drops the Access/SQL table.

JDBC - Working With User Interfaces - Using Swing Compoents

	Inserts records into the Access/SQL table using Swing Components
	View records from the Access table/SQL using Swing JTable
	Updates records into the Access/SQL table using Swing Components
	Deletes records from the Access/SQL table using Swing Components