jdbcexam.java

Java程序设计实用教程源代码 本书源代码按章分别放置在不同的文件夹中,所有程序均在JDK1.6环境下编译运行正常,除了第13章需要建立ODBC数据源之外,其他程序只要有Java运行环境即可直接运行

import java.sql.*;
public class jdbcExam{
  public static void main(String args[]){
    ResultSet rs = null;
    PreparedStatement ps = null;
    String url = "jdbc:odbc:testDB";
    Connection con;
    Statement stmt;
    try {
			//装入驱动器jdbc-odbc桥
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection(url,"sa","password");//连接			
			DatabaseMetaData dma = con.getMetaData();//获取DatabaseMetaData对象
			//通过DatabaseMetaData对象获取驱动器和URL信息
			System.out.println("连接到URL:" + dma.getURL());
			System.out.println("驱动程序名:" + dma.getDriverName());
			System.out.println("驱动程序版本:" + dma.getDriverVersion());
 			System.out.println("JDBC主版本:"+ dma.getJDBCMajorVersion());
 			System.out.println("JDBC次版本:"+ dma.getJDBCMinorVersion());
 			System.out.println("最大连接数:"+ dma.getMaxConnections());
			//数据库信息
			System.out.println("数据库名:" + dma.getDatabaseProductName()+dma.getDatabaseProductVersion());
			System.out.print("数据库是否支持外部连接: ");
			if(dma.supportsOuterJoins())
				System.out.println("是");
			else
				System.out.println("否");
    con.setAutoCommit(false);
    stmt = con.createStatement();
    rs = stmt.executeQuery("SELECT * FROM USER");
    System.out.println("\n查询表中现有数据:");
    printData(rs);
    stmt.addBatch("INSERT INTO USER(NAME,SEX,TEL_NUM,EMAIL) " +"VALUES('乔峰',1,'13995122637', '[e-mail]')");
    int [] updateCounts = stmt.executeBatch();
    con.commit();
    con.setAutoCommit(true);
    rs = stmt.executeQuery("SELECT * FROM USER");
    System.out.println("插入记录后表中的数据:");
    
    printData(rs);
			//关闭连接
    rs.close();
    stmt.close();
    con.close();
    }
    catch(java.lang.Exception e) {
      System.err.println(e.getMessage());
    }
  }
private static void printData(ResultSet rs) throws Exception{
      System.out.println("编号\t姓名\t性别\t联系电话\tEMAIL");
    while (rs.next()){
      int id = rs.getInt("USER_ID");
      String name = rs.getString("NAME");
      int sex = rs.getInt("SEX");
      String tel = rs.getString("TEL_NUM");
      String email = rs.getString("EMAIL");
      String strSex = "";
      switch(sex){
      	case 1:
      	strSex = "男";
      	break;
      	case 2:
      	strSex = "女";
      	break;
      	default:
      	strSex = "未知";
      }
      System.out.println(id + "\t" + name + "\t" + strSex + "\t" + tel + "\t" + email);
    }
  }
}