当前页面: 开发资料首页 → J2SE 专题 → 求教jsp中对sql-server数据库的操作问题
摘要: 求教jsp中对sql-server数据库的操作问题
更新后的表的记录:
<%
rs=sql.executeQuery("SELECT * FROM com");
out.print("<table Border>");
out.print("<tr>");
out.print("<th width=100>"+"no");
out.print("<th width=100>"+"cpu");
out.print("<th width=100>"+"主板");
out.print("<th width=100>"+"内存");
out.print("<th width=100>"+"价格");
out.print("<th width=100>"+"备注");
out.print("</tr>");
while(rs.next())
{ out.print("<tr>");
nn=rs.getInt(1);
out.print("<td >"+nn+"</td>");
nc=rs.getString(2);
out.print("<td >"+nc+"</td>");
nb=rs.getString(3);
out.print("<td >"+nb+"</td>");
nm=rs.getString(4);
out.print("<td >"+nm+"</td>");
np=rs.getInt(5);
out.print("<td >"+np+"</td>");
na=rs.getString(6);
out.print("<td >"+na+"</td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e1)
{ }
%>