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;
@Controller
public class AjaxAction {
@Autowired
private 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;
}
}
cn.et.emp.entity
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;
@Controller
public class AjaxAction {
@Autowired
private 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;
}
}
cn.et.emp.mapper
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;
@Controller
public class AjaxAction {
@Autowired
private 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
*
*/
@Service
public class EmpServiceImpl implements EmpService {
//自动装配
@Autowired
private 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 stub
return 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\:orcl
driverClass=oracle.jdbc.OracleDriver
account=scott
password=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=true
log4j.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%n
spring.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.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
http://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>
springmvc.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>