spring+springmvc+myBatis+jquery+ajax+jackson的增删改查
来源：互联网 发布：刷钻软件 编辑：程序博客网 时间：2024/05/16 16:11
src
cn.et.emp
cn.et.emp.controller
AjaxAction
package cn.et.emp.controller;import java.io.IOException;import java.io.OutputStream;import java.io.UnsupportedEncodingException;import net.sf.json.JSONObject;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import cn.et.emp.entity.Emp;import cn.et.emp.service.EmpService;import cn.et.emp.utils.PageEntity;@Controllerpublic class AjaxAction {@Autowiredprivate EmpService service;/** * ajax请求跳转是没有用的，所以返回字节数组 * 表示将json转换为字节输出给响应流 * * @ResponseBody 这里修改了返回值，所以必须要加上这句代码 * 这里没有返回值，使用分页 * @return * @throws IOException */@RequestMapping(value="/ajaxQuery")public void ajaxQuery(String ename, String curPage, OutputStream os) throws IOException{int intCurPage = Integer.parseInt(curPage);PageEntity pe = service.query(ename,intCurPage);//将数组、对象或者集合转换成字符串的json 再传给xhr对象//把list集合转换成json字符串String json = JSONObject.fromObject(pe).toString();os.write(json.getBytes("UTF-8"));}@RequestMapping("json")public void action(String ename,OutputStream os) throws UnsupportedEncodingException, IOException{os.write("SMITH".toString().getBytes("UTF-8"));}/** * 新增 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @param ename * @param sal * @param os * @throws IOException */@RequestMapping(value="/ajaxAdd")public void ajaxAdd(String ename,String sal,OutputStream os) throws IOException{try {service.add(ename, sal);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 删除 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @throws IOException */@RequestMapping(value="/ajaxDelete")public void ajaxDelete(String eno,OutputStream os) throws IOException{try {service.delete(eno);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 修改 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @throws IOException */@RequestMapping(value="/ajaxUpdate")public void ajaxUpdate(Emp emp,OutputStream os) throws IOException{try {service.update(emp);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 需要配置org.springframework.http.converter.json.MappingJackson2HttpMessageConverter * 才可以直接返回其它对象 * @param ename * @param curPage * @return * @throws IOException */@ResponseBody@RequestMapping(value="/ajaxQuery2")public PageEntity ajaxQuery(String ename, String curPage) throws IOException{int intCurPage = Integer.parseInt(curPage);PageEntity pe = service.query(ename,intCurPage);//将数组、对象或者集合转换成字符串的json 再传给xhr对象//把list集合转换成json字符串return pe;}}Emp
package cn.et.emp.controller;import java.io.IOException;import java.io.OutputStream;import java.io.UnsupportedEncodingException;import net.sf.json.JSONObject;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import cn.et.emp.entity.Emp;import cn.et.emp.service.EmpService;import cn.et.emp.utils.PageEntity;@Controllerpublic class AjaxAction {@Autowiredprivate EmpService service;/** * ajax请求跳转是没有用的，所以返回字节数组 * 表示将json转换为字节输出给响应流 * * @ResponseBody 这里修改了返回值，所以必须要加上这句代码 * 这里没有返回值，使用分页 * @return * @throws IOException */@RequestMapping(value="/ajaxQuery")public void ajaxQuery(String ename, String curPage, OutputStream os) throws IOException{int intCurPage = Integer.parseInt(curPage);PageEntity pe = service.query(ename,intCurPage);//将数组、对象或者集合转换成字符串的json 再传给xhr对象//把list集合转换成json字符串String json = JSONObject.fromObject(pe).toString();os.write(json.getBytes("UTF-8"));}@RequestMapping("json")public void action(String ename,OutputStream os) throws UnsupportedEncodingException, IOException{os.write("SMITH".toString().getBytes("UTF-8"));}/** * 新增 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @param ename * @param sal * @param os * @throws IOException */@RequestMapping(value="/ajaxAdd")public void ajaxAdd(String ename,String sal,OutputStream os) throws IOException{try {service.add(ename, sal);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 删除 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @throws IOException */@RequestMapping(value="/ajaxDelete")public void ajaxDelete(String eno,OutputStream os) throws IOException{try {service.delete(eno);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 修改 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @throws IOException */@RequestMapping(value="/ajaxUpdate")public void ajaxUpdate(Emp emp,OutputStream os) throws IOException{try {service.update(emp);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 需要配置org.springframework.http.converter.json.MappingJackson2HttpMessageConverter * 才可以直接返回其它对象 * @param ename * @param curPage * @return * @throws IOException */@ResponseBody@RequestMapping(value="/ajaxQuery2")public PageEntity ajaxQuery(String ename, String curPage) throws IOException{int intCurPage = Integer.parseInt(curPage);PageEntity pe = service.query(ename,intCurPage);//将数组、对象或者集合转换成字符串的json 再传给xhr对象//把list集合转换成json字符串return pe;}}EmpMapper
package cn.et.emp.controller;import java.io.IOException;import java.io.OutputStream;import java.io.UnsupportedEncodingException;import net.sf.json.JSONObject;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import cn.et.emp.entity.Emp;import cn.et.emp.service.EmpService;import cn.et.emp.utils.PageEntity;@Controllerpublic class AjaxAction {@Autowiredprivate EmpService service;/** * ajax请求跳转是没有用的，所以返回字节数组 * 表示将json转换为字节输出给响应流 * * @ResponseBody 这里修改了返回值，所以必须要加上这句代码 * 这里没有返回值，使用分页 * @return * @throws IOException */@RequestMapping(value="/ajaxQuery")public void ajaxQuery(String ename, String curPage, OutputStream os) throws IOException{int intCurPage = Integer.parseInt(curPage);PageEntity pe = service.query(ename,intCurPage);//将数组、对象或者集合转换成字符串的json 再传给xhr对象//把list集合转换成json字符串String json = JSONObject.fromObject(pe).toString();os.write(json.getBytes("UTF-8"));}@RequestMapping("json")public void action(String ename,OutputStream os) throws UnsupportedEncodingException, IOException{os.write("SMITH".toString().getBytes("UTF-8"));}/** * 新增 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @param ename * @param sal * @param os * @throws IOException */@RequestMapping(value="/ajaxAdd")public void ajaxAdd(String ename,String sal,OutputStream os) throws IOException{try {service.add(ename, sal);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 删除 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @throws IOException */@RequestMapping(value="/ajaxDelete")public void ajaxDelete(String eno,OutputStream os) throws IOException{try {service.delete(eno);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 修改 * 如果返回值为void,那么形参必须配上OutputStream os不然会报错的 * @throws IOException */@RequestMapping(value="/ajaxUpdate")public void ajaxUpdate(Emp emp,OutputStream os) throws IOException{try {service.update(emp);os.write("1".getBytes("UTF-8"));} catch (Exception e) {os.write("0".getBytes("UTF-8"));}}/** * 需要配置org.springframework.http.converter.json.MappingJackson2HttpMessageConverter * 才可以直接返回其它对象 * @param ename * @param curPage * @return * @throws IOException */@ResponseBody@RequestMapping(value="/ajaxQuery2")public PageEntity ajaxQuery(String ename, String curPage) throws IOException{int intCurPage = Integer.parseInt(curPage);PageEntity pe = service.query(ename,intCurPage);//将数组、对象或者集合转换成字符串的json 再传给xhr对象//把list集合转换成json字符串return pe;}}EmpMapper.xml
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!-- 接口映射namespace必需跟接口的全名一致 --><mapper namespace="cn.et.emp.mapper.EmpMapper"><!-- select的id必须和接口的方法名一致resultType和接口返回值的泛型一致没有返回值就不写#{}语法格式是(实际上是使用jdbc的?点位符传参是安全的 )第一种#{0}第二种#{param1}第三种指定别名#{}${}是字符串拼接，拼接字符串的话要添加'' 是不安全的查询总一共有多少符合条件的数据 --><select id="queryCount" resultType="java.util.Map">select count(rowid) as TC from emp2 where ename like #{ename}</select><!-- 通过用户名查询 --><select id="query" resultType="java.util.Map">select * from emp2 where ename like #{ename} order by eno desc</select><!-- 查询当前页的数据 --><select id="queryPage" resultType="java.util.Map">select * from (select e.*,rownum rn from (select * from emp2 where ename like #{ename} order by eno desc) e) where rn between #{start} and #{end} order by eno desc</select><!-- 新增 --><insert id="add">insert into emp2 values((select nvl(max(eno),0)+1 from emp2),#{ename},#{sal})</insert><!-- 删除 --><delete id="delete">delete from emp2 where eno=#{eno}</delete><!-- 修改 --><update id="update">update emp2 set ename=#{ename},sal=#{sal} where eno=#{eno}</update></mapper>cn.et.emp.service
EmpService
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!-- 接口映射namespace必需跟接口的全名一致 --><mapper namespace="cn.et.emp.mapper.EmpMapper"><!-- select的id必须和接口的方法名一致resultType和接口返回值的泛型一致没有返回值就不写#{}语法格式是(实际上是使用jdbc的?点位符传参是安全的 )第一种#{0}第二种#{param1}第三种指定别名#{}${}是字符串拼接，拼接字符串的话要添加'' 是不安全的查询总一共有多少符合条件的数据 --><select id="queryCount" resultType="java.util.Map">select count(rowid) as TC from emp2 where ename like #{ename}</select><!-- 通过用户名查询 --><select id="query" resultType="java.util.Map">select * from emp2 where ename like #{ename} order by eno desc</select><!-- 查询当前页的数据 --><select id="queryPage" resultType="java.util.Map">select * from (select e.*,rownum rn from (select * from emp2 where ename like #{ename} order by eno desc) e) where rn between #{start} and #{end} order by eno desc</select><!-- 新增 --><insert id="add">insert into emp2 values((select nvl(max(eno),0)+1 from emp2),#{ename},#{sal})</insert><!-- 删除 --><delete id="delete">delete from emp2 where eno=#{eno}</delete><!-- 修改 --><update id="update">update emp2 set ename=#{ename},sal=#{sal} where eno=#{eno}</update></mapper>cn.et.emp.service.impl
EmpServiceImpl
package cn.et.emp.service.impl;import java.math.BigDecimal;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import cn.et.emp.entity.Emp;import cn.et.emp.mapper.EmpMapper;import cn.et.emp.service.EmpService;import cn.et.emp.utils.PageEntity;import cn.et.emp.utils.PageUtils;/** * 服务层掉用dao层的方法 * @author Administrator * */@Servicepublic class EmpServiceImpl implements EmpService {//自动装配@Autowiredprivate EmpMapper mapper;/* 查询 * @see cn.et.emp.dao.impl.EmpDao#query(java.lang.String) */public PageEntity query(String ename,int curPage){if(ename==null){ename="";}//获取到总条数Map map = mapper.queryCount("%"+ename+"%");String total = map.get("TC").toString();int intTotal = Integer.parseInt(total);//再创建PageEntity实体类把当前页，每页显示多少条数据和总共多少条数据传进去PageEntity pe = PageUtils.calc(curPage, 10, intTotal);List list = mapper.queryPage("%"+ename+"%", pe.getStartIndex(), pe.getEndIndex());pe.setData(list);return pe;}/* 新增 * @see cn.et.emp.mapper.impl.EmpDao#add(java.lang.String, java.lang.String) */public void add(String ename,String sal){if(ename==null){ename="";}mapper.add(ename, sal);}/* 删除 * @see cn.et.emp.mapper.impl.EmpDao#delete(java.lang.String) */public void delete(String eno){mapper.delete(eno);}/* 修改 * @see cn.et.emp.mapper.impl.EmpDao#update(en.et.emp.entity.Emp) */public void update(Emp emp){mapper.update(emp.getEno(),emp.getEname(),emp.getSal());}public PageEntity query(String ename) {// TODO Auto-generated method stubreturn null;}}cn.et.emp.utils
PageEntity
package cn.et.emp.utils;import java.util.List;public class PageEntity {/** * 数据库查询的总条数 */private int totalSize;/** * 每页显示的条数 */private int pageSize=10;/** * 总页数 * * totalSize=20 pageSize=10 * 最后公式：pageCount=(totalSize%pageSize==0?totalSize/pageSize:(totalSize/pageSize+1)) */private int pageCount;/** * 当前页 */private int curPage;/** * 上一页 * prevPage=curPage==1?curPage:curPage-1 */private int prevPage;/** * 下一页 * 最后公式：nextPage=curPage<pageCount?curPage+1:curPage; */private int nextPage;/** * * startIndex=(curPage-1)*pageSize+1 * endIndex=curPage*pageSize */private int startIndex;private int endIndex;private List data;private String queryName;public String getQueryName() {return queryName;}public void setQueryName(String queryName) {this.queryName = queryName;}public int getTotalSize() {return totalSize;}public void setTotalSize(int totalSize) {this.totalSize = totalSize;}public int getPageSize() {return pageSize;}public void setPageSize(int pageSize) {this.pageSize = pageSize;}public int getPageCount() {return pageCount;}public void setPageCount(int pageCount) {this.pageCount = pageCount;}public int getCurPage() {return curPage;}public void setCurPage(int curPage) {this.curPage = curPage;}public int getPrevPage() {return prevPage;}public void setPrevPage(int prevPage) {this.prevPage = prevPage;}public int getNextPage() {return nextPage;}public void setNextPage(int nextPage) {this.nextPage = nextPage;}public int getStartIndex() {return startIndex;}public void setStartIndex(int startIndex) {this.startIndex = startIndex;}public int getEndIndex() {return endIndex;}public void setEndIndex(int endIndex) {this.endIndex = endIndex;}public List getData() {return data;}public void setData(List data) {this.data = data;}}PageUtils
package cn.et.emp.utils;public class PageUtils {/** * 计算上一页、下一页等... * @param curPage当前页 * @param pageSize每页显示的条数 * @param totalSize数据库查询的总条数 * @return */ public static PageEntity calc(int curPage, int pageSize, int totalSize){ PageEntity pe = new PageEntity(); pe.setCurPage(curPage); pe.setPageSize(pageSize); pe.setTotalSize(totalSize); int pageCount=(totalSize%pageSize==0?totalSize/pageSize:(totalSize/pageSize+1)); int prevPage=curPage==1?curPage:curPage-1; int nextPage=curPage<pageCount?curPage+1:curPage; int startIndex=(curPage-1)*pageSize+1; int endIndex=curPage*pageSize; pe.setPageCount(pageCount); pe.setPrevPage(prevPage); pe.setNextPage(nextPage); pe.setStartIndex(startIndex); pe.setEndIndex(endIndex); return pe; }}jdbc.properties
url=jdbc\:oracle\:thin\:@localhost\:1521\:orcldriverClass=oracle.jdbc.OracleDriveraccount=scottpassword=tiger
log4j.properties
log4j.rootLogger=debug, ServerDailyRollingFile, stdout log4j.appender.ServerDailyRollingFile=org.apache.log4j.DailyRollingFileAppender log4j.appender.ServerDailyRollingFile.DatePattern='.'yyyy-MM-dd log4j.appender.ServerDailyRollingFile.File=C\://logs/notify-subscription.log log4j.appender.ServerDailyRollingFile.layout=org.apache.log4j.PatternLayout log4j.appender.ServerDailyRollingFile.layout.ConversionPattern=%d - %m%n log4j.appender.ServerDailyRollingFile.Append=truelog4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss} %p [%c] %m%nspring.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"xmlns:mvc="http://www.springframework.org/schema/mvc"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsdhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd"><!-- springmvc的配置只能扫描控制层 spring配置文件不能扫描控制层 --><context:component-scan base-package="cn.et"><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><!-- 读取jdbc.properties文件 --><context:property-placeholder location="classpath:/cn/et/emp/utils/jdbc.properties" /><!-- 数据库连接池 --><bean id="dataSource"class="org.apache.commons.dbcp.BasicDataSource"><property name="url" value="${url}"></property><property name="driverClassName" value="${driverClass}"></property><property name="username" value="${account}"></property><property name="password" value="${password}"></property><!-- initialSize 10默认生成10个连接，那么要用到连接的时候就直接拿一条出来用就可以了，就不用等到用的时候再去产生连接 --><property name="initialSize" value="10"></property><!-- 发起一条测试的sql语句去连接一下数据库，看是否可以正常连接数据库 --></bean><!-- 创建一个jdbc模板SqlSessionFactoryBean --><bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"></property></bean><!-- 这里一定要用sqlSessionFactoryBeanName，不然加载不了driverClass --><!-- 扫描接口映射和注解和xml文件 --><bean id="scanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sessionFactory"></property><!-- 如果映射的是Mapper接口直接放到mapper包里面扫描就发好了如果映射的是xml配置文件需要把配置文件名改成对应的接口一样的名称，并都要放到mapper包下 --><property name="basePackage" value="cn.*..*.mapper"></property></bean><!-- 事务管理器 spring帮助我们控制事务 --><bean id="transManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"></property></bean><!-- aspectjweaver 事务架包 --><!-- 当切点拦截到某个操作的方法 发送通知给tx定义的通知管理 调用事务管理器 提交和回滚 --><tx:advice id="myAdvice" transaction-manager="transManager"><tx:attributes><!-- 默认的配置 --><tx:method name="add*" propagation="REQUIRED" /><tx:method name="query*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><!-- *代表了除了上面配置的方法都不使用事务 --><tx:method name="*" read-only="true" /></tx:attributes></tx:advice><!-- 切面 --><aop:config><aop:pointcut id="myPointCut" expression="execution(* cn.*..*.service.EmpService.*(..))" /><aop:advisor advice-ref="myAdvice" pointcut-ref="myPointCut" /></aop:config></beans>form.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <script type="text/javascript" src="jquery-2.2.4.js"></script><script type="text/javascript">//当前页var curPage=0;//上一页var prevPage=0;//下一页var nextPage=0;//总页数var pageCount=0;//总条数var totalSize=0;//查询方法function query(curP){var ename=$("#qename").val();//声明一个XMLHttpRequest变量并用兼容性的方法创建对象$.ajax({url:"${pageContext.request.contextPath}/ajaxQuery",//表示请求的路径dataType:"json",// 表示响应的数据类型 json的方式传参data:{ename:ename,curPage:curP},//ajax的传参success:function(pe){//读取pe里的页信息curPage=pe.curPage;prevPage=pe.prevPage;nextPage=pe.nextPage;pageCount=pe.pageCount;totalSize=pe.totalSize;$("#curPage").text(curPage);$("#pageCount").text(pageCount);$("#totalSize").text(totalSize);//获取到list集合var oJson = pe.data;//首先获取取table的dom对象$("tr[mark='delete']").remove();for(var i=0; i<oJson.length; i++){$("#tbody").append("<tr mark='delete'><td>"+oJson[i].ENO+"</td><td>"+oJson[i].ENAME+"</td><td>"+oJson[i].SAL+"</td><td><button onclick=openUpdate("+oJson[i].ENO+",'"+oJson[i].ENAME+"',"+oJson[i].SAL+")>修改</button><button onclick='del("+oJson[i].ENO+")'>删除</button></td>");}},/*异常的处理*/error:function(XMLHttpRequest, textStatus, errorThrown){alert("调用服务器失败--"+XMLHttpRequest.status+"--"+errorThrown);}});}//新增方法function add(){var url="${pageContext.request.contextPath}/ajaxAdd";var param=$("#AddDivForm").serialize();ajaxSend(url,param,function(text){if(text==1){//alert("新增成功");$("#AddDivForm").find("input").val("");$("#addDiv").hide();query(curPage);}else{alert("新增失败");}});}//删除方法function del(eno){var url="${pageContext.request.contextPath}/ajaxDelete";var param="eno="+eno;ajaxSend(url,param,function(text){if(text==1){//alert("删除成功");query(curPage);}else{alert("删除失败");}});}//打开修改DIV function openUpdate(eno, ename, sal){ $('#updateDiv').show(); $('#upate_eno').val(eno); $('#upate_ename').val(ename); $('#upate_sal').val(sal); } //修改方法function toUpdate(){var url="${pageContext.request.contextPath}/ajaxUpdate";var param=$("#updateDivForm").serialize();ajaxSend(url,param,function(text){if(text==1){//alert("修改成功"); $('#updateDiv').hide(); $("#updateDivForm").find("input").val("");query(curPage);}else{alert("修改失败");}});}//ajax请求function ajaxSend(url,param,callback){$.ajax({url:url+"?",//表示请求的路径data:param,dataType:"json",// 表示响应的数据类型 json的方式传参success:callback,/*异常的处理*/error:function(XMLHttpRequest, textStatus, errorThrown){alert("调用服务器失败--"+XMLHttpRequest.status+"--"+errorThrown);}});}</script> </head> <body onload="query(1)"><form><input type="text" id="qename" /><input type="button" value="查询" onclick="query(curPage)" /><input type='button' value='新增' onclick='$("#addDiv").show()'> </form><table border="1" cellpadding="10" cellspacing="0"><thead><tr><td>编号</td><td>姓名</td><td>薪水</td><td>操作</td></tr></thead><tbody id="tbody"></tbody></table><input type="image" src="${pageContext.request.contextPath}/task/image/1.gif" onclick="query(1)"/> <input type="image" src="${pageContext.request.contextPath}/task/image/2.gif" onclick="query(prevPage)"/> 当前<span id="curPage"></span>页 共<span id="pageCount"></span>页 共<span id="totalSize"></span>条 <input type="image" src="${pageContext.request.contextPath}/task/image/3.gif" onclick="query(nextPage)"/> <input type="image" src="${pageContext.request.contextPath}/task/image/4.gif" onclick="query(pageCount)"/> <!-- 修改的div --> <div id="updateDiv" style="display:none;position: absolute;left: 35%;top: 40%;width: 300px;height:100px;background:linear-gradient(to bottom,skyblue,gray);border: 1px solid black;"> <form id="updateDivForm"> <input id="upate_eno" type='hidden' /> ENAME: <input id="upate_ename" name="name" type='text'><Br/> SAL: <input id="upate_sal" name="sal" type='text' name='sal'><Br/> </form> <input type='button' value='保存' onclick=toUpdate() /> <input type='button' value="关闭" onclick="document.getElementById('updateDiv').style.display='none'" /> </div> <!-- 新增的div --> <div id="addDiv" style="display:none;position: absolute;left: 35%;top: 40%;width: 300px;height:100px;background:linear-gradient(to bottom,skyblue,gray);border: 1px solid black;"> <form id="AddDivForm"> ENAME:<input type='text' id='addEname' name="ename"><br/> SAL: <input type='text' id='addSal' name="sal"><br/> </form> <button onclick="add()">增加</button> <input type='button' value="关闭" onclick="document.getElementById('addDiv').style.display='none'"></div> </body> <script type="text/javascript"> </script></html>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"> <modelVersion>4.0.0</modelVersion> <groupId>MybatisLesson</groupId> <artifactId>MybatisLesson</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>war</packaging> <name/> <description/> <dependencies> <dependency> <groupId>org.apache.openejb</groupId> <artifactId>javaee-api</artifactId> <version>5.0-1</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.faces</groupId> <artifactId>jsf-api</artifactId> <version>1.2_04</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.1</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.faces</groupId> <artifactId>jsf-impl</artifactId> <version>1.2_04</version> <scope>provided</scope> </dependency> <!-- 自动加载mybatis架包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.8</version></dependency><!-- 加载本地ojdbc6.jar前面三个可以乱填，最好是配上，不然可能会报错scope 系统scope路径 --><dependency> <groupId>oracle</groupId> <artifactId>orcale</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><!-- 加载log4j日志 --><dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version></dependency><dependency> <groupId>cglib</groupId> <artifactId>cglib</artifactId> <version>3.2.4</version></dependency><dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.3.3</version></dependency><dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.3</version></dependency> <!-- 加载springmvc架包 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.3.2.RELEASE</version></dependency><dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>4.3.2.RELEASE</version></dependency><dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.3.2.RELEASE</version></dependency><!-- mybatis集成spring的核心包 --><dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.3</version></dependency><!-- 新数据库连接池架包dbcp --><dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version></dependency><!-- aspectjweaver 事务架包 --><dependency> <groupId>org.aspectj</groupId> <artifactId>com.springsource.org.aspectj.weaver</artifactId> <version>1.6.8.RELEASE</version></dependency><!-- jackson架包 --><dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-annotations</artifactId> <version>2.6.0</version></dependency><dependency> <groupId>org.codehaus.jackson</groupId> <artifactId>jackson-mapper-asl</artifactId> <version>1.9.12</version></dependency> <!-- 加载json架包 --> <dependency> <groupId>net.sf.json-lib</groupId> <artifactId>json-lib</artifactId> <version>2.4</version> <classifier>jdk15</classifier></dependency><dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-core</artifactId> <version>2.6.0</version></dependency><dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.6.0</version></dependency> </dependencies> <build> <sourceDirectory>${basedir}/src</sourceDirectory> <outputDirectory>${basedir}/WebRoot/WEB-INF/classes</outputDirectory> <resources> <resource> <directory>${basedir}/src</directory> <excludes> <exclude>**/*.java</exclude> </excludes> </resource> </resources> <plugins> <plugin> <artifactId>maven-war-plugin</artifactId> <configuration> <webappDirectory>${basedir}/WebRoot</webappDirectory> <warSourceDirectory>${basedir}/WebRoot</warSourceDirectory> </configuration> </plugin> <plugin> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.5</source> <target>1.5</target> </configuration> </plugin> </plugins> </build></project>web.xml
<?xml version="1.0" encoding="UTF-8"?><web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"><!-- 加载spring.xml配置文件 --><!-- spring 要使用springmvc的标签和国际化必须加载spring--><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:/spring.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!-- 设置一个字符集的过滤器，这个过滤器要在其它过滤器之前过滤，不然其它过滤器先拦截同样会出现中文乱码问题 --><filter><filter-name>utf</filter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class><init-param><param-name>encoding</param-name><param-value>UTF-8</param-value></init-param></filter><filter-mapping><filter-name>utf</filter-name><url-pattern>/*</url-pattern></filter-mapping> <filter> <filter-name>myencode</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <!-- servlet一般是不支持delete和put 所以要配置一个过滤器 这个项目没有用请求限定--> <filter> <filter-name>hidden</filter-name> <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class> </filter> <filter-mapping> <filter-name>hidden</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 配置action --> <servlet> <servlet-name>spring</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet </servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/springmvc.xml</param-value> </init-param> <load-on-startup>0</load-on-startup> </servlet> <servlet-mapping> <servlet-name>spring</servlet-name> <url-pattern>*.action</url-pattern> <url-pattern>/</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <system.web.extensions> <scripting> <webServices> <jsonSerialization maxJsonLength="#####"/> </webServices> </scripting> </system.web.extensions> </web-app>
springmvc.xml
<?xml version="1.0" encoding="UTF-8"?><beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:mvc="http://www.springframework.org/schema/mvc"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsdhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd"><!-- springmvc的配置只能扫描控制层 spring配置文件不能扫描控制层 --><context:component-scan base-package="cn.et"><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"/><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Repository"/></context:component-scan><mvc:default-servlet-handler></mvc:default-servlet-handler><mvc:annotation-driven><!-- 配置消息转换器 --><mvc:message-converters><!-- 设置json转换消息转换器，并且设置supportedMediaTypes 否则抛出406 --><bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"><property name="supportedMediaTypes"><list><!-- 设置响应支持的类型 --><value>text/html;charset=UTF-8</value><!-- 设置请求body支持的类型 --><value>application/x-www-form-urlencoded</value><value>application/json;charset=UTF-8</value></list></property></bean></mvc:message-converters></mvc:annotation-driven></beans>
阅读全文
0 0
- spring+springmvc+myBatis+jquery+ajax+jackson的增删改查
- spring+springmvc+myBatis+jquery+ajax+json的增删改查
- Springmvc+Spring+Mybatis+Maven简单的增删改查
- SpringMVC+Mybatis整合的增删改查
- SpringMVC+Mybatis整合的增删改查
- springMvc+AJAX+JSON的增删改查
- BootStrap+SpringMVC+Spring+MyBatis增删改查功能
- 原 Spring + SpringMVC + Mybatis 整合，实现 CRUD (增删改查)
- spring,springmvc,mybatis集成实例--增删查改
- mybatis-springmvc+mybatis实现增删改查
- 用户增删改查：在eclipse创建Spring+SpringMVC+Mybatis的项目
- springmvc+mybatis+maven+junit实现网页的增删查改
- SpringMVC+Mybatis架构下的增删查改
- springmvc-mybatis的增删改查以及主键返回
- SpringMVC之AJAX带分页的增删改查
- springmvc mybatis 增删改查示例
- mybatis的增删查改
- mybatis的增删查改
- Spring初始化
- 【easyui】动态显示datagrid列
- 文章标题
- 怎样在 Mac 上打开Library 文件夹
- tensorflow-rnn代码解读
- spring+springmvc+myBatis+jquery+ajax+jackson的增删改查
- Android线程管理（二）——ActivityThread（转载）
- 在开发中hosts的作用
- linux上安装Docker(非常简单的安装方法)
- 1 SOLR1：solr4.10.1 tomcat6 jdk8部署
- 技术人员的职业选择
- 粒子群优化算法研究
- try catch finally 的执行
- 多条件分页，增加，修改，删除（包含文件上传，下载）（图书管理系统）
