1.web.xml 配置文件
[java
1 < xml version="1.0" encoding="UTF-8" >
2
3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
5 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
6
7 struts2
8 org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
9
10
11
12 struts2
13 /*
14
15
16
17 index.jsp
18
19
20 2.struts.xml配置文件，struts2配置最重要的文件，名字不能修改
21 < xml version="1.0" encoding="UTF-8" >
22
23 "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
24 "http://struts.apache.org/dtds/struts-2.3.dtd">
25
26
27
32
33
46
47
51 /sc.
jsp
52 /index.jsp
53
54
55
56 3. c3p0-config.xmlc 3p0配置文件
57
58
59 com.
mysql.jdbc.Driver
60 jdbc:mysql://localhost:3306/struts2
61 root
62 root
63 10
64 30
65 100
66 10
67 200
68
69
70
71 com.mysql.jdbc.Driver
72 jdbc:mysql://localhost:3306/struts2
73 root
74 root
75 5
76 10
77 50
78 1000
79
80
81 4.dao实现类
82 package www.csdn.dao;
83
84 import java.sql.SQLException;
85
86 import org.apache.commons.dbutils.QueryRunner;
87 import org.apache.commons.dbutils.handlers.BeanHandler;
88
89 import www.csdn.domain.User;
90 import com.csdn.util.DBManager;
91
92 public class ActionDao {
93
94 public User login(String username,String password)throws SQLException{
95 QueryRunner qr = new QueryRunner(DBManager.getDataSource());
96 String sql = "select * from login where username = and password = ";
97 Object[] params = {username,password};
98 User user = (User) qr.query(sql,params,new BeanHandler(User.class));
99 return user;
100
101 }
102
103 }
104 5.action主要类
105 package www.csdn.struts2.demo;
106
107 import java.sql.SQLException;
108
109 import www.csdn.dao.ActionDao;
110 import www.csdn.domain.User;
111
112 import com.opensymphony.xwork2.ActionSupport;
113
114 /***
115 *
116 * 自己编写的action类可以不继承ActionSupport，不继承直接使用自己编写的类不会出错；
117 * 但是大多数情况下要继承ActionSupport类或实现Action接口，因为ActionSupport类中封装了大多数需要的常量，
118 * 继承之后就可以直接使用这些常量而不需要再自己去定义
119 */
120 public class DemoAction extends A