JSP显示数据库表格

%@pagelanguage=javacontentType=text/html;charset=gb2312pageEncoding=gb2312import=java.sql.*%!DOCTYPEhtmlPUBLIC-//W3C//DTDHTML4.01Transitional//EN=Content-Typecontent=text/html;charset=gb2312title显示商品的单价/title/headbodydivalign=centertabletrtdcolspan=9align=centerheight=30a商品单价列表/a/td/tr/tabletableheight=400align=centerborder=2width=60%cellpadding=1cellspacing=1bordercolor=#0000FFbgcolor=#CCFF66trtdcolspan=9align=centerclass=titleheight=30商品信息列表/td/trtrtdalign=center编号/tdtdalign=center名称/tdtdalign=center价格/tdtdalign=center状态/td/tr%try{//加载驱动程序Class.forName(com.mysql.jdbc.Driver);//URL指向要访问的数据库名testStringurl=jdbc:mysql://127.0.0.1:3306/shangpin;//MySQL配置时的用户名Stringuser=root;//MySQL配置时的密码Stringpassword=;//连续数据库Connectionconnection=DriverManager.getConnection(url,user,password);if(!connection.isClosed())System.out.println(商品信息列表：);//statement用来执行SQL语句Statementstatement=connection.createStatement();//要执行的SQL语句Stringsql=select*fromshangpin;//执行SQL语句并返回结果集ResultSetrs=statement.executeQuery(sql);System.out.println(编号+\t+名称+\t+\t+\t+价格+\t+状态);while(rs.next()){//选择id这列数据intid=rs.getInt(id);//选择name这列数据Stringname=rs.getString(name);//选择price这列数据floatprice=rs.getFloat(price);//选择status这列数据Stringstatus=rs.getString(status);//输出结果out.println(trtd+id+/tdtd+name+/tdtd+price+/tdtd+status+/td/tr);}//关闭结果集rs.close();//关闭连接connection.close();}catch(ClassNotFoundExceptione){out.println(Sorry,can`tfindtheDriver!);e.printStackTrace();}catch(SQLExceptione){e.printStackTrace();}catch(Exceptione){e.printStackTrace();}%/table/div/body/html