struts2实现用户登录 并能查询数据库中的数据显示出来 按条件查询

Question

struts2实现用户登录 并能查询数据库中的数据显示出来 按条件查询，多张表按条件查询 我要例子 主要的功能是显示数据库的内容 请看清要求！！！

Answer 1

用 户

密   码

             这是web-xml配置文件:
             <web-app id="WebApp_9" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
            xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
            <display-name>power</display-name>

            <filter>
                <filter-name>struts2</filter-name>
                <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
            </filter>

        <filter-mapping>
            <filter-name>struts2</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>

        <welcome-file-list>
            <welcome-file>index.jsp</welcome-file>
        </welcome-file-list>
        </web-app>

        这是struts.xml配置文件：

<!DOCTYPE struts SYSTEM "struts-2.3.dtd" >
<struts>
<constant name="struts.i18n.encoding" value="UTF-8"></constant>
<constant name="struts.action.extension" value="action,shtml,do,,"/>
<constant name="struts.enable.DynamicMethodInvocation" value="true"/>

<package name="all" extends="struts-default" >
<interceptors>
    <interceptor name="myInterceptor" class="com.zdj.action.MyInterceptor"></interceptor>
    <interceptor-stack name="mystack">
        <interceptor-ref name="myInterceptor"/>
        <interceptor-ref name="defaultStack"/>
    </interceptor-stack>
</interceptors>
<default-interceptor-ref name="myInterceptor"></default-interceptor-ref>

<action name="userAction" class="com.zdj.action.LoginAction" method="list">
    <result name="list">WEB-INF/list.jsp</result>
    <result name="add" type="redirectAction">userAction</result>
    <result name="delete" type="redirectAction">userAction</result>
    <result name="update1">WEB-INF/update.jsp</result>
    <result name="update2" type="redirectAction">userAction</result>
</action>
</package>
</struts>

后台LoginAction文件:

public class LoginAction extends ActionSupport{
private List userlist;
private User user;

UserDao userDao=new UserDaoImpl();
public String list(){
userlist=userDao.lists();
return "list";
}
public String add(){
userDao.adduser(user);
return "add";
}
public String delete(){
userDao.deleteuser(user);
return "delete";
}
public String update1(){
user=userDao.finduser(user);
return "update1";
}
public String update2(){
userDao.updateuser(user);
return "update2";
}

public List getUserlist() {
return userlist;
}

public void setUserlist(List userlist) {
this.userlist = userlist;
}

public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
}
最后的实现类就只贴个list把，两个表查询：
@Override
public List lists() {
List list=null;
Connection conn=DBCPDBUtils.getConn();
QueryRunner qr=new QueryRunner();
String sql="SELECT uid,uname,pwd,sex,dname FROM USER u,department d WHERE u.did=d.did";
try {
list=qr.query(conn, sql,new ArrayListHandler());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBCPDBUtils.closeConn(conn);
}
return list;
}
祝你好运！