S2地铁考试题目

来源：互联网发布：百度云盘破解限速 mac 编辑：程序博客网时间：2024/04/28 03:12

package cn.happy.JDBCLuXian;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 ClassNotFoundException  * @throws SQLException  */public static void main(String[] args) throws ClassNotFoundException, SQLException {//我要连接数据库//连接驱动字符串String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";     //连接字符串//          jdbc:sqlserver://xxxx:xxxx;DatabaseName=xxxxString url="jdbc:sqlserver://192.168.60.124:1433;DatabaseName=SubWay";//用户名String useNameString="sa";//密码        String passwordString="6375196";        //加载驱动        Class.forName(driver);        Connection connection=DriverManager.getConnection(url,useNameString,passwordString);String sqlString="select * from subwayinfo";//发送给SQL引擎Statement stat=connection.createStatement();ResultSet rs = stat.executeQuery(sqlString);while(rs.next()){String sub = rs.getString("subwayname");System.out.println(sub);}stat.close();connection.close();}}

1 0