将调用该存储过程执行修改操作.txt

来自「因此本系统的目标就是让顾客方便快捷和满意的购物。为了达到这一目标」· 文本 代码 · 共 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")；
CallableStatement cs = conn.prepareCall("{call Update_Age (?,?)}",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATEABLE);
for(int i=0 ; i<Sno.length ; i++)
{
    cs.setInt(1 , Sage[i]);
    cs.setString(2 ,Sno[i]);
    cs.executeUpdate();
}        
        conn.close();
}catch(SQLException e){
   e.printStack();
}
}
}