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();
		}
		
	}

}