import java.sql.*;
public class Demo8 { public static void main(String[] srg) { String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=wyc"; //连接服务器和数据库sampleString userName = "sa"; //默认用户名String userPwd = "wyc"; //密码Connection dbConn;PreparedStatement ps = null;ResultSet rs = null;try { Class.forName(driverName);dbConn = DriverManager.getConnection(dbURL, userName, userPwd);//Statement sm = dbConn.createStatement();String sql = "select name,age from wo";ps=dbConn.prepareStatement(sql);rs = ps.executeQuery();// 执行查询while(rs.next()){ String name=rs.getString("name");//使用字段名也可以取出数据 int age=rs.getInt("age"); System.out.println(name+"\t"+age);} System.out.println( "Connection Successful! "); //如果连接成功 控制台输出Connection Successful!} catch (Exception e) { e.printStackTrace();}}}