【转载】Java通过JDBC分别采用Windows身份验证模式和混合验证模式连接登录SQL Server2008数据库代码

混合验证模式连接登录SQL Server2008数据库代码：

import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerDriver;

public class sqlTest {

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String URL = "jdbc:sqlserver://localhost;Database=student";
  Connection con = null;
  ResultSet rs = null;
  Statement st = null;
  String sql = "select * from student";
  try
  {
   Class.forName(driver);
  }
  catch(java.lang.ClassNotFoundException e)
  {
   e.printStackTrace();
  }
  try
  {
   con = DriverManager.getConnection(URL, "sa", "dlut_200892015");
   st = con.createStatement();
   rs = st.executeQuery(sql);
   if(rs!=null)
   {
    ResultSetMetaData rsmd = rs.getMetaData();
    int countCols = rsmd.getColumnCount();
    for(int i=1;i<=countCols;i++)
    {
     if(i>1)System.out.print("; ");
     System.out.print(rsmd.getColumnLabel(i));
    }
    System.out.println("");
    while(rs.next())
    {
     System.out.print(rs.getString("cno")+" ");
     System.out.print(rs.getString("cname")+" ");
    }
   }
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
  try
  {
   if(rs!=null)rs.close();
   if(st!=null)st.close();
   if(con!=null)con.close();
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
 }

}
Windows身份验证模式连接SQL Server2008数据库代码：

import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerDriver;

public class sqlTest {

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String URL = "jdbc:sqlserver://localhost;integratedSecurity=true;Database=student";
  Connection con = null;
  ResultSet rs = null;
  Statement st = null;
  String sql = "select * from student";
  try
  {
   Class.forName(driver);
  }
  catch(java.lang.ClassNotFoundException e)
  {
   e.printStackTrace();
  }
  try
  {
   con = DriverManager.getConnection(URL);
   st = con.createStatement();
   rs = st.executeQuery(sql);
   if(rs!=null)
   {
    ResultSetMetaData rsmd = rs.getMetaData();
    int countCols = rsmd.getColumnCount();
    for(int i=1;i<=countCols;i++)
    {
     if(i>1)System.out.print("; ");
     System.out.print(rsmd.getColumnLabel(i));
    }
    System.out.println("");
    while(rs.next())
    {
     System.out.print(rs.getString("cno")+" ");
     System.out.print(rs.getString("cname")+" ");
    }
   }
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
  try
  {
   if(rs!=null)rs.close();
   if(st!=null)st.close();
   if(con!=null)con.close();
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
 }

}