40分钟手搓从数据库到前端页面（附完整代码）

最新推荐文章于 2022-11-21 11:14:51 发布

鹜骜

最新推荐文章于 2022-11-21 11:14:51 发布

阅读量1.7k

点赞数 2

分类专栏： Data Base java

本文链接：https://blog.csdn.net/weixin_42385705/article/details/103046256

版权

java 同时被 2 个专栏收录

33 篇文章 0 订阅

订阅专栏

Data Base

12 篇文章 0 订阅

订阅专栏

搬砖工具IDEA，MySQL，Tomcat，Maven

文章目录

建表

在这里插入图片描述

引入jar包

<?xml version="1.0" encoding="UTF-8"?>

<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/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>cn.kgc</groupId>
  <artifactId>xiangmu3</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>xiangmu3 Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
    <!--声明重复版本-->
    <spring-version>4.3.7.RELEASE</spring-version>
    <json-version>2.9.8</json-version>
  </properties>

  <!--添加依赖-->
  <dependencies>
    <dependency>
      <!--单元测试-->
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
      <!--provided表明该包只在编译和测试的时候用，因为tomcat也有servlet-api包，
      此处为了防止冲突-->
      <scope>provided</scope>
    </dependency>
    <!--jsp标签库-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <!--核心容器，提供基本框架-->
      <artifactId>spring-core</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <!--负责实现Spring框架的IOC模块-->
      <artifactId>spring-beans</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <!--spring应用上下文-->
      <artifactId>spring-context</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <!--分离事物逻辑视图控制器-->
      <artifactId>spring-webmvc</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <!--分离业务逻辑和数据库交互代码-->
      <artifactId>spring-jdbc</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <!--实现事务管理-->
      <artifactId>spring-tx</artifactId>
      <version>${spring-version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <!--mybatis与spring整合-->
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.2</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <!--mysql链接java JDBC的引擎-->
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>
    <dependency>
      <!--阿里巴巴连接池-->
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.10</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <!--序列化，将对象转换成json-->
      <artifactId>jackson-core</artifactId>
      <version>${json-version}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <!--反序列化-->
      <artifactId>jackson-databind</artifactId>
      <version>${json-version}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <!--注释语法 使json按按要求返回信息-->
      <artifactId>jackson-annotations</artifactId>
      <version>${json-version}</version>
    </dependency>
  </dependencies>

  <build>
    <!--mapper产生对应的xml文件-->
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
    </resources>

    <finalName>xiangmu3</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>

        <!--解决maven国内慢-->
        <plugin>
          <groupId>org.apache.maven.plugins</groupId>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.6.1</version>
          <configuration>
            <source>1.8</source>
            <target>1.8</target>
          </configuration>
        </plugin>

        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

src

实体类

package com.njbdqn.myweb.entity;

import java.io.Serializable;
import java.util.Date;
        
public class Userinfos implements Serializable {
    private int userid;
    private String username;
    private Date birthday;

    public int getUserid() {
        return userid;
    }

    public void setUserid(int userid) {
        this.userid = userid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }
}

接口

package com.njbdqn.myweb.dao;

import com.njbdqn.myweb.entity.Userinfos;

import java.util.List;

public interface NormalDAO {

    /**
     * sava data into database userinfos
     * @param user
     */
    public void insertUser(Userinfos user);

    /**
     * delete userinfos by userid
     * @param userid
     */
    public void delUser(int userid);

    /**
     * modify user infos by userid
     * @param user
     */
    public void modUser(Userinfos user);

    /**
     * search data table all user data
     * @return
     */
    public List<Userinfos> findAll();

    /**
     * search User by userid
     * @param userid
     * @return
     */
    public Userinfos finByid(int userid);
}

services

package com.njbdqn.myweb.services;

import com.njbdqn.myweb.dao.NormalDAO;
import com.njbdqn.myweb.entity.Userinfos;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service
@Transactional
public class UserService {
    //自动装配 在容器中找到并new一个UserDao对象
    @Autowired
    private NormalDAO normalDAO;

    public void saveUser(Userinfos user){
        normalDAO.insertUser(user);
    }

    public void deUser(int userid){
        normalDAO.delUser(userid);
    }

    public void modUser(Userinfos user){
        normalDAO.modUser(user);
    }

    public List<Userinfos> findAll(){
        return normalDAO.findAll();
    }

    public Userinfos finByid(int userid){
        return normalDAO.finByid(userid);
    }
}

controller

package com.njbdqn.myweb.controller;

import com.njbdqn.myweb.entity.Userinfos;
import com.njbdqn.myweb.services.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.WebDataBinder;
import org.springframework.web.bind.annotation.InitBinder;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.servlet.http.HttpServletRequest;
import java.text.SimpleDateFormat;
import java.util.Date;

@Controller
public class InitCtrl {
    @Autowired
    private UserService userService;
    /**
     *接受前端页面传送出来的日期类型 并进行转换
     */
    @InitBinder
    public void dateHanlder(WebDataBinder bind){
        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
        sdf.setLenient(true);
        bind.registerCustomEditor(Date.class,new CustomDateEditor(sdf,true));
    }

    @RequestMapping("/init.do")
    public String init(HttpServletRequest request){
        request.setAttribute("infos",userService.findAll());
        return "index.jsp";  // 转发 带请求
    }

    @RequestMapping("/save.do")
    public String save(Userinfos user){
        userService.saveUser(user);
        return "redirect:/init.do";  // servlet跳servlet 重定向 
    }

    @RequestMapping("/del.do")
    public String del(int userid){
        userService.deUser(userid);
        return "redirect:init.do";
    }

    @RequestMapping("/mod.do")
    public String mod(Userinfos user){
        userService.modUser(user);
        return "redirect:/init.do";
    }

    @RequestMapping("/single.do")
    public String single(int userid,HttpServletRequest request){
        request.setAttribute("user",userService.finByid(userid));
        return "user.jsp";
    }

}

resources

userinfo.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="com.njbdqn.myweb.dao.NormalDAO">
    <insert id="insertUser" parameterType="user">
        insert into userinfos(username,birthday) values (#{username},#{birthday})
    </insert>
    <delete id="delUser" parameterType="int">
        delete from userinfos where userid=#{userid}
    </delete>
    <update id="modUser" parameterType="user">
        update userinfos set username=#{username},birthday=#{birthday} where userid=#{userid}
    </update>
    <select id="findAll" resultType="user">
        select * from userinfos
    </select>
    <select id="finByid" parameterType="int" resultType="user">
        select * from userinfos where userid=#{userid}
    </select>
</mapper>

mybats-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>
        <typeAlias type="com.njbdqn.myweb.entity.Userinfos" alias="user"></typeAlias>
    </typeAliases>
</configuration>

spring.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:tx="http://www.springframework.org/schema/tx"
       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/context
                           http://www.springframework.org/schema/context/spring-context.xsd
                           http://www.springframework.org/schema/mvc
                           http://www.springframework.org/schema/mvc/spring-mvc.xsd
                           http://www.springframework.org/schema/tx
                           http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!--激活已经在spring容器里注册过的bean上面的注解-->
    <!--<context:annotation-config></context:annotation-config>-->

    <!--除了具有上面的功能之外，还具有自动将带有@component,@service,@Repository等注解的对象注册到spring容器中的功能-->
    <context:component-scan base-package="cn.kgc.myweb"></context:component-scan>

    <!--开启阿里巴巴连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mydemo"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </bean>

    <!--开启事务-->
    <!--比如账户登录，需要匹配用户名和密码，然后要增加积分，还要记录登录的ip和时间，这可能需要三个sql语句，这三个语句应当是一个整体，
    任意一个sql执行不成功，都表示这个业务没有执行完成，对前面的sql执行进行回滚。
　　事务是数据库中的概念，就是对数据库的一组操作，由一条或多条sql组成。
　　事务具有同步的特点，一条sql执行失败，其他sql都不会执行，即要么都执行，要么都不执行-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!--支持注解-->
    <tx:annotation-driven transaction-manager="transactionManager"/>

    <!--着整合mybatis与spring-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath*:mapper/*.xml"/>
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
    </bean>

    <!--自动扫描 将Mapper接口生成代理注入到Spring-->
    <bean id="scannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="cn.kgc.myweb.dao"/>
    </bean>

</beans>

web

web.xml

<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>
  <display-name>Archetype Created Web Application</display-name>
  <!--声明应用范围(整个WEB项目)内的上下文初始化参数-->
  <context-param>
    <!--设定上下文的参数名称-->
    <param-name>contextConfigLocation</param-name>
    <!--设定的参数名称的值-->
    <param-value>classpath:spring.xml</param-value>
  </context-param>

  <!--过滤器-->
  <filter>
    <filter-name>charset</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>charset</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

  <!--监听器-->
  <listener>
    <!--启动Web容器时，自动装配 配置信息-->
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

  <servlet>
    <servlet-name>spring</servlet-name>
    <!--拦截下来的请求，依据相应的规则分发到目标Controller来处理-->
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring.xml</param-value>
    </init-param>
  </servlet>

  <!--截获请求,将符合*.do格式的资源的请求都由指定的servlet处理-->
  <servlet-mapping>
    <servlet-name>spring</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>

</web-app>

index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<div class="header"><a href="save.jsp">保存新用户</a></div>
<div class="ctx">
    <table class="table">
        <tr>
            <th>用户编号</th>
            <th>用户姓名</th>
            <th>用户生日</th>
            <th>用户操作</th>
        </tr>
        <c:forEach items="${infos}" var="us">
        <tr>
            <td>${us.userid}</td>
            <td>${us.username}</td>
            <td>${us.birthday}</td>
            <td>
                <a href="single.do?userid=${us.userid}">修改</a><a href="del.do?userid=${us.userid}">删除</a>
            </td>
        </tr>
        </c:forEach>
    </table>
</div>
</body>
</html>

save.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<div class="ctx">
    <form action="save.do" method="post">
        <label >用户姓名</label>
        <input type="text" name="username"><br>
        <label >用户生日</label>
        <input type="date" name="birthday"><br>
        <input type="submit" value="提交用户"><br>
    </form>
</div>
</body>
</html>

user.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<html>
<head>
    <title>Title</title>
</head>
<body>
<div class="ctx">
    <form action="mod.do" method="post">

        <input type="hidden" name="userid" value="${user.userid}"/>
        <label >用户姓名</label>
        <input type="text" name="username" value="${user.username}"><br>
        <label >用户生日</label>
        <input type="date" name="birthday" value="${user.birthday}"><br>
        <label >用户</label>
        <input type="submit" value="修改用户"><br>

    </form>
</div>
</body>
</html>

最后

部署tomcat

齐活√

在这里插入图片描述

鹜骜

关注

2
点赞
踩
22

收藏

觉得还不错? 一键收藏
1
评论
40分钟手搓从数据库到前端页面（附完整代码）

搬砖工具IDEA，MySQL文章目录建表引入jar包src实体类接口servicescontrollerresourcesuserinfo.xmlmybats-config.xmlspring.xmlwebindex.jspsave.jspuser.jsp部署tomcat建表引入jar包<?xml version="1.0" encoding="UTF-8"?><p...
复制链接

扫一扫