ex2.java

软件架构课程：JDBC与JAVA数据库程序设计

/**
 * JDBC驱动连接SQL Server数据库
 */
import java.sql.*;

public class Ex2
 {
 public static void main(String[ ] args)
  {
     //声明JDBC驱动程序对象
	String JDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
   //  //定义JDBC的URL对象,TestDB为SQL Server数据库
  String conURL="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=master";

	try {
		//加载JDBC-ODBC桥驱动程序
      Class.forName(JDriver);  
    }
   catch(java.lang.ClassNotFoundException e) {
      System.out.println("ForName :" + e.getMessage( ));
    }
  try {
        //连接数据库URL
	  Connection con = DriverManager.getConnection(conURL,"sa","sa");  
        //建立Statement类对象
	  Statement s=con.createStatement( );  
        //创建一个含有三个字段的学生表student
	  String query = "create table namebook2 ( " 
                      + "name char(8)," 
                      + "gender char(4)," 
                      + "age integer"
                      + ")";  
      	  s.executeUpdate(query);  //执行SQL命令
        //释放Statement所连接的数据库及JDBC资源
	  s.executeUpdate("insert into namebook2(name,gender,age)" + "values('zhang','m',22)");
	  ResultSet rs=s.executeQuery("select * from namebook2 where age=22");
	  while(rs.next())
	  {
	    System.out.println(rs.getString(1)+rs.getString(2)+rs.getInt(3));
	  }
	  s.executeUpdate("drop table namebook2");
	  s.close( );  
      //关闭与数据库的连线
	  con.close( );  
    }
   catch(SQLException e){
	  System.out.println("SQLException:"+e.getMessage( ));
	}
  }
}