總結(jié)一下今天一個(gè)成功的小實(shí)驗(yàn)：Mybatis+Struts2的結(jié)合:實(shí)現(xiàn)用戶插入和查找。刪除和修改如果以后寫(xiě)了，會(huì)繼續(xù)更新。
一 準(zhǔn)備工作。
1.新建一個(gè)java web項(xiàng)目。
2.在webContent/lib目錄下導(dǎo)入所需要的jar包。
a.struts2需要的jar包。
struts2 xwork-core.jar strut2-core.jar ognl.jar commoms-lang.jar freemarker.jar commons-fileupload.jar
包的位置：
struts-2.3.24.1-all/struts-2.3.24.1/apps/WEB-INF/lib
我下載的struts2的版本這個(gè)目錄下有13個(gè)jar包，每個(gè)jar包的作用網(wǎng)上都可以查到。正常使用加入這六個(gè)就可以了。
b.mybatis需要的的jar包。
asm.jarcglib.jarcommons-logging-.jarlog4j.jarmybatis.jarslf4j-api.jarslf4j-log4j12.jar
c.MySQL需要的jar包。
mysql-connector-java-5.1.7-bin.jar
到此準(zhǔn)備工作就做好了。
二.工程目錄
在這里我貼出我的工程目錄，便于我后面進(jìn)行描述。
三.寫(xiě)代碼。
對(duì)于Java web 工程的搭建，服務(wù)器的搭建我就不多說(shuō)了，因?yàn)榫W(wǎng)上資料很多。(雖然我寫(xiě)的也有很多，但是只是想給自己做一個(gè)簡(jiǎn)單的總結(jié)，順便分享給需要的人)
1.webContent/lib/web.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> 3 <display-name>MybatisAndStruts2</display-name> 4 <welcome-file-list> 5 <welcome-file>index.jsp</welcome-file> 6 </welcome-file-list> 7 <filter> 8 <filter-name>struts2</filter-name> 9 <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPRepareAndExecuteFilter</filter-class>10 </filter>11 <filter-mapping>12 <filter-name>struts2</filter-name>13 <url-pattern>/*</url-pattern>14 </filter-mapping>15 </web-app>
2.index.jsp
1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <% 4 5 String path = request.getContextPath(); 6 String BasePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; 7 8 %> 9 10 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">11 <html>12 <head>13 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">14 <base href="<%=BasePath %>"></base>15 <title>首頁(yè)</title>16 </head>17 <body>18 <h3 align="center">添加用戶</h3>19 <form action="user/user!add">20 <table align="center">21 <tr>22 <td><input type="text" name="username"></td>23 </tr>24 <tr>25 <td><input type="passWord" name="password"></td>26 </tr>27 <tr>28 <td><input type="submit" value="提交"></td>29 </tr>30 </table>31 </form>32 33 <h3 align="center">查詢所有用戶</h3>34 <p align="center"><a href="user/user!get">查詢</a></p>35 </body>36 </html>
3. user_add_success.jsp
1 <%@ page language="java" contentType="text/html; charset=ISO-8859-1" 2 pageEncoding="ISO-8859-1"%> 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 4 <html> 5 <head> 6 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> 7 <title>Insert title here</title> 8 </head> 9 <body bgcolor="#33CC99">10 <h3 align="center">user add success</h3></body>11 </html>
4. user_get.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@taglib prefix="s" uri="/struts-tags"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body bgcolor="#33CC99"><h3 align="center">用戶列表</h3></body> <table align="center"> <tr> <td>ID</td> <td>用戶名</td> <td>密碼</td> </tr> <s:iterator value="users" > <tr> <td> <s:property value="id" /> </td> <td> <s:property value="username" /> </td> <td> <s:property value="password" /> </td> </tr> </s:iterator> </table></html>
5. struts.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE struts PUBLIC 3 "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN" 4 "http://struts.apache.org/dtds/struts-2.3.dtd"> 5 6 <struts> 7 <constant name="struts.devMode" value="true" /> 8 <constant name="struts.enable.DynamicMethodInvocation" value="true" /> 9 10 <package name="default" namespace="/user" extends="struts-default">11 <action name="user" class="com.hjj.action.UserAction" >12 <result name="add">13 /user_add_success.jsp14 </result>15 16 <result name="get">17 /user_get.jsp?users=${users}18 </result>19 </action>20 </package>21 </struts>
6. conf.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> 3 <configuration> 4 <environments default="development"> 5 <environment id="development"> 6 <transactionManager type="JDBC" /> 7 <dataSource type="POOLED"> 8 <property name="driver" value="com.mysql.jdbc.Driver" /> 9 <property name="url" value="jdbc:mysql://localhost:3306/mybatis" />10 <property name="username" value="root" />11 <property name="password" value="000000" />12 </dataSource>13 </environment>14 </environments>15 <mappers>16 <mapper resource="com/hjj/dao/userMapper.xml"/>17 </mappers>18 </configuration>
7. userMapper.xml
1 <?xml version="1.0" encoding="UTF-8" ?> 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 3 <mapper namespace="com.hjj.dao.userMapper"> 4 <select id="getUser" resultType="com.hjj.model.User"> 5 select * from user; 6 </select> 7 8 <insert id="insertUser" parameterType="com.hjj.model.User"> 9 insert into user (username,password) values (#{username},#{password});10 </insert> 11 </mapper>
8 .User.java
1 package com.hjj.model; 2 3 public class User { 4 5 private int id; 6 private String username; 7 private String password; 8 9 public User(int id, String username, String password) {10 super();11 this.id = id;12 this.username = username;13 this.password = password;14 }15 public User() {16 super();17 // TODO Auto-generated constructor stub18 }19 20 public int getId() {21 return id;22 }23 public void setId(int id) {24 this.id = id;25 }26 public String getUsername() {27 return username;28 }29 public void setUsername(String username) {30 this.username = username;31 }32 public String getPassword() {33 return password;34 }35 public void setPassword(String password) {36 this.password = password;37 }38 39 @Override40 public String toString() {41 return "User [id=" + id + ", username=" + username + ", password=" + password + "]";42 }43 }
9. UserAction.java
1 package com.hjj.action; 2 3 import java.io.IOException; 4 import java.util.ArrayList; 5 import java.util.List; 6 7 import com.hjj.dao.MysqlDAO; 8 import com.hjj.model.*; 9 import com.opensymphony.xwork2.ActionSupport;10 import com.opensymphony.xwork2.ModelDriven;11 12 public class UserAction extends ActionSupport implements ModelDriven<User>{13 private User user = null; 14 List<User> users = new ArrayList<User>();15 16 17 public List<User> getUsers() {18 return users;19 }20 21 public void setUsers(List<User> users) {22 this.users = users;23 }24 25 public String add() throws IOException{26 System.out.println(user);27 MysqlDAO dao = new MysqlDAO();28 dao.insertUser(user); 29 return "add";30 }31 32 public String get() throws IOException{33 MysqlDAO dao = new MysqlDAO();34 users = dao.getUsers();35 return "get";36 }37 38 39 public User getModel() {40 if(user == null){41 user = new User();42 }43 return user;44 }45 46 }
10 . MysqlDAO.java
1 package com.hjj.dao; 2 3 import java.io.IOException; 4 import java.io.Reader; 5 import java.util.ArrayList; 6 import java.util.List; 7 8 import org.apache.ibatis.io.Resources; 9 import org.apache.ibatis.session.SqlSession;10 import org.apache.ibatis.session.SqlSessionFactory;11 import org.apache.ibatis.session.SqlSessionFactoryBuilder;12 13 import com.hjj.model.User;14 15 public class MysqlDAO {16 17 private SqlSessionFactory sessionFactory = null;18 private SqlSession session = null;19 20 public MysqlDAO() throws IOException{21 String resource = "conf.xml"; 22 23 Reader reader = Resources.getResourceAsReader(resource); 24 25 sessionFactory = new SqlSessionFactoryBuilder().build(reader);26 27 }28 public List<User> getUsers(){29 30 List<User> users = new ArrayList<User>();31 32 session = sessionFactory.openSession();33 34 String statement = "com.hjj.dao.userMapper.getUser";35 36 users = session.selectList(statement);37 38 session.commit();39 40 return users;41 }42 43 public void insertUser(User user){44 45 session = sessionFactory.openSession();46 47 String statement = "com.hjj.dao.userMapper.insertUser";48 49 int row = session.insert(statement, user);50 session.commit();51 System.out.println(row);52 }53 }
四.運(yùn)行代碼。
1.地址欄輸入：http://localhost:8080/MybatisAndStruts/index.jsp。顯示頁(yè)面如下(頁(yè)面簡(jiǎn)單丑陋)。
第一個(gè)文本輸入框?yàn)橛脩裘诙€(gè)為密碼。
2. 提交后頁(yè)面顯示
3.返回index.jsp。點(diǎn)擊查詢。顯示列表。
至此，所有的代碼和測(cè)試已經(jīng)寫(xiě)完了。這應(yīng)該算是很簡(jiǎn)單的一個(gè)mybatis和struts的整合了，就當(dāng)做入門(mén)練習(xí)了。至于里面的一些東西，例如ModelDriven,和user/user!add這些東西，學(xué)過(guò)struts2的人應(yīng)該都知道。不過(guò)為了自己能夠更深刻的理解，在明天我也會(huì)做出總結(jié)。
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注
