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 stub
String 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();
}
}
JBDC考试题
最新推荐文章于 2022-05-12 17:07:36 发布