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