import java.sql.*;
public class UsePreStatement {
  public static void main(String agrs[]) {
    String driver   = "org.gjt.mm.mysql.Driver";
    String url      = "jdbc:mysql://compaq:3306/jxgl";
    String user     = "sb";
    String password = "songbo";
    try {
      Class.forName(driver);
    }   
    catch(Exception e) {
      System.out.println("不能加載驅動程序:" + driver);
    }
	String cno[]={"01001","01002"};
	String cname[]={"計算機應用基礎","高級語言程序設計"};
    try {
      Connection con = DriverManager.getConnection(url,user,password);
	  PreparedStatement pmst=con.prepareStatement("UPDATE course SET course_name=? WHERE course_no=?");
	  for(int i=0;i<cno.length;i++) {
		  pmst.setString(1,cname[i]);
		  pmst.setString(2,cno[i]);
	   	  pmst.executeUpdate();
	  }
	  pmst.close();
      Statement  smt = con.createStatement();  
      ResultSet  rst = smt.executeQuery("SELECT * FROM course");
      System.out.println("修改后課程表中的記錄:");
      while(rst.next())      //移動記錄指針到下一筆記錄
      {
         System.out.print(rst.getString("course_no") + " " + rst.getString("course_name") + " ");
         System.out.println(rst.getFloat("course_score"));
      }      
      smt.close();
      con.close();    
    }
    catch(SQLException e) {
      System.out.println("數據庫連接失敗!");
    }
  }
}