/*
* 1. Registered
*/
Mount registered SQL Server Driver
Class.forName ("Com.microsoft.jdbc.sqlserver.SQLServerDriver");//Load Driver
Java.sql.DriverManager.registerDriver (New Com.microsoft.jdbc.sqlser.SQLServerDriver ());
Mount Registration Oracledriver
Class.forName ("Oracle.jdbc.driver.OracleDriver");
Java.sql.DriverManager.registerDriver (New Oracle.jdbc.driver.OracleDriver ());
Mount Registration Mysqldriver
Class.forName ("Com.mysql.jdbc.Driver");
Java.sql.DriverManager.registerDriver (New Com.mysql.jdbc.Driver ());
/*
* 2. Establish a connection
*/
Connection con = drivermanager.getconnection (Dburl,username,password);
Dburl (SQL Server): "Jdbc:microsoft:sqlserver://localhost:1433;databasename=dbname"
Dburl (MySQL): "Jdbc:mysql://localhost:3306/dbname"
Dburl (oracal): "Jdbc:oracle:thin: @localhost: 1521:sid"//SID:
/*
* 3. Create a Statement object
*/
Statement Stamt = Conn.createstatement ();
/*
* 4. Calling SQL statements
*/
String sql = "SELECT * from EMP";
Or
String sqls = "Update emp set name = ' Qun ' where emp_id= ' S123 '";
ResultSet rs = stamt.executequery (SQL);
Or
ResultSet rs = stamt.executeupdate (SQLS);
/*
* 5. accessing result Sets
*/
while (Rs.next ()) {
String col0 = rs.getstring ("emp_id");
..............
Print or make a deal
}
/*
* 6. Close Resource
*/
Rs.close ();//Result set
Stamt.close ();//Execute Object
Conn.close ();//Database connection
/**
* Transaction Processing Section
*/
Set the rollback point
try{
..... .....
Conn.setautocommit (false);//Prohibit auto-commit
Stamt = Conn.createstatement ();//Create operation
Stamt.executeupdate ("Update emp set name= ' Tom ' where emp_id= ' S123 '");
Con.commit ();//Things Submitted
}catch (...) {
try{
Conn.rollback ();//thing rollback: Rollback if operation is unsuccessful
}catch (...) {
... ....
}
}finaly{
.... Close Resource
}
Share-Initial JDBC operation steps