本文档详细介绍了如何使用Struts2框架结合MySQL数据库进行增删改查操作。首先展示了数据库设计，包括person表的结构和初始数据。接着，介绍了DAO设计，包括DataBaseConnection、PersonVo、PersonDAO接口及其实现类PersonDAOImpl，以及DAOFactory工厂类的使用。然后，展示了UserAction类的代码，涵盖了查询所有、添加、删除、更新和登录验证等功能。最后提到了Struts.xml和web.xml的配置，并给出了登录、查询、更新和添加用户的页面设计。
一、数据库设计:
/*
NavicatMySQLDataTransfer
SourceServer:localhost
SourceServerVersion:50611
SourceHost:localhost:3306
SourceDatabase:mldn
TargetServerType:MYSQL
TargetServerVersion:50611
FileEncoding:65001
Date:2013-09-1621:03:49
*/
SETFOREIGN_KEY_CHECKS=0;
------------------------------
--Tablestructurefor`person`
------------------------------
DROPTABLEIFEXISTS`person`;
CREATETABLE`person`(
`id`int(4)NOTNULLAUTO_INCREMENT,
`name`varchar(20)NOTNULL,
`password`varchar(20)DEFAULTNULL,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=25DEFAULTCHARSET=utf8;
------------------------------
--Recordsofperson
------------------------------
INSERTINTO`person`VALUES('1','aa','aa');
INSERTINTO`person`VALUES('2','user','user12');
INSERTINTO`person`VALUES('4','mldn','mldn');
INSERTINTO`person`VALUES('14','cc','aa');
INSERTINTO`person`VALUES('15','cc','aa');
INSERTINTO`person`VALUES('19','xiaoqun','aa');
INSERTINTO`person`VALUES('21','cc','cc');
INSERTINTO`person`VALUES('22','cc','dd');
INSERTINTO`person`VALUES('23','bb','cc');
二、DAO设计
1、DataBaseConnection.java
//本类只用于数据库连接及关闭操作
packageorg.lxh.dbc;
importjava.sql.*;
publicclassDataBaseConnection
{
//属性
//定义数据库操作的常量、对象
//数据库驱动程序
privatefinalStringDBDRIVER="com.mysql.jdbc.Driver";
//数据库连接地址
privatefinalStringDBURL="jdbc:mysql://localhost:3306/mldn";
//数据库用户名
privatefinalStringDBUSER="root";
//数据库连接密码
privatefinalStringDBPASSWORD="root";
//声明一个数据库连接对象
privateConnectionconn=null;
//在构造方法之中连接数据库
publicDataBaseConnection()
{
try
{
//加载驱动程序
Class.forName(DBDRIVER);
//连接数据库
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
}
catch(Exceptione)
{
System.out.println(e);
}
}
//返回一个数据库连接
publicConnectiongetConnection()
{
///返回连接对象
returnthis.conn;
}
//关闭数据库连接
publicvoidclose()
{
try
{
this.conn.close();
}
catch(Exceptione)
{
}
}
};
2、PersonVo.java
//只包含setter和getter方法的类
packageorg.lxh.vo;
publicclassPersonVo
{
privateintid;
privateStringname;
privateStringpassword;
publicintgetId(){
returnid;
}
publicvoidsetId(intid){
this.id=id;
}
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicStringgetPassword(){
returnpassword;
}
publicvoidsetPassword(Stringpassword){
this.password=password;
}
};
3、PersonDAO.java
//本接口定义本项目中所操作person表的全部方法
packageorg.lxh.dao;
//使用PersonVo类
importorg.lxh.vo.*;
importjava.util.List;
//登录验证的接口
publicinterfacePersonDAO
{
//需要一个登陆验证的方法
publicbooleanisLogin(PersonVopv);
publicvoidinsert(PersonVopv)throwsException;
publicvoiddelete(intid)throwsException;
publicvoidupdate(PersonVopv)throwsException;
publicListqueryById(intid)throwsException;
publicListqueryAll()throwsException;
publicListqueryByLike(Stringcond)throwsException;
}
4、PersonDAOIpml.java
//具体实现DAO接口的类
packageorg.lxh.daoimpl;
//需要连接数据库
//需要对VO的内容进行具体的验证
importjava.sql.*;
importjava.util.List;
importorg.lxh.dao.*;
importorg.lxh.dbc.*;
importorg.lxh.factory.DAOFactory;
importorg.lxh.vo.*;
importjava.util.List;
importjava.util.ArrayList;
publicclassPersonDAOImplimplementsPersonDAO
{
//验证登录，已实现
publicbooleanisLogin(PersonVopv)
{
booleanflag=false;
//在此处成具体的数据库验证
//声明一个数据库操作对象
PreparedStatementpstmt=null;
//声明一个结果集对象
ResultSetrs=null;
//声明一个SQL变量，用于保存SQL语句
Stringsql=null;
//DataBaseConnection为具体的数据库连接及关闭操作类
DataBaseConnectiondbc=null;
//连接数据库
dbc=newDataBaseConnection();
//编写SQL语句
sql="SELECT*FROMpersonWHEREname=?andpassword=?";
try
{
//实例化数据库操作对象
pstmt=dbc.getConnection().prepareStatement(sql);
//设置pstmt的内容，是按ID和密码验证
pstmt.setString(1,pv.getName());//设置pstmt第一个?号的值
pstmt.setString(2,pv.getPassword());//设置pstmt第二个?号的值
//查询记录
rs=pstmt.executeQuery();
//判断是否有记录
if(rs.next())
{
//如果有记录，则执行此段代码
//用户是合法的，可以登陆
flag=true;
}
//依次关闭
rs.close();
pstmt.close();
}
catch(Exceptione)
{
System.out.println(e);
}
finally
{
//最后一定要保证数据库已被关闭
dbc.close();
}
returnflag;
}
//插入数据
publicvoidinsert(PersonVopv)throwsException{
//TODOAuto-generatedmethodstub
Stringsql="INSERTINTOperson(name,password)VALUES(?,?)";
PreparedStatementpstmt=null;
DataBaseConnectiondbc=null;
dbc=newDataBaseConnection();
try
{
pstmt=dbc.getConnection().prepareStatement(sql);
pstmt.setString(1,pv.getName());
pstmt.setString(2,pv.getPassword());
pstmt.executeUpdate();
pstmt.close();
}
catch(Exceptione)
{
//System.out.println(e);
thrownewException("操作中出现错误！！！");
}
finally
{
dbc.close();
}
}
publicvoiddelete(intid)throwsException{
//TODOAuto-generatedmethodstub
Stringsql="DELETEFROMpersonWHEREid=?";
PreparedStatementpstmt=null;
DataBaseConnectiondbc=null;
dbc=newDataBaseConnection();
try
{
pstmt=dbc.getConnection().prepareStatement(sql);
pstmt.setInt(1,id);
pstmt.executeUpdate();
pstmt.close();
}
catch(Exceptione)
{
thrownewException("操作中出现错误！！！");
}
finally
{
dbc.close();
}
}
//更新
publicvoidupdate(PersonVopv)throwsException{
//TODOAuto-generatedmethodstub
Stringsql="updatepersonsetname=?,password=?whereid=?";
PreparedStatementpstmt=null;
DataBaseConnectiondbc=null;
dbc=newDataBaseConnection();
try
{
pstmt=dbc.getConnection().prepareStatement(sql);
pstmt.setString(1,pv.getName());
pstmt.setString(2,pv.getPassword());
pstmt.setInt(3,pv.getId());
pstmt.executeUpdate();
pstmt.close();
}
catch(Exceptione)
{
//System.out.println(e);
thrownewException("操作中出现错误！！！");
}
finally
{
dbc.close();
}
}
//根据id根据,用于更新
publicListqueryById(intid)throwsException{
Listlist=newArrayList();
PersonVopv=null;
Stringsql="selectid,name,passwordfrompersonwhereid=?";
PreparedStatementpstmt=null;
DataBaseConnectiondbc=null;
dbc=newDataBaseConnection();
try
{
pstmt=dbc.getConnection().prepareStatement(sql);//预编译sql
pstmt.setInt(1,id);
ResultSetrs=pstmt.executeQuery();//执行操作，返回结果集
while(rs.next())//循环读取结果
{
pv=newPersonVo();//实例化PersonVo
pv.setId(rs.getInt(1));
pv.setName(rs.getString(2));
pv.setPassword(rs.getString(3));
list.add(pv);//将user对象中加入到list集合中
}
}
catch(Exceptione)
{
thrownewException("操作错误!");
}
finally
{
dbc.close();
}
returnlist;
}
//查询全部,已实现
publicListqueryAll()throwsException{
//TODOAuto-generatedmethodstub
Listall=newArrayList();
PersonVopv=null;
Stringsql="selectid,name,passwordfromperson";
PreparedStatementpstmt=null;
DataBaseConnectiondbc=null;
dbc=newDataBaseConnection();
try
{
pstmt=dbc.getConnection().prepareStatement(sql);//预编译sql
ResultSetrs=pstmt.executeQuery();//执行操作，返回结果集
while(rs.next())//循环读取结果
{
pv=newPersonVo();//实例化PersonVo
pv.setId(rs.getInt(1));
pv.setName(rs.getString(2));
pv.setPassword(rs.getString(3));
all.add(pv);//将user对象中加入到list集合中
}
}
catch(Exceptione)
{
thrownewException("操作错误!");
}
finally
{
dbc.close();
}
returnall;
}
//模糊查询
publicListqueryByLike(Stringcond)throwsException{
//TODOAuto-generatedmethodstub
Listall=newArrayList();
PersonVopv=null;
Stringsql="selectid,name,pwdfrompersonwherenamelike?orpasswordlike?";
PreparedStatementpstmt=null;
DataBaseConnectiondbc=null;
dbc=newDataBaseConnection();
try
{
pstmt=dbc.getConnection().prepareStatement(sql);//预编译sql
pstmt.setString(1,"%"+cond+"%");
pstmt.setString(2,"%"+cond+"%");
ResultSetrs=pstmt.executeQuery();//执行操作，返回结果集
while(rs.next())//循环读取结果
{
pv=newPersonVo();
pv.setId(rs.getInt(1));
pv.setName(rs.getString(2));
pv.setPassword(rs.getString(3));
all.add(pv);//将user对象中加入到list集合中
}
}
catch(Exceptione)
{
thrownewException("操作错误!");
}
finally
{
dbc.close();
}
returnall;
}
};
5、DAOFactory.java
//取得DAO实例的工厂类
packageorg.lxh.factory;
importorg.lxh.dao.*;
importorg.lxh.daoimpl.*;
publicclassDAOFactory
{
publicstaticPersonDAOgetPersonDAOInstance()
{
returnnewPersonDAOImpl();
}
};
二、struts2.1的Action
UserAction.java
packageorg.lxh.action;
importjava.util.ArrayList;
importjava.util.List;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpSession;
importorg.apache.struts2.ServletActionContext;
importorg.apache.struts2.interceptor.ServletRequestAware;
importorg.apache.struts2.ServletActionContext;
importorg.lxh.dao.*;
importorg.lxh.factory.DAOFactory;
importorg.lxh.vo.*;
importcom.opensymphony.xwork2.ActionSupport;
publicclassUserActionextendsActionSupport{
privatestaticfinallongserialVersionUID=1L;
//name与password与登录表单中的控件名称一致
privateStringname;
privateStringpassword;
privateStringmsg;
privateStringinfo;//测试用例
publicStringgetMsg(){
returnmsg;
}
publicvoidsetMsg(Stringmsg){
this.msg=msg;
}
publicStringgetInfo(){
returninfo;
}
publicvoidsetInfo(Stringinfo){
this.info=info;
}
publicvoidsetName(Stringname){
this.name=name;
System.out.print("name:"+name);
}
publicStringgetPassword(){
returnpassword;
}
publicvoidsetPassword(Stringpassword){
this.password=password;
System.out.print("password:"+password);
}
//查询所有
publicStringqueryAll()throwsException
{
try
{
HttpSessionsession=ServletActionContext.getRequest().getSession();
session.setAttribute("listAll",DAOFactory.getPersonDAOInstance().queryAll());
}
catch(Exceptione)
{
e.printStackTrace();
}
return"queryAll";
}
//添加
publicStringadd()throwsException{
try
{
PersonVopv=newPersonVo();
Stringname=ServletActionContext.getRequest().getParameter("name");
Stringpassword=ServletActionContext.getRequest().getParameter("password");
pv.setName(name);
pv.setPassword(password);
DAOFactory.getPersonDAOInstance().insert(pv);
queryAll();
}
catch(Exceptione)
{
e.printStackTrace();
}
returnqueryAll();
}
//删除用户--已实现
publicStringdelete()throwsException
{
try
{
//获取传送过来的id
Integerid=Integer.parseInt(ServletActionContext.getRequest().getParameter("id"));
DAOFactory.getPersonDAOInstance().delete(id);
}
catch(Exceptione)
{
e.printStackTrace();
}
returnqueryAll();
}
//通过id查询
publicStringqueryById()throwsException
{
Integerid=Integer.parseInt(ServletActionContext.getRequest().getParameter("id"));
try
{
HttpSessionsession=ServletActionContext.getRequest().getSession();
session.setAttribute("query",DAOFactory.getPersonDAOInstance().queryById(id));
}
catch(Exceptione)
{
e.printStackTrace();
}
return"update";
}
//验证登录
publicStringlogin()throwsException
{
booleanflag=false;
PersonVopv=newPersonVo();
if(name==null||"".equals(name))
{
msg="用户名不能为空";
return"err";
}
if(password==null||"".equals(password))
{
msg="密码不能为空";
return"err";
}
pv.setName(name);
pv.setPassword(password);
if(DAOFactory.getPersonDAOInstance().isLogin(pv)==true)
{
//声明session
HttpSessionsession_user=ServletActionContext.getRequest().getSession();
//把登录的用户名保存到session中
session_user.setAttribute("name",name);
flag=true;
returnqueryAll();
}
else
{
msg="用户名或密码不正确";
return"err";
}
}
//更新
publicStringupdate()throwsException{
try
{
PersonVopv=null;
pv=newPersonVo();
Integeridstr=Integer.parseInt(ServletActionContext.getRequest().getParameter("id"));
Stringnames=ServletActionContext.getRequest().getParameter("name");
Stringpasswords=ServletActionContext.getRequest().getParameter("password");
pv.setId(idstr);
//info=idstr.toString();测试用例
pv.setName(name);
pv.setPassword(password);
DAOFactory.getPersonDAOInstance().update(pv);
}
catch(Exceptione)
{
e.printStackTrace();
}
//return"err";测试用例
returnqueryAll();
}
/*
publicstaticvoidmain(String[]args)
{
PersonVopv=newPersonVo();
Stringname="aa";
Stringpassword="aa";
pv.setPassword(password);
pv.setName(name);
if(DAOFactory.getPersonDAOInstance().isLogin(pv))
{
System.out.println("执行成功");
System.out.print("存在此条记录!!!!");
}
}
*/
}
四、Struts.xml配置
-//ApacheSoftwareFoundation//DTDStrutsConfiguration2.1//EN""http://struts.apache.org/dtds/struts-2.1.dtd">
queryAll.jsp
update.jsp
login.jsp
error.jsp
add_success.jsp
五、web.xml配置
id="WebApp_ID"version="2.5">
struts_2
index.html
index.htm
index.jsp
default.html
default.htm
default.jsp
struts2
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
struts2
/*
六、页面设计
1、Login.jsp
-//W3C//DTDHTML4.01Transitional//EN">
登陆界面登陆界面
2、queryAll.jsp
-//W3C//DTDHTML4.01Transitional//EN">
查询所以信息界面if(session.getAttribute("name")==null)
{
response.setHeader("refresh","2;URL=login.jsp");
%>
您还未登陆，请先登陆！！！
两秒后自动跳转到登陆窗口！！！
如果没有跳转，请按这里！！！
}
%>
，你好，欢迎你!
用户信息列表
添加用户信息
idname
password
操作
${list.id}
${list.name}${list.password}修改
删除
3.Update.jsp
-//W3C//DTDHTML4.01Transitional//EN">
修改用户if(session.getAttribute("name")==null)
{
response.setHeader("refresh","2;URL=login.jsp");
%>
您还未登陆，请先登陆！！！
两秒后自动跳转到登陆窗口！！！
如果没有跳转，请按这里！！！
}
%>
4、Add.jsp
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
-//W3C//DTDHTML4.01Transitional//EN">
">
MyJSP'save.jsp'startingpageif(session.getAttribute("name")==null)
{
response.setHeader("refresh","2;URL=login.jsp");
%>
您还未登陆，请先登陆！！！
两秒后自动跳转到登陆窗口！！！
如果没有跳转，请按这里！！！
}
%>
用户名:
扫一扫
222
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
