?? myjdbcupdate_zhangzhen.java
字號:
package com.jk.jdbc;
import java.sql.*;
public class MyJdbcUpdate_zhangzhen {
/**
* @param args
*/
public static void main(String[] args) {
String userName = "zhangzhen";
String passwd = "zhangzhen";
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@10.22.78.99:1521:XE";
Connection conn = null;
PreparedStatement pstmt = null;
//由于要做insert操作,所以不定義結(jié)果集ResultSet
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,userName,passwd);
String sql = "update test set name=? where id=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(2,100);
pstmt.setString(1, "hello zhangzhen");
pstmt.executeUpdate();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(pstmt != null) pstmt.close();
if(conn != null) conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
// TODO Auto-generated method stub
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -