?? myjdbcpra_wangkj.java
字號:
package com.jk.jdbc;
import java.sql.*;
//import java.sql.Connection;
public class Myjdbcpra_wangkj {
public static void main(String[] args) {
String userName = "wangkj";
String passwd = "xinxin";
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@10.22.78.99:1521:XE";
Connection conn = null;
PreparedStatement pstmt = null;
//由于要做insert 操作,所以不定義結果集
try{
//注冊driver
Class.forName(driver);
//獲得連接
conn = DriverManager.getConnection(url,userName,passwd);
//3
String sql = "insert into test values(?,?)";
pstmt = conn.prepareStatement(sql);
//4執行sql語句
pstmt.setInt(2,100);
pstmt.setString(1,"Hello");
int result = pstmt.executeUpdate();
System.out.println(result);//處理結果
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(pstmt != null) pstmt.close();
if(conn != null) conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -