我的代码是这样写的.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:;Driver={SQL Server};DataBase=gggg;Server=user10","sa","88888888");
Statement stmt=con.createStatement();
//ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt executeQuery("select * from qq");
...
out.write("<td>"+getFillUp(rs.getString("WH_Price"))+"</td>");
...
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:;Driver={SQL Server};DataBase=gggg;Server=user10","sa","88888888");
Statement stmt=con.createStatement();
//ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt executeQuery("select * from qq");
...
out.write("<td>"+getFillUp(rs.getString("WH_Price"))+"</td>");
...
...
out.write("<td>"+getFillUp(rs.getString("WH_Price"))+"</td>");
...
改:
ResultSet rs=stmt.executeQuery("select * from qq");
...
out.write("<td>"+getFillUp(rs.getString("WH_Price"))+"</td>");
...
rs.getString(clo1)
rs.getString(clo2)
rs.getString(clo3)
顺序不能更改
读字段一定要按select和from之间已定义好的字段顺序读.