Java Reference
In-Depth Information
public class PStatement {
private static String dbUserName = "sa";
private static String dbPassword = "dba";
public static void main(String args[]){
int[][] Orders = {{1001,327,2},
{1001,412,1},
{1001,906,5},
{1002,111,7},
{1002,112,19}};
try {
Class.forName("com.inet.pool.PoolDriver");
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName( "JUPITER" );
tds.setDatabaseName( "MEMBERS" );
tds.setUser( dbUserName );
tds.setPassword( dbPassword );
DataSource ds = tds;
Connection con = ds.getConnection(dbUserName,dbPassword);
String SQLCmd =
"INSERT INTO ORDERED_ITEMS (ORDER_NUMBER,ITEM_NUMBER,QTY)
VALUES(?,?,?)";
PreparedStatement pstmt = con.prepareStatement(SQLCmd);
for(int i=0;i<5;i++){
pstmt.setInt(1, Orders[i][0]);
pstmt.setInt(2, Orders[i][1]);
pstmt.setInt(3, Orders[i][2]);
pstmt.executeUpdate();
}
con.close();
}catch(ClassNotFoundException e1){
System.err.println(e1.getMessage());
}catch(SQLException e2){
System.err.println(e2.getMessage());
}
}
}
