useprestatement.java

不错..................是java的源码

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("数据库连接失败!");
    }
  }
}