springboot+spring+spring+mybatis+ajxa(ssmaboot)

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">  <parent>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-parent</artifactId>    <version>1.5.4.RELEASE</version></parent><dependencies><!-- 表示可以发布web程序 自动启动一个tomcat -->    <dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter-web</artifactId>    </dependency>    <!-- 集成mybatis -->    <dependency>  <groupId>org.mybatis.spring.boot</groupId>  <artifactId>mybatis-spring-boot-starter</artifactId>  <version>1.2.1</version></dependency><!-- 自动监听配置文件和jsp --><dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-devtools</artifactId>        <optional>true</optional>    </dependency><!-- 添加转译jsp的jar -->    <dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-tomcat</artifactId><scope>provided</scope></dependency><dependency><groupId>org.apache.tomcat.embed</groupId><artifactId>tomcat-embed-jasper</artifactId><scope>provided</scope></dependency><!-- 配置本地的jar --><dependency> <groupId>ojdbc</groupId>  <artifactId>objdc1</artifactId> <version>3.2.8</version><scope>system</scope><systemPath>C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6.jar</systemPath></dependency><!-- 添加数据源 --> <dependency>                  <groupId>commons-dbcp</groupId>                  <artifactId>commons-dbcp</artifactId>          </dependency>  </dependencies>    <modelVersion>4.0.0</modelVersion>  <groupId>cn.et</groupId>  <artifactId>ssmaboot</artifactId>  <version>0.0.1-SNAPSHOT</version></project>

application.properties 

连接四要素

mysource.url=jdbc:oracle:thin:localhost:1521:orclmysource.username=scottmysource.password=tigermysource.driverClassName=oracle.jdbc.OracleDriver

controller

package cn.et.day20170606.controller;import java.io.IOException;import java.io.OutputStream;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import cn.et.day20170606.entity.EmpEntity;import cn.et.day20170606.service.EmpJaxaService;import cn.et.day20170606.utils.PagingEntity;/** *  * @RestController 目标就是配置 *     消息转换器  jackson *        在action上添加 @ResponseBody * 没有ajax（无刷新）可以用Controller * @author Administrator *http://localhost:8080/day0606/queryEmp *//** * 用ajax就要用这个注解@RestController */@RestController@RequestMapping(value="/day0609")public class EmpJaxaAction {@Autowiredprivate EmpJaxaService empService;/** *查询数据库的分页数据方法 */@RequestMapping(value="/queryPaginEmp")public PagingEntity queryPagingEmp(Integer pagin,String ename){return empService.queryPaginEmp(ename, pagin);}/** *查询数据库的数据方法 */@RequestMapping(value="/queryEmp")public List queryEmp(String ename){return empService.queryEmp(ename);}/** *新增数据库的数据方法 *成功返回1 失败返回0 * @throws IOException  */@RequestMapping(value="/insertEmp")public void insertEmp(EmpEntity emp,OutputStream os) throws IOException{try{empService.insertEmp(emp);os.write("1".getBytes());}catch (Exception e) {os.write("0".getBytes());}}/** *更新数据库的数据方法 * @throws IOException  */@RequestMapping(value="/updateEmp")public void updateEmp(EmpEntity emp,OutputStream os) throws IOException{try{empService.updateEmp(emp);os.write("1".getBytes());}catch (Exception e) {os.write("0".getBytes());}}/** * 删除数据库数据的方法 * @throws IOException  */@RequestMapping(value="/deleteEmp")public void deleteEmp(String empno,OutputStream os) throws IOException{try{empService.deleteEmp(empno);os.write("1".getBytes());}catch (Exception e) {os.write("0".getBytes());}}}

Service（分页的实体类以前的文章有）

package cn.et.day20170606.service.impl;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import cn.et.day20170606.dao.EmpJaxaDao;import cn.et.day20170606.entity.EmpEntity;import cn.et.day20170606.service.EmpJaxaService;import cn.et.day20170606.utils.Calculate;import cn.et.day20170606.utils.PagingEntity;@Servicepublic class EmpJaxaServiceImpl implements EmpJaxaService {@Autowiredprivate EmpJaxaDao empDao;/** *调用查询数据库的数据方法 */public List<EmpEntity> queryEmp(String ename){return empDao.queryEmp(ename);}/** *调用新增数据库的数据方法 */public void insertEmp(EmpEntity emp){empDao.insertEmp(emp);}/** *调用更新数据库的数据方法 */public void updateEmp(EmpEntity emp){empDao.updateEmp(emp);}/** * 调用删除数据库数据的方法 */public void deleteEmp(String empno){empDao.deleteEmp(empno);}/** *查询数据库的分页数据方法 */public PagingEntity queryPaginEmp(String ename,Integer current) {if(ename==null){ename="";}int sum=empDao.queryTotalEmp(ename);PagingEntity p=Calculate.calculate(current, 5, sum);List list=empDao.queryPaginEmp(ename,p.getStart(),p.getEnd());p.setList(list);return p;}}

用于管理事物

package cn.et.day20170606.service;import java.util.List;import java.util.Map;import org.springframework.transaction.annotation.Transactional;import cn.et.day20170606.entity.EmpEntity;import cn.et.day20170606.utils.PagingEntity;/** * 查询事物用只读  * @author Administrator * */@Transactionalpublic interface EmpJaxaService {/** *查询数据库的数据方法 */@Transactional(readOnly=true)public List<EmpEntity> queryEmp(String ename);/** *新增数据库的数据方法 */public void insertEmp(EmpEntity emp);/** *更新数据库的数据方法 */public void updateEmp(EmpEntity emp);/** * 删除数据库数据的方法 */public void deleteEmp(String empno);/** *查询数据库的分页数据方法 */@Transactional(readOnly=true)public PagingEntity queryPaginEmp(String ename,Integer pagin);}

dao

package cn.et.day20170606.dao.impl;import java.io.IOException;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Repository;import cn.et.day20170606.dao.EmpJaxaDao;import cn.et.day20170606.dao.mapper.EmpMybatiesMapper;import cn.et.day20170606.entity.EmpEntity;@Repositorypublic class EmpJaxaDaoImpl implements EmpJaxaDao{@Autowiredprivate EmpMybatiesMapper empMybatiesMapper;/** *查询数据库的数据方法 * @throws IOException  * @throws IOException  */public List<EmpEntity> queryEmp(String ename){return empMybatiesMapper.queryEmp(ename);}/** *新增数据库的数据方法 * @throws IOException  */public void insertEmp(EmpEntity emp){empMybatiesMapper.insertEmp(emp);}/** *更新数据库的数据方法 * @throws IOException  */public void updateEmp(EmpEntity emp){empMybatiesMapper.updateEmp(emp);}/** * 删除数据库数据的方法 * @throws IOException  * @throws IOException  */public void deleteEmp(String empno){empMybatiesMapper.deleteEmp(empno);}/** *查询数据库的分页数据方法 *注意结束位置再前面   开始位置再后面 * @throws IOException  */public List<EmpEntity> queryPaginEmp(String ename, int start,int end){return empMybatiesMapper.queryPaginEmp(ename, end, start);}/** *查询数据库的总数方法 * @throws IOException  */public int queryTotalEmp(String ename){return empMybatiesMapper.queryTotalEmp(ename);}}

package cn.et.day20170606.dao;import java.io.IOException;import java.util.List;import java.util.Map;import cn.et.day20170606.entity.EmpEntity;public interface EmpJaxaDao {/** *查询数据库的数据方法 */public List<EmpEntity> queryEmp(String ename);/** *查询数据库的分页数据方法 */public List queryPaginEmp(String ename,int start,int end);/** *查询数据库的总数方法 */public int queryTotalEmp(String ename);/** *新增数据库的数据方法 */public void insertEmp(EmpEntity emp);/** *更新数据库的数据方法 */public void updateEmp(EmpEntity emp);/** * 删除数据库数据的方法 */public void deleteEmp(String empno);}

mybatis 的mapper

package cn.et.day20170606.dao.mapper;import java.util.List;import java.util.Map;import org.apache.ibatis.annotations.Delete;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import org.springframework.transaction.annotation.Transactional;import cn.et.day20170606.entity.EmpEntity;@Mapperpublic interface EmpMybatiesMapper {/** *查询数据库的数据方法 */@Select(value="select empno,ename,job,mgr,to_char(hiredate,'yyyy-mm-dd') as hiredate,sal,comm,deptno from emp where nvl(ename,' ') like '%'||#{ename}||'%'")public List<EmpEntity> queryEmp(@Param(value="ename")String ename);/** *查询数据库的分页数据方法 */@Select(value="select * from (select empno,ename,job,mgr,to_char(hiredate,'yyyy-mm-dd') as hiredate,sal,comm,deptno,rownum rn from emp where nvl(ename,' ') like '%'||#{ename}||'%') where rn<=#{start} and rn>=#{end}")public List<EmpEntity> queryPaginEmp(@Param(value="ename")String ename,@Param(value="start")int start,@Param(value="end")int end);/** *查询数据库的总数方法 */@Select("select count(rowid) as CT from emp where nvl(ename,' ') like '%'||#{ename}||'%'")public int queryTotalEmp(@Param(value="ename")String ename);/** *新增数据库的数据方法 */@Insert(value="insert into emp values((select nvl(max(empno),0)+10 from emp),#{emp.ename},#{emp.job},#{emp.mgr},to_date(#{emp.hiredate},'yyyy-mm-dd'),#{emp.sal},#{emp.comm},#{emp.deptno})")public void insertEmp(@Param(value="emp")EmpEntity emp);/** *更新数据库的数据方法 */@Update(value="update emp set ename=#{emp.ename},job=#{emp.job},mgr=#{emp.mgr},hiredate=to_date(#{emp.hiredate},'yyyy-mm-dd'),sal=#{emp.sal},comm=#{emp.comm},deptno=#{emp.deptno} where empno=#{emp.empno}")public void updateEmp(@Param(value="emp")EmpEntity emp);/** * 删除数据库数据的方法 */@Delete(value="delete from emp where empno=#{empno}")public void deleteEmp(@Param(value = "empno") String empno);}

entity

package cn.et.day20170606.entity;/** * 数据库的数据类 （一个对象就是数据库的一行） * @author Administrator * */public class EmpEntity {private String empno;private String ename;private String job;private String mgr;private String hiredate;private String sal;private String comm;private String deptno;public String getEmpno() {return empno;}public void setEmpno(String empno) {this.empno = empno;}public String getEname() {return ename;}public void setEname(String ename) {this.ename = ename;}public String getJob() {return job;}public void setJob(String job) {this.job = job;}public String getMgr() {return mgr;}public void setMgr(String mgr) {this.mgr = mgr;}public String getHiredate() {return hiredate;}public void setHiredate(String hiredate) {this.hiredate = hiredate;}public String getSal() {return sal;}public void setSal(String sal) {this.sal = sal;}public String getComm() {return comm;}public void setComm(String comm) {this.comm = comm;}public String getDeptno() {return deptno;}public void setDeptno(String deptno) {this.deptno = deptno;}}

dataSoure

package cn.et.day20170606.utils;import javax.sql.DataSource;import org.apache.commons.dbcp.BasicDataSource;import org.springframework.boot.context.properties.ConfigurationProperties;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;/** * 相当于标示 该类是一个bean的容器 * @author Administrator *@Configuration 标示这个类用来创建bean的 */@Configurationpublic class BeanContainer {/** * 表示调用该方法产生一个bean * 方法名是bean的id * 用这个数据源覆盖默认的 * @return */@ConfigurationProperties(prefix="mysource")@Beanpublic DataSource dataSource(){BasicDataSource dataSource=new BasicDataSource();return dataSource;}}

入口

package cn.et.day20170606;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.transaction.annotation.EnableTransactionManagement;/** * 自动添加 spring.xml文件 并且配置 自动扫描 * 自动添加web.xml 同时 在web.xml 配置过滤器 拦截器 * @EnableTransactionManagement 表示启动全局事务支持 */@EnableTransactionManagement@SpringBootApplicationpublic class SampleController {    public static void main(String[] args) throws Exception {        SpringApplication.run(SampleController.class, args);    }}

jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><script type="text/javascript">var path="${pageContext.request.contextPath}/day0609";//根据id获取对象function $(id){return document.getElementById(id);}//和div赋值function toUpdate(empno,ename,job,mgr,hiredate,sal,comm,deptno){$('updateDiv').style.display='block';$('empNoId').value=empno;$('updateEname').value=(ename=='null'?'':ename);$('updateJob').value=(job=='null'?'':job);$('updateMgr').value=mgr;$('updateHiredate').value=(hiredate=='null'?'':hiredate);$('updateSal').value=sal;$('updateComm').value=comm;$('updateDeptno').value=deptno;}/**               封装ajax   **/   function sendAjax(method,url,callback,param){   var xmlHttp=new XMLHttpRequest();   //向服务器发出请求//规定请求的类型、URL 以及是否异步处理请求。//method：请求的类型；GET 或 POST//url：文件在服务器上的位置//async：true（异步）或 false（同步）   xmlHttp.open(method,url,true);   //设置响应的回调 当后台的json返回后 自动调用xhr.onreadystatechange指定的函数   xmlHttp.onreadystatechange=function(){                if(xmlHttp.readyState==4 && xmlHttp.status==200){               //成功后调用第三个函数                 callback(xmlHttp.responseText);               }           }           //post 在send里面带参数 get直接带 post一定要设置setRequestHeader           if(method=="POST"){          xmlHttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");           xmlHttp.send(param);           }else{           xmlHttp.send();           }             }//和action交互的方法 用于更新function toUpdate1(){document.getElementById('updateDiv').style.display='none'var empno=$('empNoId').value;var ename=$('updateEname').value;var job=$('updateJob').value;var mgr=$('updateMgr').value;var hiredate=$('updateHiredate').value;var sal=$('updateSal').value;var comm=$('updateComm').value;var deptno=$('updateDeptno').value;//参数var param="ename="+ename+"&job="+job+"&mgr="+mgr+"&hiredate="+hiredate+"&sal="+sal+"&comm="+comm+"&deptno="+deptno+"&empno="+empno//调用ajax好action交互sendAjax("POST",path+"/updateEmp",function(message){if(message==1){alert("操作成功");toQuery(current);}else{alert("操作失败");}},param)}//和action交互的方法 用于新增function toAdd(){document.getElementById('addDiv').style.display='none'var xmlHttp=new XMLHttpRequest();var ename=$('a1').value;var job=$('a2').value;var mgr=$('a3').value;var hiredate=$('a4').value;var sal=$('a5').value;var comm=$('a6').value;var deptno=$('a7').value;var param="ename="+ename+"&job="+job+"&mgr="+mgr+"&hiredate="+hiredate+"&sal="+sal+"&comm="+comm+"&deptno="+deptno;sendAjax("POST",path+"/insertEmp",function(message){if(message==1){alert("操作成功");toQuery(current);}else{alert("操作失败");}},param)}//和action交互的方法 用于删除function toDelete(empno){var param="empno="+empno;sendAjax("POST",path+"/deleteEmp",function(message){if(message==1){alert("操作成功");toQuery(current);}else{alert("操作失败");}},param)}//分页的一些参数var current=1;var sum=0;var trail=0;var last=0;var next=0;////和action交互的方法 用于查询function toQuery(pagin){var xmlHttp=new XMLHttpRequest();var tb=$("tb");var td=$("td");var ename=$("ename").value;xmlHttp.open("GET",path+"/queryPaginEmp?ename="+ename+"&pagin="+pagin,true);xmlHttp.onreadystatechange=function(){if(xmlHttp.readyState==4&&xmlHttp.status==200){//获取action响应的内容var json=xmlHttp.responseText;//把它转成json对象var jsonall=JSON.parse(json);//给分页的一些参数赋值current=jsonall.current;sum=jsonall.sum;trail=jsonall.trail;last=jsonall.last;next=jsonall.next;$("p1").innerHTML=current;$("p2").innerHTML=trail;$("p3").innerHTML=sum;var jsonObj=jsonall.list;//无刷新在此查询的时候把整个tbody删除tb.removeChild(td);var tdRow=document.createElement("tbody");tdRow.setAttribute("id","td");//把tbody加到table里面去tb.appendChild(tdRow);for ( var i = 0; i < jsonObj.length; i++) {var el = jsonObj[i];//创建节点var trRow=document.createElement("tr");var tdRow1=document.createElement("td");var tdRow2=document.createElement("td");var tdRow3=document.createElement("td");var tdRow4=document.createElement("td");var tdRow5=document.createElement("td");var tdRow6=document.createElement("td");var tdRow7=document.createElement("td");var tdRow8=document.createElement("td");var tdRow9=document.createElement("td");tdRow1.innerHTML=el.empno;tdRow2.innerHTML=el.ename;tdRow3.innerText=el.job;tdRow4.innerText=el.mgr;tdRow5.innerHTML=el.hiredate;tdRow6.innerHTML=el.sal;tdRow7.innerHTML=el.comm;tdRow8.innerHTML=el.deptno;tdRow9.innerHTML="<button onclick='toDelete("+el.empno+")'>删除</button><button onclick=toUpdate("+el.empno+",'"+el.ename+"','"+el.job+"',"+el.mgr+",'"+el.hiredate+"',"+el.sal+","+el.comm+","+el.deptno+")>更新</button>";//把节点tdRow1加到trRowtrRow.appendChild(tdRow1);trRow.appendChild(tdRow2);trRow.appendChild(tdRow3);trRow.appendChild(tdRow4);trRow.appendChild(tdRow5);trRow.appendChild(tdRow6);trRow.appendChild(tdRow7);trRow.appendChild(tdRow8);trRow.appendChild(tdRow9);tdRow.appendChild(trRow);}}}xmlHttp.send();}</script></head><body onload="toQuery(1)"><!-- http://localhost:8080/day20170609/emp.jsp -->ename<input type="text" name="ename" id="ename"/><input type="button" value="查询" onclick="toQuery(current)"/><input type="button" value="新增" onclick="document.getElementById('addDiv').style.display='block'"/><br/><table id="tb"><thead><tr><td>empno</td><td>ename</td><td>job</td><td>mgr</td><td>hiredate</td><td>sal</td><td>comm</td><td>deptno</td> <td>操作</td></tr></thead ><tbody id="td"></tbody></table><input type="image" src="${pageContext.request.contextPath}/day20170609/image/18.gif" onclick="toQuery(1)"/>    <input type="image" src="${pageContext.request.contextPath}/day20170609/image/20.gif" onclick="toQuery(last)"/>      当前<span id="p1"></span>页  总<span id="p2"></span>页  总:<span id="p3"></span>    <input type="image" src="${pageContext.request.contextPath}/day20170609/image/16.gif" onclick="toQuery(next)"/>    <input type="image" src="${pageContext.request.contextPath}/day20170609/image/14.gif" onclick="toQuery(trail)"/><!-- 新增的div--><div id="addDiv" style="display:none;position: absolute;left: 65%;top: 14%;width: 300px;height:200px;background:linear-gradient(to bottom,skyblue,gray);border: 1px solid black;">ENAME:<input type='text' name='ename' id='a1'><br/>JOB:<input type='text' name='job' id='a2'><br/>MGR:<input type='text' name='mgr' id='a3'><br/>HIREDATE:<input type='text' name='hiredate' id='a4'><br/>SAL:<input type='text' name='sal' id='a5'><br/>COMM:<input type='text' name='comm' id='a6'><br/>DEPTNO:<input type='text' name='deptno' id='a7'><br/><input type='button' value="新增"  onclick="toAdd()"><input type='button' value="关闭" onclick="document.getElementById('addDiv').style.display='none'"></div><!-- 修改的div--><div id="updateDiv" style="display:none;position: absolute;left: 65%;top: 14%;width: 300px;height:200px;background:linear-gradient(to bottom,skyblue,gray);border: 1px solid black;"><input type='hidden' name='empno' id='empNoId'>ENAME: <input type='text' id="updateEname"  name='ename'><br/>JOB: <input type='text' id="updateJob"  name='job'><br/>MGR: <input type='text' id="updateMgr"  name='mgr'><br/>HIREDATE: <input type='text' id="updateHiredate"  name='hiredate'><br/>SAL: <input type='text' id="updateSal"  name='sal'><br/>COMM: <input type='text' id="updateComm"  name='comm'><br/>DEPTNO: <input type='text' id="updateDeptno"  name='deptno'><br/><input type='button' value='修改' onclick="toUpdate1()"><input type='button' value="关闭" onclick="document.getElementById('updateDiv').style.display='none'"></div></body></html>