package cn.ctgu.edu.ac;
import java.sql.*;
public class test {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String url="jdbc:sqlserver://localhost:1433;Database=网上书店管理系统;integratedSecurity=true;"; //用widows身份登录
String sql="select * from users";
Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection(url);
Statement state=conn.createStatement();
ResultSet rs=state.executeQuery(sql);
while(rs!=null&&rs.next())
{
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6));
}
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}