混合验证模式连接登录SQL Server2008数据库代码:
import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerDriver;
public class sqlTest {
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 = DriverManager.getConnection(url,数据库用户,密码);
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 {
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();
}
}
}