jdbcÓëSQLserverÁ¬½Ó

package com.tongying.www.until;

public class Resource {
// MySQlÊý¾Ý¿âµÄ×ÊÔ´
/* public static final String DRIVER="com.mysql.jdbc.Driver";
public static final String URL="jdbc:mysql://localhost:3306/msg";
public static final String USER="root";
public static final String PASSWORD ="root";
*/
//MSSQL
public static final String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
public static final String URL="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=student";
public static final String USER="sa";
public static final String PASSWORD ="sa";


}

package com.tongying.www.test;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import com.tongying.www.until.Resource;

public class Test1 {
  public static void main(String[]args){
  Test1 test=new Test1();
  test.Query();
  }
  //Á¬½ÓÊý¾Ý¿â
  public void Query(){
  Connection conn=null;
  Statement stmte=null;
  ResultSet res=null;
&n