Java JDBC Update Table

Chapter: JDBC Last Updated: 10-09-2016 06:59:11 UTC

Program:

            /* ............... START ............... */
                
import java.sql.*;

public class JavaJDBCUpdatTable {

	public static void main(String[] args) {
		try {
			Class.forName("org.apache.derby.jdbc.ClientDriver");
		} catch (ClassNotFoundException e) {
			System.out.println("Class not found " + e);
		}
		try {
			Connection con = DriverManager.
					getConnection("jdbc:derby://localhost:1527/testDb", "username", "password");
			Statement stmt = con.createStatement();
			String query1 = "update emp set name='ravi' where id=2";
			String query2 = "delete  from emp where id=1";
			String query3 = "insert into emp values (1,'ronak','manager')";
			stmt.execute(query1);
			stmt.execute(query2);
			stmt.execute(query3);
			ResultSet rs = stmt.executeQuery("SELECT * FROM emp");
			System.out.println("id  name    job");
			while (rs.next()) {
				int id = rs.getInt("id");
				String name = rs.getString("name");
				String job = rs.getString("job");
				System.out.println(id + "   " + name + "    " + job);
			}
		} catch (SQLException e) {
			System.out.println("SQL exception occured" + e);
		}
	}
}
                /* ............... END ............... */
        

Output

id  name    job
2   ravi    trainee
1   ronak    manager

Tags

JDBC Update Table, Java, JDBC

Similar Programs Chapter Last Updated
Java Execute Multiple SQL Statements JDBC 10-09-2016
Java JDBC Savepoint And Rollback JDBC 10-09-2016
Java JDBC Commit Statement Example JDBC 10-09-2016
Java JDBC Sort Table Contents JDBC 10-09-2016
Java JDBC Search Table Contents JDBC 10-09-2016
Java Retrieve Table Contents JDBC 10-09-2016
Java JDBC Table Edit Example JDBC 10-09-2016
Java Connect To Database Example JDBC 10-09-2016
JDBC SQL Cursors Using CallableStatement JDBC 26-06-2016
JDBC Batch Execution In Java Using CallableStatement JDBC 26-06-2016
JDBC Stored Procedure Returns OUT Parameters In Java JDBC 23-06-2016
JDBC Stored Procedure Execution In Java JDBC 23-06-2016
JDBC Prepared Statement With ResultSet In Java Example JDBC 18-06-2016
JDBC Prepared Statement In Java Example JDBC 18-06-2016
JDBC Update Query In Java Example JDBC 18-06-2016
JDBC Query Execution In Java Example JDBC 18-06-2016
JDBC Query In Java Example JDBC 18-06-2016
Java JDBC Connection Example JDBC 18-06-2016

1