web项目+Struts2+Mybatis

来源：互联网发布：网络上赌博赢了5千万编辑：程序博客网时间：2024/06/06 05:23

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.给该项目创建相关的包![这里写图片描述](http://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包中创建LoginActionLoginAction.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.javaIPersonService.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.javaPersonServiceImpl.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);}@Overridepublic 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;}@Overridepublic 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;}@Overridepublic 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;}@Overridepublic 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;}@Overridepublic 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.javaPersonMapper.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.xmlPersonMapper.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;

@Testpublic 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();     } }

}
“`

0 0