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=xmu2";

	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","");  
        //建立Statement类对象
	  Statement s=con.createStatement( );  
        //创建一个含有三个字段的学生表student
	  String query = "create table stu2 ( " 
                      + "id char(10)," 
                      + "name char(15)," 
                      + "score integer"
                      + ")";  
      s.executeUpdate(query);  //执行SQL命令
        //释放Statement所连接的数据库及JDBC资源
	  s.close( );  
      //关闭与数据库的连线
	  con.close( );  
    }
   catch(SQLException e){
	  System.out.println("SQLException:"+e.getMessage( ));
	}
  }
}