import java.sql.*;
class TestDB3 {
public TestDB3(){
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=出租管理";
String userName ="sa";
String userPwd = "";
Connection dbConn;
Statement st;
String strsqlQuery="SELECT * FROM 房屋信息 WHERE 面积>80";
ResultSet rs;
int n,m,h;
String s1,s2,s3,s4,s5;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
st=dbConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=st.executeQuery(strsqlQuery);
while(rs.next()){
n=rs.getInt("房号");
m=rs.getInt("价钱");
h=rs.getInt("面积");
s1=rs.getString("详细地址");
s2=rs.getString("所属省");
s3=rs.getString("所属市");
s4=rs.getString("所属区");
s5=rs.getString("出租状态");
System.out.println("\t"+ n+ s1+ s2+ s3+ s4+ h+ s5+ m+"\n");
}
rs.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
public class TestDB2{
public static void main (String args[]){
new TestDB3();
}
}能连接到数据库 但是什么都没输出(数据库的表已经有了数据) 求大侠指教指教!!
class TestDB3 {
public TestDB3(){
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=出租管理";
String userName ="sa";
String userPwd = "";
Connection dbConn;
Statement st;
String strsqlQuery="SELECT * FROM 房屋信息 WHERE 面积>80";
ResultSet rs;
int n,m,h;
String s1,s2,s3,s4,s5;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
st=dbConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=st.executeQuery(strsqlQuery);
while(rs.next()){
n=rs.getInt("房号");
m=rs.getInt("价钱");
h=rs.getInt("面积");
s1=rs.getString("详细地址");
s2=rs.getString("所属省");
s3=rs.getString("所属市");
s4=rs.getString("所属区");
s5=rs.getString("出租状态");
System.out.println("\t"+ n+ s1+ s2+ s3+ s4+ h+ s5+ m+"\n");
}
rs.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
public class TestDB2{
public static void main (String args[]){
new TestDB3();
}
}能连接到数据库 但是什么都没输出(数据库的表已经有了数据) 求大侠指教指教!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货