java 订单号相连_用java做一个订单查询系统，和sql server进行连接，输入订单号输出相应信息...

btnsearch.addActionListener(newMyEvent());classMyEventimplementsActionListener{publicvoidactionPerformed(ActionEvente){StringdriverName="com.microsoft.sqlserver.jdbc.SQLS...

btnsearch.addActionListener(new MyEvent());

class MyEvent implements ActionListener {

public void actionPerformed(ActionEvent e) {

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=Ois";

String userName = "sa"; // 默认用户名

String userPwd = "sa"; // 密码

int intorderID = Integer.parseInt(txtorderID.getText());

String sql = "SELECT * FROM Order WHERE OrderID='"+ intorderID + "'";

try {

Class.forName(driverName);

Connection c = DriverManager.getConnection(dbURL, userName,

userPwd);

System.out.println("连接成功！"); // 如果连接成功，控制台输出“连接成功！”

PreparedStatement s = c.prepareStatement(sql);

ResultSet r = s.executeQuery();

r.beforeFirst();

while (r.next()) {

txtstatus.setText(r.getString(2));

txtsname.setText(r.getString(3));

txtsphonenumber.setText(r.getFloat(4)+"");

txtsaddress.setText(r.getString(5));

txtrname.setText(r.getString(6));

txtrphonenumber.setText(r.getString(7));

txtraddress.setText(r.getString(8));

}

} catch (Exception ee) {System.out.println("连接失败！");

}

}

}

运行之后控制台显示是这样的

现在看来是ResultSet r = s.executeQuery();这句语句有问题，因为如果我在这句语句之前加上一句System.out.println(intorderID)的话，控制台会输出我输入的值，但如果在这句语句之后加上输出语句，就不会输出了。可是我不懂问题出在哪里，各位大神帮帮忙吧，跪谢！！！

展开