dbtest2.java

来自「这是一张java应用教程的随书光盘」· Java 代码 · 共 30 行

import java.sql.*;
public class DbTest2
{public static void main(String args[])
  { String name,xuehao, Chinese,math,english;
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
     catch(ClassNotFoundException e){}
    try{
	   conn=DriverManager.getConnection("jdbc:odbc:grade");
	   stmt=conn.createStatement();
	   int iBack =stmt.executeUpdate("UPDATE grade SET 数学=数学+10");
	   rs=stmt.executeQuery("SELECT * FROM grade");
	   while(rs.next()){
	      name=rs.getString("姓名");xuehao=rs.getString("学号"); 
          Chinese=rs.getString("语文");
          math=rs.getString("数学"); 
          english=rs.getString("英语");
	    System.out.println("学号:"+" 姓名:"+" 数学："+"语文："+"英语：");
	    System.out.println(" "+xuehao+"   "+name+"   "+math+"   "+Chinese+"   "+english);
          System.out.println(); 
	      }System.out.println("有" + iBack + "条记录被修改！");
	   conn.close();}
    catch(SQLException e){
	  System.out.println(e.getMessage());
      }
   }
}