Novice help: java can access the contents of the table when connected with jdbc in java, why is the result not displayed

ljhfeiyang

Print out the exception and see

lashly

1. See exception information
2. Is there a JAR package for connecting data under the project you released

This post is too long, can it end? ?

光明信仰

Post exception, see if it is the error!

FRANKDD

[code=Java]
while(rs.next())
    {
        out.print( "<TR><TD> "+rs.getString(1)+ "</TD></TR> ");
                                
    }
...
</table>
</body>
</html>
[/code]
html not done well

hedgehog_j

[color=#FF0000]The HTML markup is wrong[/color]
out.print( "<TR> ");
while(rs.next())
                        {
                                out.print( "<TD> "+rs.getString(1)+" </TD> ");
                                
                        }
rs.close();

out.print( "</TR> ");

out.print( "</table>");

vrkickass

Incorrect HTML markup:
[code=Java]
String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs "; //Remove the space after pubs

int temp = 0;

while(rs.next()) {
     if (temp% 5 == 0) {
         out.print( "<TR>");
     }
     out.print( "<TD> "+rs.getString(1)+" </TD> ");
     if ((temp + 1)% 5 == 0) {
         out.print( "</TR>");
     }
     temp++;
}
out.print( "</TABLE>");
[/code]

haiyangfi

Statement st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

changed to
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from students ");

badmary

Haha, if you look at the original code of that jsp on the webpage, something must have come out, but it is not displayed on the webpage.
The reason is that there is a problem with tr and td of your table.

loveyanyan

ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE
This is wrong,
Change to ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY

larcom

[Quote=Quote the reply fromloveyanyanon the 1st floor:]
ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE
This is wrong,
Change to ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY
[/Quote]

It should be this problem!