?? netinsert_zhangzhen.java
字號:
package com.jk.test;
import java.sql.*;
import java.util.*;
public class NetInsert_zhangzhen {
private String driver = "oracle.jdbc.driver.OracleDriver";
private String url = "jdbc:oracle:thin:@10.22.78.99:1521:XE";
private String userName = "zhangzhen";
private String passwd = "zhangzhen";
private PreparedStatement pstmt = null;
private Connection conn = null;
public void insert(Collection c){
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,userName,passwd);
String sql = "insert into student values(?,?,?)";
pstmt = conn.prepareStatement(sql);
Iterator iter = c.iterator();
while(iter.hasNext()){
Student_zhangzhen stu = (Student_zhangzhen)iter.next();
String name = stu.getName();
int age = stu.getAge();
int gender = stu.getGender();
pstmt.setString(1, name);
pstmt.setInt(2,age);
pstmt.setInt(3,gender);
pstmt.executeUpdate();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -