如果只有一条用:
ResultSet rs = stmt.createStatement(sqlStr) ;
if(rs.next())
out.print("<br>"+rs.getString(1)) ;如果多条用:
ResultSet rs = stmt.createStatement(sqlStr) ;
while(rs.next())
out.print("<br>"+rs.getString(1)) ;
ResultSet rs = stmt.createStatement(sqlStr) ;
if(rs.next())
out.print("<br>"+rs.getString(1)) ;如果多条用:
ResultSet rs = stmt.createStatement(sqlStr) ;
while(rs.next())
out.print("<br>"+rs.getString(1)) ;
out.println(rs.getString("id"));
out.println(rs.getDouble("price"));
out.println(rs.getInt("num"));
...其中get方法随数据类型变化
out.print(rs.getString(1)) ;
else
out.print("没有你想要得信息。");