java编程一、查询房间号是1开头或者是5开头的信息。（编写方法querystudent）

package yourpackage;
import java.sql.*;

class Test1{
public void querystudent() {

//使用桥接 SQL
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String strUrl = "jdbc:odbc:student";//假设你要使用的数据库名为student

//假设你是从表studentinfo中查询
String sql = "SELECT * FROM studentinfo WHERE roomnumber like '[15]%'";
Statement stmt = null;
ResultSet rs = null;
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(strUrl, "sa", "system");
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);

while (rs.next()) {
System.out.println(rs.getString(1));
}
}
catch (SQLException ex1) {
ex1.printStackTrace();
}
catch (Exception ex1) {