地铁详细信息

来源:互联网 发布:java long转date 编辑:程序博客网 时间:2024/04/26 08:36
package cn.java.OOP.subway;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class subway {public static void main(String[] args) throws Exception {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");String url="jdbc:sqlserver://192.168.60.124:1433;DatabaseName=SubWay;";String urlname="sa";String pwd="6375196"; Connection connection = DriverManager.getConnection(url, urlname, pwd);Statement stae= connection.createStatement();String sql="select * from SubWayinfo";ResultSet rs = stae.executeQuery(sql);while (rs.next()) {System.out.println(rs.getString("SubWayname"));}}}

0 0
原创粉丝点击