1.首先创建一个web项目
2.给该项目添加struts2依赖
这时项目自动创建web.xml,struts.xml
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<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">
<display-name>StrutsTest</display-name>
<!--Struts2核心分发器,核心配置-->
<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.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
</web-app>
Struts.xml如下
3.给该项目创建相关的包
![这里写图片描述](https://img-blog.csdn.net/20161013151003956)
4.添加mess.properties(资源文件,后面相关的jsp页面会用到)
mess.properties
loginPage=\u767B\u9646\u9875\u9762
erroPage=\u5931\u8D25\u9875\u9762
succPage=\u6210\u529F\u9875\u9762
user=\u7528\u6237\u540D
pass=\u5BC6\u7801
login=\u767B\u9646
search=\u67E5\u8BE2
personId=\u7528\u6237ID
personName=\u7528\u6237\u59D3\u540D:
personAge=\u7528\u6237\u5E74\u9F84
insert=\u63D2\u5165
update=\u66F4\u6539\u7528\u6237\u4FE1\u606F
delete=\u5220\u9664\u7528\u6237\u4FE1\u606F
4.创建数据库连接配置文件 mybatis-config.xml
<!-- Register Alias -->
<typeAliases>
<typeAlias alias="personMap" type="com.mapper.PersonMapper" />
</typeAliases>
<!-- Data Source -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="oracle.jdbc.driver.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@localhost:1521:ORCL" />
<property name="username" value="science" />
<property name="password" value="liu19xin89" />
</dataSource>
</environment>
</environments>
<!-- Register Mapper 注册mapper -->
<mappers>
<!-- SQL Mapper -->
<mapper resource="com/mapper/person.xml" />
</mappers>
5.创建person.java(bean用来封装前台页面的传递参数)
person.java
package com.bean;
import java.io.Serializable;
public class Person implements Serializable {
private int personId;
private String personName;
private int personAge;
public int getPersonId() {
return personId;
}
public void setPersonId(int personId) {
this.personId = personId;
}
public String getPersonName() {
return personName;
}
public void setPersonName(String personName) {
this.personName = personName;
}
public int getPersonAge() {
return personAge;
}
public void setPersonAge(int personAge) {
this.personAge = personAge;
}
}
6.创建首页面
index.jsp
<%@ page language=”java” import=”java.util.*” pageEncoding=”utf-8” isELIgnored=”false”%>
<%@ taglib uri=”/struts-tags” prefix=”s” %>
<%
String path = request.getContextPath();
String basePath =request.getScheme()+”://”+request.getServerName()+”:”+request.getServerPort()+path+”/”;%>
”>
<title>
<s:text name="loginPage"></s:text>
</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
登录页面
<h3>--------------查询用户信息---------------------</h3>
<s:form action="/login!searchPer">
<s:textfield name="per.personName" key="user"></s:textfield>
<s:submit key="search"></s:submit>
</s:form>
<h3>--------------插入用户信息---------------------</h3>
<s:form action="/login!insertPer">
<s:textfield name="per.personId" key="personId"></s:textfield>
<s:textfield name="per.personName" key="personName"></s:textfield>
<s:textfield name="per.personAge" key="personAge"></s:textfield>
<s:submit key="insert"></s:submit>
</s:form>
<h3>-----------------更改用户信息-----------------------------</h3>
<s:form action="/login!updatePer">
<s:textfield name="per.personId" key="personId"></s:textfield>
<s:textfield name="per.personName" key="personName"></s:textfield>
<s:textfield name="per.personAge" key="personAge"></s:textfield>
<s:submit key="update"></s:submit>
</s:form>
<h3>-----------------删除用户信息-----------------------------</h3>
<s:form action="/login!deletePer">
<s:textfield name="per.personId" key="personId"></s:textfield>
7.在action包中创建LoginAction
LoginAction.java
package com.action;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import org.apache.ibatis.transaction.Transaction;
import com.bean.Person;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.service.IPersonService;
import com.service.PersonServiceImpl;
public class LoginAction extends ActionSupport {
private static final long serialVersionUID = 1L;
//接收前台页面传递的参数(封装的实体类)
private Person per;
private IPersonService iper = new PersonServiceImpl();;
private List plist = new ArrayList();
public String searchPer() throws IOException{
plist = iper.getPersonListByName(per);
ActionContext.getContext().getSession().put("plist", plist);
return "success";
}
//插入用户信息
public String insertPer () throws IOException{
iper.insertPer(per);
plist = iper.getAllPersonList();
ActionContext.getContext().getSession().put("plist", plist);
return "success";
}
//更改用户信息
public String updatePer () throws IOException{
iper.updatePer(per);
plist = iper.getAllPersonList();
ActionContext.getContext().getSession().put("plist", plist);
return "success";
}
//删除用户信息
public String deletePer () throws IOException{
iper.deletePer(per);
plist = iper.getAllPersonList();
ActionContext.getContext().getSession().put(“plist”, plist);
return “success”;
}
public Person getPer() {
return per;
}
public void setPer(Person per) {
this.per = per;
}
}
9.在service中创建IPersonService.java
IPersonService.java
package com.service;
import java.io.IOException;
import java.util.List;
import com.bean.Person;
public interface IPersonService {
//查询用户信息
public List getPersonListByName(Person p) throws IOException;
//插入用户信息
public List insertPer(Person p) throws IOException;
//更改用户信息
public List updatePer(Person p) throws IOException;
//删除用户信息
public List deletePer(Person p) throws IOException;
//查询所有用户信息
public List getAllPersonList() throws IOException;
}
9.创建PersonServiceImpl.java
PersonServiceImpl.java
package com.service;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import com.bean.Person;
import com.mapper.PersonMapper;
import org.apache.ibatis.io.Resources;
public class PersonServiceImpl implements IPersonService {
public static SqlSessionFactory sqlSessionFactory = null;
public static void kickStartMybatis() throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
@Override
public List<Person> getPersonListByName(Person per) throws IOException{
// TODO Auto-generated method stub
PersonServiceImpl.kickStartMybatis();
SqlSession session = sqlSessionFactory.openSession();
List<Person> plist = null;
try{
PersonMapper pm =session.getMapper(PersonMapper.class);
plist =pm.queryPerson(per);
for(Person p : plist){
System.out.println(p.getPersonId()+"\t"+p.getPersonName()+"\t"+p.getPersonAge());
}
}catch(Exception e){
e.printStackTrace();
session.close();
}
return plist;
}
@Override
public List<Person> insertPer(Person p) throws IOException {
// TODO Auto-generated method stub
boolean flag =false;
List <Person> plist =null;
PersonServiceImpl.kickStartMybatis();
SqlSession session = sqlSessionFactory.openSession();
try{
PersonMapper pm =session.getMapper(PersonMapper.class);
flag = pm.insertPer(p);
if(flag){
session.commit();
System.out.println("数据插入成功!");
}else{
System.out.println("数据插入失败!");
}
plist = pm.queryPerson(p);
}catch(Exception e){
e.printStackTrace();
session.close();
}
return plist;
}
@Override
public List<Person> updatePer(Person p) throws IOException {
// TODO Auto-generated method stub
boolean flag =false;
List <Person> plist =null;
PersonServiceImpl.kickStartMybatis();
SqlSession session = sqlSessionFactory.openSession();
try{
PersonMapper pm =session.getMapper(PersonMapper.class);
flag = pm.updatePer(p);
if(flag){
session.commit();
System.out.println("数据更改成功!");
}else{
System.out.println("数据更改失败!");
}
plist = pm.queryPerson(p);
}catch(Exception e){
e.printStackTrace();
session.close();
}
return plist;
}
@Override
public List<Person> deletePer(Person p) throws IOException {
// TODO Auto-generated method stub
boolean flag =false;
List <Person> plist =null;
PersonServiceImpl.kickStartMybatis();
SqlSession session = sqlSessionFactory.openSession();
try{
PersonMapper pm =session.getMapper(PersonMapper.class);
flag = pm.deletePer(p);
if(flag){
session.commit();
System.out.println("数据删除成功!");
}else{
System.out.println("数据删除失败!");
}
plist = pm.queryPerson(p);
}catch(Exception e){
e.printStackTrace();
session.close();
}
return plist;
}
@Override
public List<Person> getAllPersonList() throws IOException {
// TODO Auto-generated method stub
PersonServiceImpl.kickStartMybatis();
SqlSession session = sqlSessionFactory.openSession();
List<Person> plist = null;
try{
PersonMapper pm =session.getMapper(PersonMapper.class);
plist =pm.queryAllPersonList();
for(Person p : plist){
System.out.println(p.getPersonId()+"\t"+p.getPersonName()+"\t"+p.getPersonAge());
}
}catch(Exception e){
e.printStackTrace();
session.close();
}
return plist;
}
}
10.在mapper中创建PersonMapper.java
PersonMapper.java
package com.mapper;
import java.util.List;
import com.bean.Person;
public interface PersonMapper {
public List queryPerson(Person p);
public List queryAllPersonList();
public boolean insertPer (Person p);
public boolean updatePer (Person p);
public boolean deletePer (Person p);
}
11.创建PersonMapper.xml
PersonMapper.xml
**
select * from person p where p.personName like ‘%${personName}%’
insert into person(personId,personName,personAge) values (#{personId},#{personName},#{personAge})
update person p set p.personId = #{personId},
p.personName = #{personName},p.personAge = #{personAge}
where p.personId = #{personId}
delete person p where p.personId = #{personId}
select * from person p
**
12.编写测试类测试
MybatisTest.java
package com.test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import com.bean.Person;
import com.mapper.PersonMapper;
public class MybatisTest {
public static SqlSessionFactory sqlSessionFactory = null;
@Test
public void testQuery() throws Exception{
Person p = new Person();
p.setPersonName("tom");
MybatisTest.kickStartMybatis();
this.queryPerson(p);
}
public static void kickStartMybatis() throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
//查询用户信息
public void queryPerson(Person per) throws Exception{
SqlSession session = sqlSessionFactory.openSession();
try{
PersonMapper pm =session.getMapper(PersonMapper.class);
List<Person> plist =pm.queryPerson(per);
for(Person p : plist){
System.out.println(p.getPersonId()+"\t"+p.getPersonName()+"\t"+p.getPersonAge());
}
}catch(Exception e){
e.printStackTrace();
session.close();
}
}
}
“`