Transient state? Transient state means, Object is neither associated with Session nor present in Database. When you don’t have record in the database, then you will not be able to update the record. So when the object is transient state you will not call update() method. Persistent state? Persistent state means, Object is associated with […]
Program to update table data using JDBC’s java.sql.PreparedStatement API.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
package com.c2j.jdbc.preparedstatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class JDBCUpdateTableUsingPreparedStatement { public static void main(String[] args) throws SQLException { Connection con = null; PreparedStatement pstmt = null; int rows=0; String sql = "UPDATE EMPLOYEE SET LAST=? WHERE ID=?"; try { con = getOracleDBConnection(); pstmt = con.prepareStatement(sql); pstmt.setString(1, "SUMANTH"); pstmt.setInt(2, 1); rows=pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }finally { if (pstmt != null) { pstmt.close(); } if (con != null) { con.close(); } } System.out.println("Number of Rows updated in EMPLOYEE table = "+rows); } private static Connection getOracleDBConnection(){ //Here TEST is oracle database name. String ORACLE_DB_CONNECTION = "jdbc:oracle:thin:@localhost:1521:TEST"; String ORACLE_DB_USER = "system"; String ORACLE_DB_PASSWORD = "system"; /* From JDBC 4.0(from Java6) onwards we no need to load data base driver * using class.forName(); Just add the database driver * jar(ojdbc6.jar for oracle) in the class path. * It will load when Drivermanager.getConnection method called. */ Connection oracleDbConnection = null; try { oracleDbConnection = DriverManager.getConnection (ORACLE_DB_CONNECTION, ORACLE_DB_USER,ORACLE_DB_PASSWORD); return oracleDbConnection; } catch (SQLException e) { e.printStackTrace(); } return oracleDbConnection; } } |
Output:
|
1 2 3 4 5 |
Number of Rows Updated in EMPLOYEE table = 1 |
In Database:
Program to update table data using JDBC’s java.sql.Statement API.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
package com.c2j.jdbc.statement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class JDBCUpdateTableUsingStatement { public static void main(String[] args) throws SQLException { Connection con =null; Statement stmt = null; int rows=0; String sql = "UPDATE EMPLOYEE SET LAST='SUMANTH' WHERE ID=1"; try { con =getOracleDBConnection(); stmt = con.createStatement(); rows=stmt.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); }finally { if (stmt != null) { stmt.close(); } if (con != null) { con.close(); } } System.out.println("Number of Rows updated in EMPLOYEE table = "+rows); } private static Connection getOracleDBConnection(){ //Here TEST is oracle database name. String ORACLE_DB_CONNECTION = "jdbc:oracle:thin:@localhost:1521:TEST"; String ORACLE_DB_USER = "system"; String ORACLE_DB_PASSWORD = "system"; /* From JDBC 4.0(from Java6) onwards we no need to load data base driver * using class.forName(); Just add the database driver * jar(ojdbc6.jar for oracle) in the class path. * It will load when Drivermanager.getConnection method called. */ Connection oracleDbConnection = null; try { oracleDbConnection = DriverManager.getConnection (ORACLE_DB_CONNECTION, ORACLE_DB_USER,ORACLE_DB_PASSWORD); return oracleDbConnection; } catch (SQLException e) { e.printStackTrace(); } return oracleDbConnection; } } |
Output:
|
1 2 3 4 5 |
Number of Rows updated in EMPLOYEE table = 1 |
In Database: