JBDC考试题

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class SubWay {/** * @param args * @throws SQLException  */public static void main(String[] args) throws Exception {// TODO Auto-generated method stubString driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String url = "jdbc:sqlserver://192.168.60.124:1433;DatabaseName=SubWay";String username = "sa";String pwd = "6375196";Class.forName(driverName);Connection conn = DriverManager.getConnection(url, username, pwd);Statement stat = conn.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();conn.close();}}