Jdbc连接数据库查询

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		  String url="jdbc:sqlserver://192.168.60.124:1433;DatabaseName=subway";
		  String username="sa";
		  String pwd="6375196";
		  Connection con=DriverManager.getConnection(url,username,pwd);
		  Statement stat= con.createStatement();
		  String sql="Select*From subwayinfo";
		  ResultSet rs=stat.executeQuery(sql);
		  while (rs.next()) {
		String subwayname=rs.getString("subwayname");
		System.out.println(subwayname);
			
		}
		  rs.close();
		  stat.close();
		  con.close();
	}