netinsert_yingjj.java

来自「java的团队合作代码」· Java 代码 · 共 37 行

package com.jk.test;
import java.sql.*;
import java.util.*;
public class NetInsert_yingjj {
	private String driver="oracle.jdbc.driver.OracleDriver";
	private String url="jdbc:oracle:thin:@10.22.78.99:1521:XE";
	private String userName="yingjj";
	private String passwd="y7445914";
	private Connection conn=null;
	private PreparedStatement pstmt=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_yingjj stu=(Student_yingjj)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) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}