⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 qx.jsp

📁 JAVA制作的留言板程序
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta name="Keywords" content="Eron留言本，初学期所做，请随意使用修改，本人不保留任何权利，嘿" />
<link href="css.css" rel="stylesheet" type="text/css">
<title>编写历程</title>
</head>

<body>
<p>===================================================================================================<br />
  连接数据库<br />
  &lt;%<br />
  Class.forName(&quot;sun.jdbc.odbc.JdbcOdbcDriver&quot;);<br />
  Connection conn=DriverManager.getConnection(&quot;jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/ROOT/jsp/myjsp/db/db.mdb;&quot;);<br />
%&gt;<br />
<span class="STYLE5">//包含页面&lt;%@ include file=&quot;conn.jsp&quot; %&gt;</span></p>
<p>===================================================================================================<br />
  错误检查语句<br />
  <span class="STYLE1">try</span>{<br />
   执行语句…… <br />
  }<span class="STYLE1">catch</span>(Exception e){<br />
  out.print(&quot;错误&quot;)；<span class="STYLE5">//处理语句 </span><br />
} </p>
<p>===================================================================================================<br />
分页显示技术</p>
<p>&lt;%<br />
  int i=1;<br />
  int pagesize=8;<span class="STYLE5">//定义每页显示多少条记录</span><br />
  int pagecount;<span class="STYLE5">//定义一共多少页</span><br />
  int rowcount;<span class="STYLE5">//定义一共多少条记录<br />
  </span>int gopage;<span class="STYLE5">//待显示页</span><br />
  rs.last(); <span class="STYLE5">//将指针移动到表中的记录的最后面</span><br />
  rowcount = rs.getRow();<span class="STYLE5">//统计出一共有多少个记录</span><br />
  pagecount=(rowcount+pagesize-1)/pagesize;<span class="STYLE5">//得到需要显示的总页数</span><br />
  <span class="STYLE5">//=============================以数字显示需要跳转到哪一页===========================================</span><br />
  <span class="STYLE1">if</span>(request.getParameter(&quot;page&quot;)!=null){<span class="STYLE5">//假如接收的页面数不为空</span><br />
  gopage = java.lang.Integer.parseInt(request.getParameter(&quot;page&quot;));<span class="STYLE5">//就把接收的页面数pagg赋值给gopage</span><br />
  }<span class="STYLE1">else</span>{<span class="STYLE5">//否则</span><br />
  gopage=1;<span class="STYLE5">//gopage为1，即显示第一页</span><br />
  }<br />
  <span class="STYLE5">//==================================================================================================</span><br />
rs.absolute((gopage-1)*pagesize+1);<span class="STYLE5">//将指针定位到哪一条记录</span></p>
<p><span class="STYLE1">while</span>(i&lt;=pagesize <span class="STYLE1">&amp;&amp; !</span>rs.isAfterLast()){<span class="STYLE5">//循环显示，每页pagesize个记录</span><br />
%&gt;</p>
<p class="STYLE5">//显示所需要的记录的语句</p>
<p>&lt;%<br />
  rs.next();<span class="STYLE5">//移向下一条记录</span><br />
  i<span class="STYLE1">++</span>;<br />
}<br />
%&gt;</p>
<p>===================================================================================================<br /> 
  Session检查是否登陆状态
</p>
<p>String name;<br />
  name= (String) session.getValue(&quot;name&quot;);<span class="STYLE5">//接受登陆页传过来的Session</span><br />
    <span class="STYLE1">if</span>(name<span class="STYLE1">!=null</span>)<span class="STYLE5">//假如session不为空即上一页密码查询结果正确</span><br />
    {<br />
    out.print(&quot;&lt;table bgcolor='#cccccc' width='771' align=center border=0 cellspacing=1&gt;&lt;tr&gt;&lt;td bgcolor=white align=center&gt;管理员&lt;font color=blue&gt;&quot;+session.getValue(&quot;name&quot;)+&quot;&lt;/font&gt;&quot;);<br />
    out.print(&quot;已登陆&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;a href=index.jsp?loginout=true&gt;退出登陆&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;br&gt;&quot;);<br />
    String loginout=request.getParameter(&quot;loginout&quot;);<span class="STYLE5">//获得是否退出登陆的session</span><br />
    <span class="STYLE1">if</span>(loginout<span class="STYLE1">!=null</span>)<span class="STYLE5">//假如session不为空即有点击退出动作</span><br />
{<br />
<span class="STYLE1">if</span>(loginout.compareTo(&quot;true&quot;)==0)<br />
{<br />
session.removeAttribute(&quot;name&quot;);<span class="STYLE5">//清除管理员session</span><br />
response.sendRedirect(&quot;index.jsp&quot;);<span class="STYLE5">//重新转向主页</span><br />
}<br />
}<br />
}<span class="STYLE1">else</span>{<span class="STYLE5">//否则，即未登陆状态</span><br />
out.print(&quot;&lt;center&gt;&lt;a href=login.jsp&gt;管理登陆&lt;/a&gt;&lt;/center&gt;&quot;);<br />
}<br />
  ===================================================================================================<br />
登陆-修改密码页合二为一</p>
<p>&lt;%<br />
  String name;<br />
  name= (String) request.getParameter(&quot;name&quot;);<br />
  <span class="STYLE1">if</span>(name!=null){<br />
%&gt;</p>
<p>修改密码表单</p>
<p>&lt;%<br />
  }<span class="STYLE1">else</span>{<br />
  %&gt;<br />
  <br />
  登陆表单<br />
  <br />
  &lt;%<br />
  }<br />
  %&gt;<br />
  ===================================================================================================<br />
  登陆后密码验证页
  <br />
  &lt;%<br />
  String name,pwd;<br />
  name=request.getParameter(&quot;adminname&quot;);<br />
  pwd=request.getParameter(&quot;adminpwd&quot;);<br />
  Statement stmt=conn.createStatement();<br />
  ResultSet rs=stmt.executeQuery(&quot;select * from admin where admin='&quot;+name+&quot;' and adminpwd='&quot;+pwd+&quot;'&quot;);<br />
  <span class="STYLE1">if</span>(rs.next()){<br />
  session.putValue(&quot;name&quot;,name);<br />
  session.putValue(&quot;pwd&quot;,pwd);<br />
rs.close();<br />
stmt.close();<br />
response.sendRedirect(&quot;index.jsp&quot;);<br />
}<span class="STYLE1">else</span>{<br />
out.print(&quot;&lt;center&gt;密码或用户名错误&lt;br&gt;&lt;a href=javascript:history.go(-1)&gt;返回&lt;/a&gt;&lt;/center&gt;&quot;);<br />
}<br />
  %&gt;<br />
===================================================================================================<br />
验证并修改密码<br />
  &lt;%<br />
  String name,pwd,pwd2,pwd3;<br />
  int rst=0;<br />
  name=request.getParameter(&quot;adminname&quot;);<br />
  pwd=request.getParameter(&quot;adminpwd&quot;);<br />
  pwd3=request.getParameter(&quot;adminpwd2&quot;);<br />
  pwd2=(new String(pwd3.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
  Statement stmt=conn.createStatement();<br />
ResultSet rs=stmt.executeQuery(&quot;select * from admin where admin='&quot;+name+&quot;' and adminpwd='&quot;+pwd+&quot;'&quot;);</p>
<p><span class="STYLE1">if</span>(rs.next()){<br />
  Statement stmtcgpwd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);<br />
  String sql4=&quot;update admin set adminpwd='&quot;+pwd2+&quot;'&quot;;<br />
  stmtcgpwd.executeUpdate(sql4);<br />
  <br />
  stmtcgpwd.close();<br />
  rs.close();<br />
  stmt.close();<br />
  out.print(&quot;&lt;script language='javascript'&gt;alert('修改成功');window.location.href='index.jsp';&lt;/script&gt;&quot;);<br />
  }<span class="STYLE1">else</span>{<br />
  out.print(&quot;&lt;center&gt;密码或用户名错误&lt;br&gt;&lt;a href=javascript:history.go(-1)&gt;返回&lt;/a&gt;&lt;/center&gt;&quot;);<br />
  } <br />
  %&gt;<br />
  <br />
===================================================================================================<br />
处理插入数据库乱码问题并插入数据库<br />
&lt;%<br />
String zt,username,qq,email,sex,tx,nr,zt1,username1,qq1,sex1,tx1,nr1;<br />
zt1=request.getParameter(&quot;zt&quot;);<br />
zt=(new String(zt1.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
<br />
username1=request.getParameter(&quot;username&quot;);<br />
username=(new String(username1.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
<br />
qq1=request.getParameter(&quot;qq&quot;);<br />
qq=(new String(qq1.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
<br />
email=request.getParameter(&quot;email&quot;);<br />
  <br />
  sex1=request.getParameter(&quot;sex&quot;);<br />
  sex=(new String(sex1.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
  <br />
  tx1=request.getParameter(&quot;tx&quot;);<br />
  tx=(new String(tx1.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
  <br />
  nr1=request.getParameter(&quot;nr&quot;);<br />
  nr=(new String(nr1.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
  <br />
  <span class="STYLE1">if</span>(username.length()!=0&amp;&amp;nr.length()!=0){<br />
  try{<br />
  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);<br />
  String sql;<br />
  sql=&quot;insert into a (zt,username,qq,email,sex,tx,nr) values ('&quot;+zt+&quot;','&quot;+username+&quot;','&quot;+qq+&quot;','&quot;+email+&quot;','&quot;+sex+&quot;','&quot;+tx+&quot;','&quot;+nr+&quot;')&quot;;<br />
  stmt.executeUpdate(sql);<br />
  stmt.close();<br />
  conn.close();<br />
  out.print(&quot;&lt;script language='javascript'&gt;alert('留言成功');window.location.href='index.jsp';&lt;/script&gt;&quot;);<br />
  }catch(Exception e){<br />
  out.print(&quot;信息错误！&quot;);<br />
  }<br />
  }<span class="STYLE1">else</span>{<br />
  out.print(&quot;&lt;center&gt;用户名为空或没有留言内容&quot;+&quot;&lt;br&gt;&lt;a href=javascript:history.go(-1)&gt;返回&lt;/a&gt;&lt;/center&gt;&quot;);<br />
  }<br />
%&gt;<br />
<br />
===================================================================================================<br />
一些引用代码<br />
&lt;link href=&quot;css.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt;<br />
<br />
包含页面&lt;%@ include file=&quot;conn.jsp&quot; %&gt;</p>
<p>将接收的信息转换为比特流<br />
  nr1=request.getParameter(&quot;nr&quot;);<br />
nr=(new String(nr1.getBytes(&quot;iso-8859-1&quot;),&quot;gb2312&quot;));<br />
  <br />
  &lt;script language='javascript'&gt;alert('修改成功');window.location.href='index.jsp';&lt;/script&gt;<br />
  <br />
  <br />
  <br />
</p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -