数据库的增删改查

实体类User.java

package com.zhu.vo;/** * Created by idea on 2016/6/7. * 我就是你们的小星星 */public class User {    private int id;    private  String name;    private int age;    public User() {    }    public User(int id, String name, int age) {        this.id = id;        this.name = name;        this.age = age;    }    public User(String name, int age) {        this.name = name;        this.age = age;    }    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }}

数据访问层UserDao.java

package com.zhu.Dao;import com.zhu.vo.User;import java.util.List;/** *Created by idea on 2016/6/7. * 我就是你们的小星星 */public interface UserDao {    public int addUser(User user);    public int deleteUser(String name);    public int updateUser(User user);    public List<User>selectUser(int id);    public List<User>selectAll();}

数据访问层实现类UserDaoImpl.java

package com.zhu.daoImpl;import com.zhu.Dao.UserDao;import com.zhu.vo.User;import org.apache.ibatis.session.SqlSessionFactory;import org.mybatis.spring.SqlSessionTemplate;import org.mybatis.spring.support.SqlSessionDaoSupport;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Repository;import java.util.List;/** *Created by idea on 2016/6/7. * 我就是你们的小星星 */@Repository("userDao")public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {    @Autowired    @Override    public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {        super.setSqlSessionFactory(sqlSessionFactory);    }    public int addUser(User user) {        return getSqlSession().insert("mybatis/userMapper.addUser" , user);    }    public int deleteUser(String name) {        return getSqlSession().delete("mybatis/userMapper.deleteUser" , name);    }    public int updateUser(User user) {        return getSqlSession().update("mybatis/userMapper.updateUser" , user);    }    public List<User> selectUser(int id) {        return getSqlSession().selectList("mybatis/userMapper.selectUser" , id);    }    public List<User> selectAll() {        return getSqlSession().selectList("mybatis/userMapper.selectAll");    }}

业务层UserService.java

package com.zhu.service;import com.zhu.vo.User;import java.util.List;import java.util.jar.Attributes;/** *Created by idea on 2016/6/7. * 我就是你们的小星星 */public interface UserService {    public int addUser(User user);    public int deleteUser(String name);    public int updateUser(User user);    public List<User>selectUser(int id);    public List<User>selectAll();}

业务层实现类UserServiceImpl.java

package com.zhu.serviceImpl;import com.zhu.Dao.UserDao;import com.zhu.service.UserService;import com.zhu.vo.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;/** *Created by idea on 2016/6/7. * 我就是你们的小星星 */@Service("userService")public class UserServiceImpl implements UserService {    @Autowired    private UserDao userDao;    public void setUserDao(UserDao userDao) {        this.userDao = userDao;    }    public int addUser(User user) {        return userDao.addUser(user);    }    public int deleteUser(String name) {        return userDao.deleteUser(name);    }    public int updateUser(User user) {        return userDao.updateUser(user);    }    public List<User> selectUser(int id) {        return userDao.selectUser(id);    }    public List<User> selectAll() {        return userDao.selectAll();    }}

处理层UserController.java

package com.zhu.controller;import com.zhu.service.UserService;import com.zhu.vo.User;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.RequestParam;import org.springframework.web.bind.annotation.ResponseBody;import java.util.ArrayList;import java.util.List;/** *Created by idea on 2016/6/7. * 我就是你们的小星星 */@Controller@RequestMapping("/handle")public class UserController {    @Autowired    private UserService userService;    public void setUserService(UserService userService) {        this.userService = userService;    }    @RequestMapping("/addUser")    @ResponseBody    public List add(User user){        List list = new ArrayList();        list.add(userService.addUser(user));        return list;    }    @RequestMapping("/deleteUser")    @ResponseBody    public List delete(@RequestParam("name") String name){        System.out.println(name);        List list = new ArrayList();        list.add(userService.deleteUser(name));        return list;    }    @RequestMapping("/updateUser")    @ResponseBody    public List update(User user){        List list = new ArrayList();        list.add(userService.updateUser(user));        return list;    }    @RequestMapping("/selectUser")    @ResponseBody    public List selectUser(@RequestParam("id") int id){        List list = new ArrayList();        list.addAll(userService.selectUser(id));        return list;    }    @RequestMapping("/selectAll")    @ResponseBody    public List selectAll(){        List list = new ArrayList();        list.addAll(userService.selectAll());        return list;    }}

配置文件web.xml

<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_3_0.dtd" ><web-app>  <display-name>Archetype Created Web Application</display-name>        <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classpath:spring/beans.xml</param-value>    </context-param>    <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener>    <filter>        <filter-name>characterEncodingFilter</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>characterEncodingFilter</filter-name>        <url-pattern>/*</url-pattern>    </filter-mapping>    <servlet>        <servlet-name>springController</servlet-name>        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>        <init-param>            <param-name>contextConfigLocation</param-name>            <param-value>classpath:springmvc/spring-controller.xml</param-value>        </init-param>        <load-on-startup>1</load-on-startup>    </servlet>    <servlet-mapping>        <servlet-name>springController</servlet-name>        <url-pattern>*.do</url-pattern>    </servlet-mapping></web-app>

配置文件beans.xml(spring配置)

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"        xmlns:aop="http://www.springframework.org/schema/aop"       xmlns:tx="http://www.springframework.org/schema/tx"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd      http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">       <property name="location" value="classpath:properties/db.properties"/>    </bean>    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName" value="${driverClassName}"/>        <property name="url" value="${url}"/>        <property name="username" value="${username}"/>        <property name="password" value="${password}"/>    </bean>    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="configLocation" value="classpath:spring/mybatis-config.xml"/>    </bean>    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"/>    </bean>    <tx:advice id="txAdvice" transaction-manager="transactionManager">        <tx:attributes>            <tx:method name="*" propagation="REQUIRED"/>        </tx:attributes>    </tx:advice>    <aop:config>        <aop:pointcut id="pointcut" expression="execution(* com.zhu.daoImpl.*.*(..))"/>        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut"/>    </aop:config>    <context:component-scan base-package="com.zhu"/></beans>

资源配置文件db.properties

driverClassName=com.mysql.jdbc.Driverurl=jdbc:mysql://127.0.0.1:3306/mybatisusername=rootpassword=root

配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"        "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    <typeAliases>        <package name="com.zhu.vo"/>    </typeAliases>    <mappers>        <mapper resource="mybatis/userMapper.xml"/>    </mappers></configuration>

配置文件userMapper.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">    <mapper namespace="mybatis/userMapper">        <insert id="addUser" parameterType="User" keyColumn="true">            insert into user (name , age ) values (#{name},#{age})        </insert>        <delete id="deleteUser" parameterType="java.lang.String">            delete from user where name = #{name}        </delete>        <update id="updateUser" parameterType="User">            update user set name = #{name} , age = #{age} where id = #{id}        </update>        <select id="selectUser" resultType="User" parameterType="int">            select * from user where id = #{id}        </select>        <select id="selectAll" resultType="User">            select * from user        </select>    </mapper>

配置文件spring-controller（springmvc

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:mvc="http://www.springframework.org/schema/mvc"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd      http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">    <mvc:annotation-driven/>    <context:component-scan base-package="com.zhu.controller"/>    <bean id="stringConverter" class="org.springframework.http.converter.StringHttpMessageConverter">        <property name="supportedMediaTypes">            <list>                <value>text/html;charset=UTF-8</value>                <value>text/plain;charset=UTF-8</value>            </list>        </property>    </bean>    <bean id="jsonConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"></bean>    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">        <property name="messageConverters">            <list>                <ref bean="stringConverter"/>                <ref bean="jsonConverter"/>            </list>        </property>    </bean></beans>

user.jsp页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head>    <title>Title</title>    <style type="text/css" >       span{           color: red;       }    </style>    <script type="text/javascript" src="js/jquery-1.12.4.min.js"></script>    <script type="text/javascript" charset="utf-8">        $(document).ready(function () {            $("#btn1").click(function () {                $.post("/handle/deleteUser.do" , {name : $("#delete").val()} , function (data) {                    for (var i = 0 ; i < data.length ; i++) {                        $("#s1").html("已成功删除" + data[i] + "条数据")                    }                });            });        });        $(document).ready(function () {            $("#btn2").click(function () {                $("#t1").html("");                $.post("/handle/selectUser.do" , {id : $("#selectUser").val()} , function (data) {                    var html = "";                    for (var i = 0 ; i < data.length ; i++) {                        html += "<tr><td>" + data[i].id + "</td><td>" + data[i].name + "</td><td>" + data[i].age + "</td></tr>";                    }                    $("#t1").html(html);                });            });        });        $(document).ready(function () {            $("#btn3").click(function () {                $("#t1").html("");                $.post("/handle/selectAll.do" , function (data) {                    var html = "";                    for (var i = 0 ; i < data.length ; i++) {                        html += "<tr><td>" + data[i].id + "</td><td>" + data[i].name + "</td><td>" + data[i].age + "</td></tr>";                    }                    $("#t1").html(html);                });            });        });        $(document).ready(function () {            $("#btn4").click(function () {                $.post("/handle/addUser.do" , {name : $("#add1").val() , age : $("#add2").val()} , function (data) {                    for (var i = 0 ; i < data. length ; i++) {                        $("#s2").html("已成功添加" + data[i] + "条数据" );                    }                });            });        });        $(document).ready(function () {            $("#btn5").click(function () {                $.post("/handle/updateUser.do" , {id : $("#update1").val() , name : $("#update2").val() , age : $("#update3").val()} , function (data) {                    for (var i = 0 ; i < data.length ; i++) {                        $("#s3").html("已成功更新" + data[i] + "条数据")                    }                });            });        });    </script></head><body>    <div>        <input id="delete" type="text" name="name">         <button id="btn1">删除</button>         <span id="s1"></span>    </div>    <div>        <input id="selectUser" type="text" name="id">         <button id="btn2">查询</button>         <button id="btn3">查询全部</button>    </div>    <div>        <input id="add1" type="text" name="name">         <input id="add2" type="text" name="age">         <button id="btn4">增加</button>        <span id="s2"></span>     </div>    <div>        <input id="update1" type="text" name="id">         <input id="update2" type="text" name="name">         <input id="update3" type="text" name="age">         <button id="btn5">更改</button>         <span id="s3"></span>    </div>    <br/>    <br/>    <div>        <table width="80%" align="left">            <tr>                <td>编号</td>                <td>姓名</td>                <td>年龄</td>            </tr>            <tbody id="t1"></tbody>        </table>    </div></body></html>

因时间紧迫博文中没有加以注释，如果博友有问题请提出（本人也是初出茅庐）大家一起学习，共同进步。