数据库的增删改查

最新推荐文章于 2023-06-16 17:25:57 发布

置顶我就是你的小星星

最新推荐文章于 2023-06-16 17:25:57 发布

阅读量491

点赞数

分类专栏：原创文章标签： spring springmvc mybatis jquery ajax

本文链接：https://blog.csdn.net/qq_34321070/article/details/51606719

版权

原创专栏收录该内容

24 篇文章 0 订阅

订阅专栏

实体类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.Driver
url=jdbc:mysql://127.0.0.1:3306/mybatis
username=root
password=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>

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

我就是你的小星星

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
数据库的增删改查

实体类User.javapackage com.zhu.vo;/** * Created by idea on 2016/6/7. * 我就是你们的小星星 */public class User { private int id; private String name; private int age; public User() { }
复制链接

扫一扫