app_base.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xmlns="http://www.springframework.org/schema/beans"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd">
<!-- 创建数据源 -->
<bean id="data" class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/j122?characterEncoding=utf-8&allowMultiQueries=true&useSSL=false"></property>
<property name="username" value="root"></property>
<property name="password" value="99233"></property>
<property name="maxTotal" value="100"></property>
<property name="maxIdle" value="20"></property>
<property name="maxWaitMillis" value="2000"></property>
</bean>
<!-- 创建会话工厂 -->
<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="data"></property>
<property name="configLocation" value="classpath:mybatis.cfg.xml"></property>
<property name="mapperLocations">
<list>
<value>classpath:orm/*.xml</value>
</list>
</property>
</bean>
<!-- 配置会话 -->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate" scope="prototype">
<constructor-arg ref="sessionFactory"></constructor-arg>
</bean>
<!-- 配置事务管理器 -->
<bean id="trans" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="data"></property>
</bean>
<!-- 允许使用注解配置事务 -->
<tx:annotation-driven transaction-manager="trans"/>
<!-- 扫描指定包中的spring注解类 -->
<context:component-scan base-package="com.lovo.service"></context:component-scan>
</beans>
app_mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xmlns="http://www.springframework.org/schema/beans"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd">
<mvc:annotation-driven></mvc:annotation-driven>
<!-- 静态资源交给默认处理器处理 -->
<mvc:default-servlet-handler/>
<context:component-scan base-package="com.lovo.action"></context:component-scan>
</beans>
mybatis.cfg.xml同ssm
orm同sam
web.xml同ssm
action
package com.lovo.action;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.codehaus.jackson.map.ObjectMapper;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import com.lovo.bean.CutPageBean;
import com.lovo.bean.MessageBean;
import com.lovo.service.IMessageService;
@Controller
@RequestMapping("/message")
public class MessageAction {
@Resource
private IMessageService service;
//method=RequestMethod.GET 表示该方法只支持GET请求
@RequestMapping(value="/findByItem",method=RequestMethod.GET)
public void findByItem(int pageNum,String userName,String tel,HttpServletResponse response)throws Exception{
CutPageBean<MessageBean> cutPageBean = service.findByItem(pageNum, userName, tel);
ObjectMapper mapper = new ObjectMapper();
mapper.writeValue(response.getWriter(), cutPageBean);
}
@RequestMapping(value="/add",method=RequestMethod.POST)
public void add(MessageBean bean,HttpServletResponse response) throws Exception{
service.add(bean);
response.getWriter().print("添加成功");
}
@RequestMapping(value="/del/{id}",method=RequestMethod.DELETE)
public void del(@PathVariable("id") int id,HttpServletResponse response)throws Exception{
service.del(id);
response.getWriter().print("删除成功");
}
@RequestMapping(value="/findById",method=RequestMethod.GET)
public void findById(int id, HttpServletResponse response)throws Exception {
MessageBean bean = service.findById(id);
ObjectMapper mapper = new ObjectMapper();
mapper.writeValue(response.getWriter(), bean);
}
@RequestMapping(value="/update/{id}",method=RequestMethod.PUT)
public void update(@PathVariable("id") int id,String tel,HttpServletResponse response)throws Exception{
service.update(id, tel);
response.getWriter().print("修改成功");
}
}
html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript" src="/rest/js/jquery-1.12.1.js"></script>
<script type="text/javascript">
$(function () {
ajax(1);
});
function ajax(pageNum) {
$.get("/rest/message/findByItem","pageNum="+pageNum+"&"+$("#f1").serialize(),function(dataObj){
//alert(JSON.stringify(dataObj));
var str = "";
for(var i=0;i<dataObj.list.length;i++){
var obj = dataObj.list[i];
str += "<tr><td>"+obj.userName+
"</td><td>"+obj.tel+"</td><td>"+
" <a href='javascript:del("+obj.id+")'>删除</a>"+
" <a href='/rest/update.html?id="+obj.id+"'>修改</a></td></tr>";
}
$("#data").html(str);
var cutStr = "";
for (var i = 1; i <= dataObj.totalPage; i++) {
cutStr += "<a href='javascript:ajax("+i+")'>"+i+"</a>";
}
$("#cutPageDiv").html(cutStr);
},"json");
}
function del(id){
$.ajax({
type:"DELETE",
url:"/rest/message/del/"+id,
success:function(info){
if (info == "删除成功") {
ajax(1);
}else{
alert("删除异常");
}
}
});
}
</script>
</head>
<body>
<table border="1" cellspacing="0" width="60%">
<thead>
<tr>
<td>姓名</td>
<td>电话</td>
<td>操作</td>
</tr>
</thead>
<tbody id="data"></tbody>
</table>
<div id="cutPageDiv"></div>
<form action="" id="f1">
姓名:<input type="text" name="userName"><br>
电话:<input type="text" name="tel"><br>
<input type="button" value="查询" onclick="ajax(1)">
</form>
<a href="/rest/add.html">添加用户</a>
</body>
</html>