jdbc批量插入数据

1.util包

package com.ce.duo;

import java.sql.DriverManager;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;

public class Util {
	public static Connection getConn() {
	    String driver = "com.mysql.jdbc.Driver";
	    String url = "jdbc:mysql://localhost:3306/student";
	    String username = "root";
	    String password = "root";
	    Connection conn = null;
	    try {
	        Class.forName(driver); //classLoader,加载对应驱动
	        conn = (Connection) DriverManager.getConnection(url, username, password);
	    } catch (ClassNotFoundException e) {
	        e.printStackTrace();
	    } catch (SQLException e) {
	        e.printStackTrace();
	    }
	    return conn;
	}
}

2.实体类

package com.ce.duo;


public class WtIdxDataDomain{
	private String username;
	private String age;
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	
}

3.进行插入数据的类

package com.ce.duo;

import java.security.interfaces.RSAKey;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.mysql.jdbc.Connection;

public class InsertData {
	private Connection conn = Util.getConn();

	public void insertStudent(List<Student> list) throws SQLException {
		String sql = "insert into student values(?,?)";
		PreparedStatement pstmt = (PreparedStatement) conn.prepareStatement(sql);
	
		for (Student widd : list) {
			try {
				pstmt.setString(1, widd.getUsername());
				pstmt.setString(2, widd.getAge());
				pstmt.addBatch();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		try {
			pstmt.executeBatch();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}



}

4.测试类

package com.ce.duo;



public class Test {

	public static void main(String[] args) throws IOException,
		List<Studnet> list=new ArrayList<>();		
        Student student=new Student();
        student.setUsername("张三");
        studnet.setAge("20");
        Student student1=new Student();
        student1.setUsername("张三");
        studnet1.setAge("20");
        Student student2=new Student();
        student2.setUsername("张三");
        studnet2.setAge("20");
        list.add(student);
        list.add(student1);
        list.add(student2);
        InsertData newData = new InsertData();
        newData.insertStudnet(list);
	}

}