Update Records into Access/SQL table - Java Database Connectivity

Home	»	Java	»	Advance Java	»	Java Database Connectivity	»	Update Records

This example updates records into the Access table 'StudentTable' on the harddisk, using classes of the java.sql package and 'Views' 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 'Update 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 Update 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 : UpdateRecords.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ //Update rows in to the Access table 'StudentTable' using Java code import java.sql.*; public class UpdateRecords { public static void main(String args[ ] ) { Connection conn; Statement stmt; String query = "select * From StudentTable Where Stu_RollNO="+1006; 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( ); //Updating one record into the table 'StudentTable', using the INSERT statement stmt.executeUpdate("update StudentTable "+"set Stu_Name='Ramesh'"+" where Stu_RollNO=1006"); // Printing a message at the system prompt indicating rows updated System.out.println("\nRecords Updated\n\n"); // Querying the Access database to view the data updated // 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 InsertProduct

The Output of UpdateRecords is as shown below:

Diagram 22.17 Update 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/SQL table.
	Inserts records into the Access/SQL table.
	Updates records into the Access/SQL table.
	Deletes records from the Access/SQL 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