连接数据库展示表格

一、需求:

用户信息的增刪改查操作

二、设计:

1.技术选型:
Servlet+JSP +MySQL +JDBCTempleat+Dui rd+BeanUtilS+tomcat
2.数据库设计:

create database day17; 		- -创建数据库
use day17;						- -使用数据库
create table user(			- - 创建表
id int primary key auto_increment,
name varchar(20) not null,
gender varchar(5),
age int, 
address varchar(32),
qq varchar(20),
email varchar(50)
);

INSERT INTO `user`(`id`, `name`, `gender`, `age`, `address`, `qq`, `email`) VALUES (1, '张三', '男', 16, '南昌', '25334656564', '233656454@qq.com');
INSERT INTO `user`(`id`, `name`, `gender`, `age`, `address`, `qq`, `email`) VALUES (2, '李四', '男', 20, '九江', '23656456464', '466656464@qq.com');
INSERT INTO `user`(`id`, `name`, `gender`, `age`, `address`, `qq`, `email`) VALUES (3, '丽萨', '女', 23, '深圳', '235666656', '6564544@qq.com');
INSERT INTO `user`(`id`, `name`, `gender`, `age`, `address`, `qq`, `email`) VALUES (4, '玛丽', '女', 25, '上海', '6562334', '64451544@qq.com');

三、开发:

1.环境搭建
（1）创建数据库环境
（2）创建项目，导入需要的jar包（利用Maven）
2.编码
（1）新建Maven的WEB项目
注意勾选webapp的框架

（2）补全目录结构

（3）Maven的jar包导入
pom.xml文件

<?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>org.example</groupId>
  <artifactId>day17test</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>day17test 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.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
  </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>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.1</version>
      <scope>provided</scope>
    </dependency>
    <!--bootstrap -->
    <dependency>
      <groupId>org.webjars</groupId>
      <artifactId>bootstrap</