自己项目一
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<html>
<head>
<script type="text/javascript" src="js/jquery-1.4.3.js"></script>
<link type="text/css" rel="stylesheet" media="all" href="css/believe.css"/>
<script type="text/javascript">
function sc(id){
if(confirm("确定要删除吗?")){
$.ajax({
type:'post',
url:'/believe/Bel_del?id='+id,
dataType:"json",
success:function(data){
alert("删除成功!");
window.location.href="/believe/BelQuery";
},
error:function(){
alert("删除异常");
}
});
}
}
</script>
<style type="text/css">
/*.login{
background-image: url("images/login.jpg");
}*/
</style>
</head>
<body class="login">
<form action="BelQuery" method="post">
<div>
id:<input type="text" name="ssId" value="${ssId}" class="a" onKeypress="return (/[\d.]/.test(String.fromCharCode(event.keyCode)))"/>
score:<input type="text" name="ssScore" value="${ssScore}" class="b"/>
<input type="submit" value="查询">
</div>
<table border="1" cellpadding="1" cellspacing="1" width="300" height="20">
<tr align="center">
<td>id</td>
<td>name</td>
<td>score</td>
<td>class</td>
<td>操作</td>
</tr>
<s:iterator value="believes" var="b">
<tr align="center">
<td>${b.id }</td>
<td>${b.name }</td>
<td>${b.score }</td>
<td>${b.belClass }</td>
<td>
<!--<input type="button" value="删除" onclick="location.href='Bel_del?id=${b.id}';">-->
<input type="button" value="删除" onclick="sc('${b.id}');">
<input type="button" value="修改" onclick="location.href='Bel_load?id=${b.id}';">
<input type="button" value="详细" onclick="location.href='Bel_detailed?id=${b.id}';">
</td>
</tr>
</s:iterator>
</table>
<div align="left">
<input type="button" value="添加数据" onclick="location.href='add.jsp';">
<input id="dl" type="button" value="返回登录" onclick="location.href='login';">
<input type="button" value="返回首页" onclick="location.href='BelQuery';">
</div><br>
<!-- 分页显示 -->
<div>
<s:if test="page>1">
<a href="BelQuery?page=1&ssId=${ssId}&ssScore=${ssScore}">首页</a>
</s:if>
<s:else><a href="#1">首页</a></s:else>
<s:if test="page>1">
<a href="BelQuery?page=${page-1}&ssId=${ssId}&ssScore=${ssScore}">上一页</a>
</s:if>
<s:else> <a href="#1">上一页</a> </s:else>
<!-- 判断最大页数并从1依次显示出来 -->
<s:iterator value="new int[maxPage]" status="i">
<s:if test="#i.count==page">
<a href="BelQuery?page=${i.count}&ssId=${ssId}&ssScore=${ssScore}" class="current_page">
<s:property value="#i.count"/>
</a>
</s:if>
<s:else>
<a href="BelQuery?page=${i.count}&ssId=${ssId}&ssScore=${ssScore}">
<s:property value="#i.count"/>
</a>
</s:else>
</s:iterator>
<s:if test="page < maxPage ">
<a href="BelQuery?page=${page+1}&ssId=${ssId}&ssScore=${ssScore}">下一页</a>
</s:if>
<s:else> <a href="#1">下一页</a></s:else>
<s:if test="page < maxPage">
<a href="BelQuery?page=${maxPage}&ssId=${ssId}&ssScore=${ssScore}">末页</a>
</s:if>
<s:else><a href="#1">末页</a></s:else>
</div>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<html>
<head>
<script type="text/javascript" src="js/jquery-1.4.3.js"></script>
<link type="text/css" rel="stylesheet" href="css/believe.css">
<script type="text/javascript">
$(function(){
//单击图片切换验证码
$("#imageid").click(function(){
$(this).attr("src","image?a="+Math.random());
});
//单击超链接切换验证码
$("#changeImage").click(function(){
$("#imageid").attr("src","image?a="+Math.random());
return false;//阻止a元素的href动作
});
});
var num=0;
function dl(){
var url="/believe/pwdYz";
var pwdData="namePwd="+$("#zh").val()+"&password="+$("#mm").val()+"&imageName="+$("#yzm").val();
//alert(pwdData);
$.ajax({
type:'post',
url:url,
dataType:'json',
data:pwdData,
success:function(data){
//alert(data);
var flag=true;
if($("#zh").val()!='' && data == 0){
alert('该用户名不存在,请重新输入!');
$("#zh").val('');
return;
}else{
if($("#zh").val()==''){
flag=false;
alert("请填写帐号");
}
else if($("#mm").val()==''){
flag=false;
alert("请填写密码");
}
else if($("#yzm").val()==''){
flag=false;
alert("请输入验证码");
}
else if(data == 2){
flag=false;
alert("验证码错误,请重新输入!");
$("#yzm").val('');
$("#imageid").attr("src","image?a="+Math.random());
}
else if(data == 1){
num=num+1;
flag=false;
alert("密码错误,第"+num+"次错误,请重新输入!");
$("#mm").val('');
if(num==3){
alert("错误3次!返回重新登录!");
window.location.href='login.jsp';
}
}
if(flag==true){
alert("登录成功!");
$("#tologin").submit();
}
}
}
});
}
</script>
<style type="text/css">
/* .login{
background-image: url("images/login.jpg");
} */
</style>
</head>
<body class="login">
<div>
<form action="toLogin" method="post" id="tologin">
<!--<s:textfield value="%{#session.image_code}" id="abc"></s:textfield>-->
<table align="center">
<tr>
<td><span class="zt">帐号</span></td>
<td><input type="text" value="" name="nameCode" id="zh" class="ty"/></td>
</tr>
<tr>
<td><span class="zt">密码</span></td>
<td><input type="password" value="" name="password" id="mm" class="ty"/></td>
</tr>
<tr>
<td>验证码</td>
<td>
<input type="text" value="" name="imageName" id="yzm" class="yzm"/>
<img alt="验证码" id="imageid" src="image" width="75" height="25" title="点击更换">
</td>
<td><a id="changeImage" href="#">换一张</a></td>
</tr>
<tr>
<td><input type="button" value="登录" onclick="dl();"></td>
<td><input type="button" value="注册" onclick="window.location.href='register.jsp';"></td>
</tr>
</table>
</form>
</div>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<html>
<head>
<script type="text/javascript" src="js/jquery-1.4.3.js"></script>
<script type="text/javascript">
function zc(){
var url="/believe/Bel_zcjy";
var zcData="code="+$("#nameCode").val();
$.ajax({
type:'post',
url:url,
dataType:'json',
data:zcData,
success:function(code){
if(code){
// alert("该用户名已注册!");
$("#div").html("该用户名已注册,重新输入!");
//alert($("#div").text());
setTimeout('sx()',2000);
}else{
var saveFlag=true;
if($("#nameCode").val()==''){
saveFlag=false;
alert("请填写帐号");
}
else if($("#password").val()==''){
saveFlag=false;
alert("请填写密码");
}
else if($("#pwdcf").val()==''){
saveFlag=false;
alert("请再次输入密码");
}
else if($("#pwdcf").val()!=$("#password").val()){
saveFlag=false;
alert("两次密码不相同!");
$("#password").val('');
$("#pwdcf").val('');
}
if(saveFlag==true){
$("#BelZc").submit();
alert("注册成功！");
}
}
}
});
}
function sx(){
$("#div").html('');
$("#nameCode").val('');
//window.location.href='register.jsp';
}
</script>
<style type="text/css">
.ty{
width: 130;
}
.zt{
letter-spacing: 32px;
}
.divzh{
color: red;
font-size: 15px;
}
</style>
</head>
<body>
<form action="Bel_zczh" method="get" id="BelZc">
<table>
<tr>
<td><span class="zt">帐号</span>：</td>
<td><input type="text" value="" name="us.nameCode" id="nameCode" class="ty"/></td>
<td><div id="div" class="divzh"></div></td>
</tr>
<tr>
<td><span class="zt">密码</span>：</td>
<td><input type="password" value="" name="us.password" id="password" class="ty"/></td>
</tr>
<tr>
<td>密码确认：</td>
<td><input type="password" value="" id="pwdcf" class="ty"/></td>
</tr>
</table>
<div>
<input type="button" value="注册" onclick="zc();"/>
<input type="button" value="返回" onclick="location.href='login';"/>
</div>
</form>
</body>
</html>
public class loginAction extends BaseAction{
private String nameCode;
private String password;//用户输入密码
private String imageName;//用户输入验证码
private belDao bel=new belDao();
//验证密码次数
private String nameCodeByPwd;//数据库密码
private String namePwd;
public String execute() throws Exception{
session.put("user", nameCode);//拦截器过滤
return "success";
}
//用户名,密码校验
public String pwdYz() throws Exception{
String yzm=(String)session.get("image_code");
nameCodeByPwd = bel.pwdYz(namePwd);
if (nameCodeByPwd == null) {
nameCodeByPwd = "0";// 用户名为空
}
else if (!yzm.equals(imageName)) {
nameCodeByPwd = "2";// 验证码错误
}
else if (!nameCodeByPwd.equals(password)) {
nameCodeByPwd = "1";// 密码错误
}
//System.out.println(nameCodeByPwd);
return "success";
}
//查询(搜索功能)
public List<Believe> Query(Integer id,String score,int page,int pageSize) throws Exception{
int begin=(page-1)*pageSize;
Connection con=null;
List<Believe> list=new ArrayList<Believe>();
try {
con=dbutil.openConnection();
PreparedStatement ps=con.prepareStatement(select);
if(null!=id && !"".equals(id)){
ps.setInt(1, id);
}else{
ps.setString(1, "%");
}
if(null!=score && !"".equals(score)){
ps.setString(2, score);
}else{
ps.setString(2, "%");
}
ps.setInt(3, begin);
ps.setInt(4, pageSize);
ResultSet rs=ps.executeQuery();
while(rs.next()){
believe=new Believe();
believe.setId(rs.getInt("bel_id"));
believe.setName(rs.getString("bel_name"));
believe.setScore(rs.getString("bel_score"));
believe.setBelClass(rs.getString("bel_class"));
list.add(believe);
}
return list;
} catch (Exception e) {
e.printStackTrace();
}finally{
dbutil.closeConnection();
}
return list;
}
//maxPage逻辑判断（页数显示条数判断）
public int countMaxPage(int pageSize,Integer id,String score) throws Exception{
int maxPage;
try {
Connection con=dbutil.openConnection();
PreparedStatement ps=con.prepareStatement(findPageMax);
if(null!=id && !"".equals(id)){
ps.setInt(1, id);
}else{
ps.setString(1, "%");
}
if(null!=score && !"".equals(score)){
ps.setString(2, score);
}else{
ps.setString(2, "%");
}
ResultSet rs=ps.executeQuery();
rs.next();
int totalSize=rs.getInt(1);//totalSize数据库总记录数目
if( totalSize % pageSize==0 ){
maxPage=totalSize / pageSize;
return maxPage;
}else{
maxPage=totalSize / pageSize +1;
return maxPage;
}
} catch (Exception e) {
e.printStackTrace();
throw e;
}finally{
dbutil.closeConnection();
}
}
//注册验证用户名是否重复
public Boolean repeatCode(String Code) throws Exception{
Connection conn=null;
boolean codeYanZ=false;
try {
conn=dbutil.openConnection();
PreparedStatement ps=conn.prepareStatement(findByCode);
ps.setString(1, Code);
ResultSet rs=ps.executeQuery();
if(rs.next()){
codeYanZ=true;
}
} catch (Exception e) {
e.printStackTrace();
}finally{
dbutil.closeConnection();
}
return codeYanZ;
}
关于上面的believes迭代，后台定义believes的list结果集，设置List的set和get方法，前台即可直接取值。
private List<User> believes=new ArrayList<User>();
believes=数据库结果集；
