package ServletDemo; import java.sql.*; public class Datebase { public static void main(String[] args) throws ClassNotFoundException, SQLException { //加载驱动 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //数据库URL[即：是要连接那一个数据库]localhost--指定本机；integratedSecurity=true--指定windows验证模式连接 String url = "jdbc:sqlserver://localhost:1433;DataBaseName=Login;integratedSecurity=true;";//windows集成模式连接 // String url = "jdbc:sqlserver://localhost:1433;DataBaseName=Login"; // String username = "hh"; // String passWord = "123"; // Connection comm = DriverManager.getConnection(url,username,passWord); //建立连接 Connection comm = DriverManager.getConnection(url); String SQL = "SELECT * FROM [user]";//注意：表名一定要带[] Statement stmt = comm.createStatement(); //结果集 ResultSet rs = stmt.executeQuery(SQL); while(rs.next()){ System.out.println(rs.getString(1)+""+rs.getString(2)); } rs.close(); comm.close(); } }
运行结果：
