?? qx.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 />
<%<br />
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br />
Connection conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/ROOT/jsp/myjsp/db/db.mdb;");<br />
%><br />
<span class="STYLE5">//包含頁面<%@ include file="conn.jsp" %></span></p>
<p>===================================================================================================<br />
錯誤檢查語句<br />
<span class="STYLE1">try</span>{<br />
執行語句…… <br />
}<span class="STYLE1">catch</span>(Exception e){<br />
out.print("錯誤")；<span class="STYLE5">//處理語句 </span><br />
} </p>
<p>===================================================================================================<br />
分頁顯示技術</p>
<p><%<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("page")!=null){<span class="STYLE5">//假如接收的頁面數不為空</span><br />
gopage = java.lang.Integer.parseInt(request.getParameter("page"));<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<=pagesize <span class="STYLE1">&& !</span>rs.isAfterLast()){<span class="STYLE5">//循環顯示，每頁pagesize個記錄</span><br />
%></p>
<p class="STYLE5">//顯示所需要的記錄的語句</p>
<p><%<br />
rs.next();<span class="STYLE5">//移向下一條記錄</span><br />
i<span class="STYLE1">++</span>;<br />
}<br />
%></p>
<p>===================================================================================================<br />
Session檢查是否登陸狀態
</p>
<p>String name;<br />
name= (String) session.getValue("name");<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("<table bgcolor='#cccccc' width='771' align=center border=0 cellspacing=1><tr><td bgcolor=white align=center>管理員<font color=blue>"+session.getValue("name")+"</font>");<br />
out.print("已登陸&nbsp;&nbsp;&nbsp;&nbsp;<a href=index.jsp?loginout=true>退出登陸</a></td></tr></table><br>");<br />
String loginout=request.getParameter("loginout");<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("true")==0)<br />
{<br />
session.removeAttribute("name");<span class="STYLE5">//清除管理員session</span><br />
response.sendRedirect("index.jsp");<span class="STYLE5">//重新轉向主頁</span><br />
}<br />
}<br />
}<span class="STYLE1">else</span>{<span class="STYLE5">//否則，即未登陸狀態</span><br />
out.print("<center><a href=login.jsp>管理登陸</a></center>");<br />
}<br />
===================================================================================================<br />
登陸-修改密碼頁合二為一</p>
<p><%<br />
String name;<br />
name= (String) request.getParameter("name");<br />
<span class="STYLE1">if</span>(name!=null){<br />
%></p>
<p>修改密碼表單</p>
<p><%<br />
}<span class="STYLE1">else</span>{<br />
%><br />
<br />
登陸表單<br />
<br />
<%<br />
}<br />
%><br />
===================================================================================================<br />
登陸后密碼驗證頁
<br />
<%<br />
String name,pwd;<br />
name=request.getParameter("adminname");<br />
pwd=request.getParameter("adminpwd");<br />
Statement stmt=conn.createStatement();<br />
ResultSet rs=stmt.executeQuery("select * from admin where admin='"+name+"' and adminpwd='"+pwd+"'");<br />
<span class="STYLE1">if</span>(rs.next()){<br />
session.putValue("name",name);<br />
session.putValue("pwd",pwd);<br />
rs.close();<br />
stmt.close();<br />
response.sendRedirect("index.jsp");<br />
}<span class="STYLE1">else</span>{<br />
out.print("<center>密碼或用戶名錯誤<br><a href=javascript:history.go(-1)>返回</a></center>");<br />
}<br />
%><br />
===================================================================================================<br />
驗證并修改密碼<br />
<%<br />
String name,pwd,pwd2,pwd3;<br />
int rst=0;<br />
name=request.getParameter("adminname");<br />
pwd=request.getParameter("adminpwd");<br />
pwd3=request.getParameter("adminpwd2");<br />
pwd2=(new String(pwd3.getBytes("iso-8859-1"),"gb2312"));<br />
Statement stmt=conn.createStatement();<br />
ResultSet rs=stmt.executeQuery("select * from admin where admin='"+name+"' and adminpwd='"+pwd+"'");</p>
<p><span class="STYLE1">if</span>(rs.next()){<br />
Statement stmtcgpwd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);<br />
String sql4="update admin set adminpwd='"+pwd2+"'";<br />
stmtcgpwd.executeUpdate(sql4);<br />
<br />
stmtcgpwd.close();<br />
rs.close();<br />
stmt.close();<br />
out.print("<script language='javascript'>alert('修改成功');window.location.href='index.jsp';</script>");<br />
}<span class="STYLE1">else</span>{<br />
out.print("<center>密碼或用戶名錯誤<br><a href=javascript:history.go(-1)>返回</a></center>");<br />
} <br />
%><br />
<br />
===================================================================================================<br />
處理插入數據庫亂碼問題并插入數據庫<br />
<%<br />
String zt,username,qq,email,sex,tx,nr,zt1,username1,qq1,sex1,tx1,nr1;<br />
zt1=request.getParameter("zt");<br />
zt=(new String(zt1.getBytes("iso-8859-1"),"gb2312"));<br />
<br />
username1=request.getParameter("username");<br />
username=(new String(username1.getBytes("iso-8859-1"),"gb2312"));<br />
<br />
qq1=request.getParameter("qq");<br />
qq=(new String(qq1.getBytes("iso-8859-1"),"gb2312"));<br />
<br />
email=request.getParameter("email");<br />
<br />
sex1=request.getParameter("sex");<br />
sex=(new String(sex1.getBytes("iso-8859-1"),"gb2312"));<br />
<br />
tx1=request.getParameter("tx");<br />
tx=(new String(tx1.getBytes("iso-8859-1"),"gb2312"));<br />
<br />
nr1=request.getParameter("nr");<br />
nr=(new String(nr1.getBytes("iso-8859-1"),"gb2312"));<br />
<br />
<span class="STYLE1">if</span>(username.length()!=0&&nr.length()!=0){<br />
try{<br />
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);<br />
String sql;<br />
sql="insert into a (zt,username,qq,email,sex,tx,nr) values ('"+zt+"','"+username+"','"+qq+"','"+email+"','"+sex+"','"+tx+"','"+nr+"')";<br />
stmt.executeUpdate(sql);<br />
stmt.close();<br />
conn.close();<br />
out.print("<script language='javascript'>alert('留言成功');window.location.href='index.jsp';</script>");<br />
}catch(Exception e){<br />
out.print("信息錯誤！");<br />
}<br />
}<span class="STYLE1">else</span>{<br />
out.print("<center>用戶名為空或沒有留言內容"+"<br><a href=javascript:history.go(-1)>返回</a></center>");<br />
}<br />
%><br />
<br />
===================================================================================================<br />
一些引用代碼<br />
<link href="css.css" rel="stylesheet" type="text/css"><br />
<br />
包含頁面<%@ include file="conn.jsp" %></p>
<p>將接收的信息轉換為比特流<br />
nr1=request.getParameter("nr");<br />
nr=(new String(nr1.getBytes("iso-8859-1"),"gb2312"));<br />
<br />
<script language='javascript'>alert('修改成功');window.location.href='index.jsp';</script><br />
<br />
<br />
<br />
</p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -