jsp知识仓库代码.docVIP

首页cmnDBOpen.jsp %@page language=java import=java.sql.* % % Connection conn = null; try { //载入MySQL的JDBC驱动类 Class.forName(com.mysql.jdbc.Driver); //获得数据库连接 String sConn = jdbc:mysql://localhost/ch03?user=sapassword=11111; conn = DriverManager.getConnection( sConn ); Statement stmt = null; ResultSet rs = null; % 首页cmnTipCount.jsp % //创建Statement对象 stmt = conn.createStatement(); //执行SQL语句 String query = select count(*) from tip; rs = stmt.executeQuery( query ); rs.next(); int iTipCount =rs.getInt(1); rs.close(); stmt.close(); % 首页cmnPageTop.jsp %@page contentType=text/html;charset=gbk % body table width=800 height=570 border=0 cellpadding=0 cellspacing=2 bgcolor=#254996 tr td bgcolor=#ffffff valign=top height=30 table width=796 height=30 bgcolor=#ff00ff border=0 cellpadding=0 cellspacing=0 tr td class=td_title width=10 background=img/topLeft.gif/td td class=td_title width=716 background=img/topCenter.gif 数据库中共有 font color=#ffaa00%=iTipCount%/font 条记录。 /td td class=td_title width=20 background=img/topCenter.gif img border=0 src=img/add_original.gif style=cursor:hand; onmouseover=this.src=img/add_hover.gif onmouseout=this.src=img/add_original.gif alt=新增 onclick=gotoAddPage(); /td td class=td_title width=20 background=img/topCenter.gif img border=0 src=img/search_original.gif style=cursor:hand; onmouseover=this.src=img/search_hover.gif onmouseout=this.src=img/search_original.gif alt=查找 onclick=gotoSearchPage(); /td td class=td_title width=30 background=img/topRight.gif align=center img border=0 src=img/close_original.gif style=cursor:hand; onmouseover=this.src=img/close_hover.gif onmouseout=this.src=img/close_original.gif