将指定sno学生记录的年龄都修改成指定sage.txt

因此本系统的目标就是让顾客方便快捷和满意的购物。为了达到这一目标

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();
}
}
}