package com.test.t;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
public class Testupdate {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
new oracle.jdbc.driver.OracleDriver();
//等同于Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tiger");
stmt = conn.createStatement();
String sql = "insert into dept values(45,'Kanton','SH')";
stmt.executeUpdate(sql);//提交
} catch(SQLException e) {
e.printStackTrace();
} finally {//关闭连接
try{
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch(SQLException e){
e.printStackTrace();
}
}
}
}