SSM信息管理系统示例
SSM信息管理系统示例
1.项目结构
SSMDemo/
├── SSMDemo.iml
├── pom.xml
└── src
└── main
├── java
│ └── cn
│ └── edu
│ ├── data
│ │ ├── Student.java
│ │ ├── StudentController.java
│ │ ├── StudentMapper.java
│ │ ├── User.java
│ │ └── UserMapper.java
│ └── springmvc
│ └── login
│ └── UserController.java
└── webapp
├── WEB-INF
│ ├── classes
│ │ ├── log4j.properties
│ │ ├── mybatis-config.xml
│ │ └── springmvc.xml
│ ├── view
│ │ ├── error.jsp
│ │ └── showStudentList.jsp
│ └── web.xml
└── index.jsp
2. 代码
2.1 Student
package cn.edu.data;
public class Student {
private int ID; // 编号
private String studentID; // 学号
private String name; // 姓名
private String aclass; // 班级
public int getID() {
return ID;
}
public void setID(int ID) {
this.ID = ID;
}
public String getStudentID() {
return studentID;
}
public void setStudentID(String studentID) {
this.studentID = studentID;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAclass() {
return aclass;
}
public void setAclass(String aclass) {
this.aclass = aclass;
}
public Student(int ID, String studentID, String name, String aclass) {
this.ID = ID;
this.studentID = studentID;
this.name = name;
this.aclass = aclass;
}
public Student() {
}
}
2.2 StudentController
package cn.edu.data;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import java.util.List;
@Controller // 控制器注解
@RequestMapping("/student") // 类中的请求映射注解
public class StudentController { // 控制器类
//自动装配Mybatis Student映射器
@Autowired
StudentMapper studentmapper;
//查询全部学生
@RequestMapping("/selectall")
public String select(Model model) {
List<Student> student_list = studentmapper.selectAll();
model.addAttribute("student_list", student_list);
return "showStudentList";
}
//插入一条记录的录入视图
@RequestMapping("/addStudent")
public String addUser() {
return "AddStudent";
}
//插入一条记录
@RequestMapping("/insert")
public String insert(Student student) {
studentmapper.insert(student);
return "redirect:/student/selectall"; //通过重定向到selectall
}
//@RequestMapping("/delete/{studentID}")
@RequestMapping("/delete")
//public String delete(@PathVariable("studentID") String id) {
public String delete(Student student) {
studentmapper.delete(student.getStudentID());
return "redirect:/student/selectall"; //通过重定向到selectall
}
@RequestMapping("/update")
public String update(Student student) {
studentmapper.update(student);
return "redirect:/student/selectall"; //通过重定向到selectall
}
}
2.3 StudentMapper
package cn.edu.data;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface StudentMapper {
@Select("select id,studentID, name, class as aclass from student where ID = #{ID}")
Student selectOne(String studentID);
@Select("select id,studentID, name, class as aclass from student")
List<Student> selectAll();
@Insert("insert into student (studentID,name,class) values (#{studentID},#{name},#{aclass})")
int insert(Student student);
@Delete("delete from student where studentID = #{studentID}")
int delete(String studentID);
@Update("update student set studentID=#{studentID},name=#{name},class=#{aclass} where studentID=#{studentID}")
int update(Student student);
}
2.4 User
package cn.edu.data;
public class User{
private int id;
private String name;
private String password;
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public User(){}
public User(int id,String name){
this.setId(id);
this.setName(name);
}
public int getId(){
return this.id;
}
public void setId(int id){
this.id = id;
}
public String getName(){
return this.name;
}
public void setName(String name){
this.name = name;
}
}
2.5 UserMapper
package cn.edu.data;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface UserMapper {
@Select("select * from User where name=#{name}")
User selectOne(String name);
@Select("select * from User")
List<User> selectAll();
@Insert("insert into user (name,password) values (#{name},#{password})")
void insert(User user);
@Delete("delete from user where id = #{id}")
void delete(int id);
@Update("update user set name=#{name},password=#{password} where id=#{id} ")
void update(User user);
}
2.6 UserController
package cn.edu.springmvc.login;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import cn.edu.data.*;
@Controller // 控制器注解
@RequestMapping("/login") // 类中的请求映射注解
public class UserController{ // 控制器类
//自动装配Mybatis User映射器
@Autowired
UserMapper usermapper;
@RequestMapping("/check")
public String hello(User user, Model model){
// 视图模型对象初始化
ModelAndView modelAndView = new ModelAndView();
User user_test= (User)usermapper.selectOne(user.getName());
if(user_test.getPassword().equals(user.getPassword()))
{
modelAndView.addObject(user);
return "redirect:/student/selectall";
}
else
{
model.addAttribute("msg", "登录密码或用户名错误！！");
return "error";
}
}
//查询全部用户
@RequestMapping("/selectall")
public String select(Model model){
//ModelAndView modelAndView = new ModelAndView();
List<User> user_list = (List<User>)usermapper.selectAll();
/*for(User user:user_list)
System.out.println(user.getId()+" "+user.getName()+" "+user.getPassword());*/
model.addAttribute("user_list",user_list);
return "showList";
}
//插入一条记录的录入视图
@RequestMapping("/adduser")
public String addUser() {
return "AddUser";
}
//插入一条记录
@RequestMapping("/insert")
public String insert(User user) {
usermapper.insert(user);
return "hello";
}
@RequestMapping("/delete")
public String delete(User user) {
usermapper.delete(user.getId());
return "hello";
}
@RequestMapping("/update")
public String update(User user) {
usermapper.update(user);
return "hello";
}
}
3. 配置文件
log4j
#//注意这里不要用INFO，DEBUG等 改个名字
log4j.rootLogger=infoA,errorA,stdout,DEBUGA
#过滤掉spring框架下的额外日志
log4j.category.org.springframework = WARN
#输出到控制台
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.Threshold = debug
log4j.appender.stdout.layout.ConversionPattern=%d %-5p %c{1}:%L - %m%n
#输出error到指定文件
log4j.logger.errorA=error
log4j.appender.errorA=org.apache.log4j.DailyRollingFileAppender
log4j.appender.errorA.layout=org.apache.log4j.PatternLayout
log4j.appender.errorA.layout.ConversionPattern=%d{yyyy-MM-dd-HH-mm} [%t] [%c] [%p] - %m%n
log4j.appender.errorA.datePattern=yyyy-MM-dd'.log'
log4j.appender.errorA.Threshold = error
log4j.appender.errorA.append=true
log4j.appender.error.File=d:/log/error.log
#输出DEBUG信息到指定文件
log4j.logger.DEBUGA=DEBUG
log4j.appender.DEBUGA=org.apache.log4j.DailyRollingFileAppender
log4j.appender.DEBUGA.layout=org.apache.log4j.PatternLayout
log4j.appender.DEBUGA.layout.ConversionPattern=%d{yyyy-MM-dd-HH-mm} [%t] [%c] [%p] - %m%n
log4j.appender.DEBUGA.datePattern=yyyy-MM-dd'.log'
log4j.appender.DEBUGA.Threshold = DEBUG
log4j.appender.DEBUGA.append=true
log4j.appender.DEBUGA.File=d:/log/debug_log.log
#打印sql语句
log4j.logger.com.ibatis=DEBUG
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
mybatis
<?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>
<settings>
<setting name="logImpl" value="LOG4J"/>
<setting name="cacheEnabled" value="true"/>
</settings>
<typeAliases>
<package name="cn.edu" />
</typeAliases>
</configuration>
springmvc
<?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:mvc="http://www.springframework.org/schema/mvc"
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 " >
<!-- 开启注解配置
<context:component-scan base-package="cn.edu.springmvc.test"/>
<mvc:annotation-driven enable-matrix-variables="true" />-->
<mvc:annotation-driven/>
<mvc:default-servlet-handler/>
<context:component-scan base-package="cn.edu.data,cn.edu.springmvc.login"/>
<!--视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/view/" /> <!--视图前缀-->
<property name="suffix" value=".jsp" /> <!--视图后缀-->
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close" >
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/javaee_database" />
<property name="username" value="root"/>
<property name="password" value="root" />
<property name="maxTotal" value="20" />
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- <property name="mapperLocations" value="classpath*:cn/edu/data/**/*.xml" />-->
<property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>
<!--映射扫描-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cn.edu.data"/>
</bean>
</beans>
4. 前端页面
error
<%@page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" isELIgnored="false" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset = utf-8" />
<style text="css">
.header {
background-color: #f1f1f1;
padding: 20px;
text-align: center;
}
/* 导航条 */
.topnav {
overflow: hidden;
background-color: #333;
color: white;
}
/* 创建列 */
.column {
float: left;
width: 100%;
text-align: center;
}
/* 列后清除浮动 */
.row:after {
content: "";
display: table;
clear: both;
}
fieldset {
margin: 30px auto;
width: 300px;
height: 200px;
padding: 20px auto;
color: blue;
text-align: center;
}
/*label部分CSS才是重点*/
label {
display: inline-block;
width: 60px;
text-align: justify;
text-align-last: justify;
margin-right: 10px;
}
</style>
</head>
<body>
<div class="header" >
<h2>SSM Demo</h2>
<h2>SSM框架的学生信息管理系统</h2>
</div>
<div class="topnav">
演示SSM框架的使用方法
</div>
<div class="row">
<div class="column">
<h2 style="color:red"> 错误信息: ${msg} </h2>
</div>
</div>
</body>
</html>
showStudentList
<%@page import="java.util.List"%>
<%@page import="java.util.ArrayList"%>
<%@page import="cn.edu.data.User"%>
<%@page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset = utf-8" />
<style text="css">
.header {
background-color: #f1f1f1;
padding: 20px;
text-align: center;
}
/* 导航条 */
.topnav {
overflow: hidden;
background-color: #333;
color: white;
}
/* 创建列 */
.column {
float: left;
width: 100%;
text-align: center;
}
/* 列后清除浮动 */
.row:after {
content: "";
display: table;
clear: both;
}
table
{
border-collapse:collapse;
}
table,th, td
{
border: 2px solid blue;
}
fieldset {
margin: 30px auto;
width: 300px;
height: 200px;
padding: 20px auto;
color: blue;
text-align: center;
}
label {
display: inline-block;
width: 60px;
text-align: justify;
text-align-last: justify;
margin-right: 10px;
}
</style>
</head>
<body>
<div class="header" >
<h2>SSM Demo</h2>
<h2>SSM框架的学生信息管理系统</h2>
</div>
<div class="topnav">
演示SSM框架的使用方法
</div>
<br>
<fieldset>
<div class="row">
<div class="column">
<table align="center">
<tr><td>学号</td><td>姓名</td><td>班级</td></tr>
<c:forEach items="${student_list}" var="person">
<tr>
<td>${person.studentID}</td><td>${person.name}</td><td>${person.aclass}</td>
</tr>
</c:forEach>
</table>
<br>
<form name="deleteform" method="post" action="/student/delete">
<label>学号</label><input type="text" name="studentID" id="name"><input type="submit" value="删除">
</form>
</div>
</div>
</fieldset>
<br>
<%--<div style="text-align: center">
<a s href="/student/addStudent" >添加学生</a>
</div>--%>
<br>
<fieldset>
<form name="updateform" method="post" action="/student/insert">
<p><label>学号</label><input type="text" name="studentID" id="name">
<p><label>姓名</label><input type="text" name="name" id="name">
<p><label>班级</label><input type="text" name="aclass" id="name">
<p><input type="submit" value="添加">
</form>
</fieldset>
<br>
<fieldset>
<form name="updateform" method="post" action="/student/update">
<p><label>学号</label><input type="text" name="studentID" id="name">
<p><label>姓名</label><input type="text" name="name" id="name">
<p><label>班级</label><input type="text" name="aclass" id="name">
<p><input type="submit" value="更新">
</form>
</fieldset>
</body>
</html>
index
<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset = utf-8" />
<style text="css">
.header {
background-color: #f1f1f1;
padding: 20px;
text-align: center;
}
/* 导航条 */
.topnav {
overflow: hidden;
background-color: #333;
color: white;
}
/* 创建列 */
.column {
float: left;
width: 100%;
text-align: center;
}
/* 列后清除浮动 */
.row:after {
content: "";
display: table;
clear: both;
}
fieldset {
margin: 30px auto;
width: 300px;
height: 200px;
padding: 20px auto;
color: blue;
text-align: center;
}
label {
display: inline-block;
width: 60px;
text-align: justify;
text-align-last: justify;
margin-right: 10px;
}
</style>
</head>
<body>
<div class="header" >
<h2>SSM Demo</h2>
<h2>SSM框架的学生信息管理系统</h2>
</div>
<div class="topnav">
演示SSM框架的使用方法
</div>
<div class="row">
<div class="column">
<h2>登录界面</h2>
<form name="loginform" method="post" action="/login/check"
>
<fieldset>
<legend>用户登录</legend>
<br>
<br><label>用户名</label><input type="text" name="name" id="name"><br>
<br><label>密 码</label><input type="password"
name="password" id="password"><br>
<br><input type="submit" value="提交">
<input type="reset">
</fieldset>
</form>
</div>
</div>
</body>
</html>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1">
<display-name>Archetype Created Web Application</display-name>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:springmvc.xml</param-value>
</context-param>
<!-- Spring MVC 配置-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value></param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!--log4j配置文件开始-->
<context-param>
<param-name>log4jConfigLocation</param-name>
<param-value>classpath:log4j.properties</param-value>
</context-param>
</web-app>
pom
<?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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>cn.edu.sd</groupId>
<artifactId>SSMDemo</artifactId>
<packaging>war</packaging>
<version>1.0-SNAPSHOT</version>
<name>SSMDemo Maven Webapp</name>
<url>http://maven.apache.org</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<java.version>1.8</java.version>
<spring.version>5.3.12</spring.version>
</properties>
<dependencies>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-core-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- Mybatis框架的依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<!-- mybatis与spring的整合框架 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.6</version>
</dependency>
<!-- DBCP2 数据库连接池 -->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-dbcp2</artifactId>
<version>2.9.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.eclipse.jetty/jetty-server
<dependency>
<groupId>org.eclipse.jetty</groupId>
<artifactId>jetty-server</artifactId>
<version>11.0.7</version>
<scope>compile</scope>
</dependency>
-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>4.0.1</version>
<scope>provided</scope>
</dependency>
<!-- 单元测试 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.thymeleaf</groupId>
<artifactId>thymeleaf</artifactId>
<version>3.0.12.RELEASE</version>
</dependency>
<!-- JSP标准标签库 -->
<!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 日志系统 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!--slf4j+log4j-->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.25</version>
</dependency>
<!-- 以下为三种数据库的依赖 -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.197</version>
<scope>runtime</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<!--
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.27</version>
<scope>runtime</scope>
</dependency>
-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.27</version>
<!-- <version>5.1.49</version> -->
<scope>runtime</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc -->
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.36.0.3</version>
<scope>runtime</scope>
</dependency>
</dependencies>
<build>
<!--
<sourceDirectory>src\main</sourceDirectory>
<finalName>SSMDemoWeb</finalName>
-->
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>2.3.2</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>3.3.2</version>
<configuration>
<archive>
<manifest>
<addClasspath>true</addClasspath>
</manifest>
</archive>
</configuration>
</plugin>
<plugin>
<groupId>org.eclipse.jetty</groupId>
<artifactId>jetty-maven-plugin</artifactId>
<version>9.4.15.v20190215</version>
<!-- <version>11.0.7</version> -->
<configuration>
<scanIntervalSeconds>10</scanIntervalSeconds>
<httpConnector>
<port>80</port>
</httpConnector>
<!-- <webApp>
<contextPath>/coshaho</contextPath>
</webApp>-->
</configuration>
</plugin>
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
<executions>
<execution>
<id>copy-xmls</id>
<phase>process-sources</phase>
<goals>
<goal>copy-resources</goal>
</goals>
<configuration>
<outputDirectory>${basedir}/target/classes</outputDirectory>
<resources>
<resource>
<directory>${basedir}/src/main/java/</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
<resource>
<directory>${basedir}/src/main/java/</directory>
<includes>
<include>**/*.properties</include>
</includes>
</resource>
</resources>
</configuration>
</execution>
</executions>
</plugin>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.1</version>
<configuration>
<port>80</port>
<path>/</path>
</configuration>
</plugin>
</plugins>
</build>
</project>
5. 运行
数据库
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.5.40 : Database - javaee_database
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`javaee_database` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `javaee_database`;
/*Table structure for table `student` */
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`studentID` varchar(100) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`class` varchar(100) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*Data for the table `student` */
insert into `student`(`ID`,`studentID`,`name`,`class`) values (2,'2019216582','二子','7'),(3,'2019216583','小明','2'),(5,'2019216581','瑞醉','12');
/*Table structure for table `user` */
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(100) NOT NULL,
`Password` varchar(100) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*Data for the table `user` */
insert into `user`(`ID`,`Name`,`Password`) values (9,'root','root'),(10,'ding3','ding'),(11,'ding1','ding'),(12,'ding2','ding');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
道阻且长,行则将至
浙公网安备 33010602011771号