import java.sql.*;
public class Batchopdateringer
{
	public static void main(String[] arg) throws Exception
	{
		Class.forName("com.mysql.jdbc.Driver");
		Connection con = DriverManager.getConnection("jdbc:mysql:///test");

		PreparedStatement pstmt = con.prepareStatement(
		                            "INSERT INTO kunder (navn,kredit) VALUES(?, ?)");

		pstmt.setString(1, "Hans");
		pstmt.setInt(2, 142);
		pstmt.addBatch();

		pstmt.setString(1, "Grethe");
		pstmt.setInt(2, 242);
		pstmt.addBatch();

		// send ændringer til databasen
		pstmt.executeBatch();
	}
}