updatesample.java

来自「因此本系统的目标就是让顾客方便快捷和满意的购物。为了达到这一目标」· Java 代码 · 共 26 行

import java.sql.*;
class UpdateSample{
   public static void main(String args[])
{
  String Sno[] = {"1","2","3","4","5"};
  int Sage[] = {16,17,18,19,20};
     try{
      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url = "jdbc:sqlserver://localhost;databaseName=Student";
Connection conn = DriverMananger.getConnection(url, "MyUserName", "MyPWD")；
PreparedStatement psmt = conn.preparedStatement("UPDATE Student"+
" SET Sage = ? " + 
" WHERE Sno = ? ");
for(int i=0 ; i<Sno.length ; i++)
{
    psmt.setInt(1 , Sage[i]);
    psmt.setString(2 ,Sno[i]);
    psmt.executeUpdate();
}        
        conn.close();
}catch(SQLException e){
   e.printStack();
}
}
}