韩顺平-学生管理系统（Model1）

连接数据库jar包 msbase.jar mssqlserver.jar msutil.jar public void testSQLServer() { Connection con = null; Statement stat = null; ResultSet rs = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //DriverManager.setLogStream(System.out); String url = "jdbc:sqlserver://127.0.0.1:1433;databasename=yuyue"; //jdbc:sqlserver://数据库地址（本地为localhost或127.0.0.1）:端口号（自己设置，我的是1433）;databasename=数据库的名字 String user = "sa";//数据库用户名 String password = "root";//密码 con = DriverManager.getConnection(url, user, password); stat = con.createStatement(); String sql = "select * from users"; rs = stat.executeQuery(sql); while(rs.next()) { System.out.println("username: " + rs.getString("name")); System.out.println("password: " + rs.getString("pwd")); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (rs != null) { rs.close(); } if (stat != null) { stat.close(); } if (con != null) { con.close(); } } catch (Exception e1) { e1.printStackTrace(); } } }