• JavaWeb 综合案例（包含注册与登录页面，包含对数据库的增删改查页面）新增加session与cookie与验证码

    目录

    1.案例结构（会依次对代码进行展示和解答） 

    2.BrandMapper接口类

    3.UserMapper接口类

    4.Brand实体类

    5.User实体类

    6.BrandService（集成所有的方法）

    7.UserService（结成所有的方法）

    8.CheckCodeUtil工具类（做验证码）

    9.SqlSessionFactoryUtils工具类

    10.AddServlet（实现添加）

    11.CheckCodeServlet（实现验证码的添加）

    12.DeleteServlet（实现删除）

    13.LoginServlet（实现登录功能）

    14.RegisterServlet（实现注册功能）

    15.SelectAllServlet（实现查找）

    16.SelectByIdServlet（实现回显--update中的模块）

    17.UpdateServlet（实现更新）

    18.BrandMapper.xml（Brand映射文件）

    19.UserMapper.xml（User映射文件，没有用到）

    20.Mybatis-config.xml（Mybatis实现连接数据库）

    21.CSS文件（登录注册页面的CSS文件）

    1.login.css

    2.register.css

    22.IMG文件（登陆注册的IMG文件）

    1.a.jpg

    2.Desert1.jpg

    3.reg_bg_min.jpg

    23.addBrand.jsp（显示添加页面）

    24.brand.jsp（实现查找的页面）

    25.delete.jsp（实现删除的页面）

    26.index.html（主页面，显示brand.jsp的链接）

    27.login.jsp（实现登录的页面）

    28.register.jsp（实现注册的页面）

    29.update.jsp（显示更新的界面）

    30.pom文件（存储的关于Java的一些依赖）

    31.展示页面

    (算了，不想展示了，如果有哪位朋友愿意来看的话，给我留言我私信给你)

    1.案例结构（会依次对代码进行展示和解答） 

    2.BrandMapper接口类

    1. package com.itheima.mapper;
    2.  
    3. import com.itheima.pojo.Brand;
    4. import org.apache.ibatis.annotations.*;
    5.  
    6. import java.util.List;
    7.  
    8. public interface BrandMapper {
    9.  
    10.     /**
    11.      * dao层查询所有的操作
    12.      * @return
    13.      */
    14.     @Select("select * from tb_brand")
    15.     @ResultMap("brandResultMap")
    16.     List selectAll();
    17.  
    18.     /**
    19.      * dao层添加数据
    20.      * @param brand
    21.      */
    22.     @Insert("insert into tb_brand values (null,#{brandName},#{companyName},#{ordered},#{description},#{status})")
    23.     void add(Brand brand);
    24.  
    25.     /**
    26.      * 更改数据前的回显数据，图像化根据id查询
    27.      * @param id
    28.      * @return
    29.      */
    30.     @Select("select * from tb_brand where id = #{id}")
    31.     @ResultMap("brandResultMap")
    32.     Brand selectById(int id);
    33.  
    34.     /**
    35.      * 修改语句
    36.      * @param brand
    37.      */
    38.     @Update("update tb_brand set brand_name=#{brandName},company_name=#{companyName},ordered=#{ordered},description=#{description},status=#{status} where id=#{id}")
    39.     void update(Brand brand);
    40.  
    41.     @Delete("delete from  tb_brand where id = #{id}")
    42.     void delete(int id);
    43. }

    3.UserMapper接口类

    1. package com.itheima.mapper;
    2.  
    3. import com.itheima.pojo.User;
    4. import org.apache.ibatis.annotations.Insert;
    5. import org.apache.ibatis.annotations.Param;
    6. import org.apache.ibatis.annotations.Select;
    7.  
    8. public interface UserMapper {
    9.  
    10.  
    11.     /**
    12.      * 根据用户名和密码查询用户对象
    13.      * @param username
    14.      * @param password
    15.      * @return
    16.      */
    17.     @Select("select * from tb_user where username = #{username} and password = #{password}")
    18.     User select(@Param("username") String username,@Param("password")  String password);
    19.  
    20.     /**
    21.      * 根据用户名查询用户对象
    22.      * @param username
    23.      * @return
    24.      */
    25.     @Select("select * from tb_user where username = #{username}")
    26.     User selectByUsername(String username);
    27.  
    28.     /**
    29.      * 添加用户
    30.      * @param user
    31.      */
    32.     @Insert("insert into tb_user values(null,#{username},#{password})")
    33.     void add(User user);
    34. }

    4.Brand实体类

    1. package com.itheima.pojo;
    2. /*
    3. 在实体类中，基本数据类型，建议使用其对应的包装类
    4.  */
    5. public class Brand {
    6.  
    7.     //id主键
    8.     private Integer id;
    9.     //品牌名称
    10.     private String brandName;
    11.     //企业名称
    12.     private String companyName;
    13.     //排序字段
    14.     private Integer ordered;
    15.     //描述信息
    16.     private String description;
    17.     //状态 0：禁用 1：启用
    18.     private Integer status;
    19.     public Brand(Integer id, String brandName, String companyName, Integer ordered, String description,
    20.                  Integer status) {
    21.         super();
    22.         this.id = id;
    23.         this.brandName = brandName;
    24.         this.companyName = companyName;
    25.         this.ordered = ordered;
    26.         this.description = description;
    27.         this.status = status;
    28.     }
    29.     public Brand() {
    30.     }
    31.     @Override
    32.     public String toString() {
    33.         return "Brand [id=" + id + ", brandName=" + brandName + ", companyName=" + companyName + ", ordered=" + ordered
    34.                 + ", description=" + description + ", status=" + status + "]";
    35.     }
    36.     public Integer getId() {
    37.         return id;
    38.     }
    39.     public void setId(Integer id) {
    40.         this.id = id;
    41.     }
    42.     public String getBrandName() {
    43.         return brandName;
    44.     }
    45.     public void setBrandName(String brandName) {
    46.         this.brandName = brandName;
    47.     }
    48.     public String getCompanyName() {
    49.         return companyName;
    50.     }
    51.     public void setCompanyName(String companyName) {
    52.         this.companyName = companyName;
    53.     }
    54.     public Integer getOrdered() {
    55.         return ordered;
    56.     }
    57.     public void setOrdered(Integer ordered) {
    58.         this.ordered = ordered;
    59.     }
    60.     public String getDescription() {
    61.         return description;
    62.     }
    63.     public void setDescription(String description) {
    64.         this.description = description;
    65.     }
    66.     public Integer getStatus() {
    67.         return status;
    68.     }
    69.     public void setStatus(Integer status) {
    70.         this.status = status;
    71.     }
    72. }

    5.User实体类

    1. package com.itheima.pojo;
    2.  
    3. public class User {
    4.  
    5.     private Integer id;
    6.     private String username;
    7.     private String password;
    8.  
    9.     public Integer getId() {
    10.         return id;
    11.     }
    12.  
    13.     public void setId(Integer id) {
    14.         this.id = id;
    15.     }
    16.  
    17.     public String getUsername() {
    18.         return username;
    19.     }
    20.  
    21.     public void setUsername(String username) {
    22.         this.username = username;
    23.     }
    24.  
    25.     public String getPassword() {
    26.         return password;
    27.     }
    28.  
    29.     public void setPassword(String password) {
    30.         this.password = password;
    31.     }
    32.  
    33.     @Override
    34.     public String toString() {
    35.         return "User{" +
    36.                 "id=" + id +
    37.                 ", username='" + username + '\'' +
    38.                 ", password='" + password + '\'' +
    39.                 '}';
    40.     }
    41. }

    6.BrandService（集成所有的方法）

    1. package com.itheima.service;
    2.  
    3. import com.itheima.Util.SqlSessionFactoryUtils;
    4. import com.itheima.mapper.BrandMapper;
    5. import com.itheima.pojo.Brand;
    6. import org.apache.ibatis.session.SqlSession;
    7. import org.apache.ibatis.session.SqlSessionFactory;
    8.  
    9. import java.util.List;
    10.  
    11. public class BrandService {
    12.     SqlSessionFactory factory= SqlSessionFactoryUtils.getSqlSessionFactory();
    13.  
    14.     /**
    15.      * service查询所有的功能
    16.      * @return
    17.      */
    18.     public List selectAll() {
    19.         //调用BrandMapper.selectAll()方法
    20.  
    21.  
    22.         //获取SqlSession
    23.         SqlSession sqlSession = factory.openSession();
    24.  
    25.         //获取BrandMapper
    26.         BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
    27.  
    28.         //调用方法
    29.         List brands = mapper.selectAll();
    30.  
    31.         //关闭sqlSession
    32.         sqlSession.close();
    33.  
    34.         //返回brands
    35.         return brands;
    36.     }
    37.  
    38.     /**
    39.      * 添加数据库
    40.      * @return
    41.      */
    42.     public void add(Brand brand) {
    43.         //调用BrandMapper.selectAll()方法
    44.  
    45.  
    46.         //获取SqlSession
    47.         SqlSession sqlSession = factory.openSession(true);
    48.  
    49.         //获取BrandMapper
    50.         BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
    51.  
    52.         //调用方法
    53.          mapper.add(brand);
    54.  
    55.         //关闭sqlSession
    56.         sqlSession.close();
    57.  
    58.     }
    59.     /**
    60.      * 根据id查询
    61.      * @return
    62.      */
    63.     public Brand selectById(int id) {
    64.         //调用BrandMapper.selectAll()方法
    65.  
    66.  
    67.         //获取SqlSession
    68.         SqlSession sqlSession = factory.openSession();
    69.  
    70.         //获取BrandMapper
    71.         BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
    72.  
    73.         //调用方法
    74.         Brand brand = mapper.selectById(id);
    75.  
    76.         //关闭sqlSession
    77.         sqlSession.close();
    78.  
    79.         //返回brand
    80.         return brand;
    81.     }
    82.  
    83.     public void update(Brand brand) {
    84.         //调用BrandMapper.selectAll()方法
    85.  
    86.  
    87.         //获取SqlSession
    88.         SqlSession sqlSession = factory.openSession(true);
    89.  
    90.         //获取BrandMapper
    91.         BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
    92.  
    93.         //调用方法
    94.         mapper.update(brand);
    95.  
    96.         //关闭sqlSession
    97.         sqlSession.close();
    98.  
    99.     }
    100.     public void delete(int id) {
    101.         //调用BrandMapper.selectAll()方法
    102.  
    103.  
    104.         //获取SqlSession
    105.         SqlSession sqlSession = factory.openSession(true);
    106.  
    107.         //获取BrandMapper
    108.         BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
    109.  
    110.         //调用方法
    111.         mapper.delete(id);
    112.  
    113.         //关闭sqlSession
    114.         sqlSession.close();
    115.  
    116.     }
    117. }

    7.UserService（结成所有的方法）

    1. package com.itheima.service;
    2.  
    3. import com.itheima.Util.SqlSessionFactoryUtils;
    4. import com.itheima.mapper.UserMapper;
    5. import com.itheima.pojo.User;
    6. import org.apache.ibatis.session.SqlSession;
    7. import org.apache.ibatis.session.SqlSessionFactory;
    8.  
    9. public class UserService {
    10.     //获取util工具包的SqlSessionFactory
    11.     SqlSessionFactory factory= SqlSessionFactoryUtils.getSqlSessionFactory();
    12.     //调用UserMapper，构成方法，来让servlet进行下一步操作
    13.  
    14.     /**
    15.      * 登录
    16.      * @param username
    17.      * @param password
    18.      * @return
    19.      */
    20.     public User login(String username,String password){
    21.  
    22.         //获取SqlSession,查找不需要事务，所以选择不提交事务
    23.         SqlSession sqlSession = factory.openSession();
    24.  
    25.         //获取UserMapper
    26.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    27.  
    28.         //调用方法
    29.         User user = mapper.select(username, password);
    30.  
    31.         //关闭sqlSession
    32.         sqlSession.close();
    33.  
    34.         //返回user
    35.         return user;
    36.     }
    37.  
    38.     public Boolean register(User user) {
    39.  
    40.         //获取SqlSession,查找不需要事务，所以选择不提交事务
    41.         SqlSession sqlSession = factory.openSession();
    42.  
    43.         //获取UserMapper
    44.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    45.  
    46.         //判断用户名是否存在
    47.         User u = mapper.selectByUsername(user.getUsername());
    48.  
    49.         if ( u == null ){
    50.             //用户名不存在
    51.             mapper.add(user);
    52.             //提交事务
    53.             sqlSession.commit();
    54.         }
    55.         //关闭sqlSession，释放资源
    56.         sqlSession.close();
    57.         return u == null;
    58.     }
    59. }

    8.CheckCodeUtil工具类（做验证码）

    1. package com.itheima.Util;
    2.  
    3. import javax.imageio.ImageIO;
    4. import java.awt.*;
    5. import java.awt.geom.AffineTransform;
    6. import java.awt.image.BufferedImage;
    7. import java.io.*;
    8. import java.util.Arrays;
    9. import java.util.Random;
    10.  
    11. /**
    12.  * 生成验证码工具类
    13.  */
    14. public class CheckCodeUtil {
    15.  
    16.     public static final String VERIFY_CODES = "123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
    17.     private static Random random = new Random();
    18.  
    19.     public static void main(String[] args) throws IOException {
    20.         FileOutputStream fos = new FileOutputStream("D://152//a.jpg");
    21.         String checkCode = CheckCodeUtil.outputVerifyImage(100, 50, fos, 4);
    22.         System.out.println(checkCode);
    23.     }
    24.  
    25.  
    26.     /**
    27.      * 输出随机验证码图片流,并返回验证码值（一般传入输出流，响应response页面端，Web项目用的较多）
    28.      *
    29.      * @param width 图片宽度
    30.      * @param height 图片高度
    31.      * @param os 输出流
    32.      * @param verifySize 数据长度
    33.      * @return 返回验证码数据
    34.      * @throws IOException
    35.      */
    36.     public static String outputVerifyImage(int width, int height, OutputStream os, int verifySize) throws IOException {
    37.         String verifyCode = generateVerifyCode(verifySize);
    38.         outputImage(width, height, os, verifyCode);
    39.         return verifyCode;
    40.     }
    41.  
    42.     /**
    43.      * 使用系统默认字符源生成验证码
    44.      *
    45.      * @param verifySize 验证码长度
    46.      * @return
    47.      */
    48.     public static String generateVerifyCode(int verifySize) {
    49.         return generateVerifyCode(verifySize, VERIFY_CODES);
    50.     }
    51.  
    52.     /**
    53.      * 使用指定源生成验证码
    54.      *
    55.      * @param verifySize 验证码长度
    56.      * @param sources    验证码字符源
    57.      * @return
    58.      */
    59.     public static String generateVerifyCode(int verifySize, String sources) {
    60.         // 未设定展示源的字码，赋默认值大写字母+数字
    61.         if (sources == null || sources.length() == 0) {
    62.             sources = VERIFY_CODES;
    63.         }
    64.         int codesLen = sources.length();
    65.         Random rand = new Random(System.currentTimeMillis());
    66.         StringBuilder verifyCode = new StringBuilder(verifySize);
    67.         for (int i = 0; i < verifySize; i++) {
    68.             verifyCode.append(sources.charAt(rand.nextInt(codesLen - 1)));
    69.         }
    70.         return verifyCode.toString();
    71.     }
    72.  
    73.     /**
    74.      * 生成随机验证码文件,并返回验证码值 (生成图片形式，用的较少)
    75.      *
    76.      * @param w
    77.      * @param h
    78.      * @param outputFile
    79.      * @param verifySize
    80.      * @return
    81.      * @throws IOException
    82.      */
    83.     public static String outputVerifyImage(int w, int h, File outputFile, int verifySize) throws IOException {
    84.         String verifyCode = generateVerifyCode(verifySize);
    85.         outputImage(w, h, outputFile, verifyCode);
    86.         return verifyCode;
    87.     }
    88.  
    89.  
    90.  
    91.     /**
    92.      * 生成指定验证码图像文件
    93.      *
    94.      * @param w
    95.      * @param h
    96.      * @param outputFile
    97.      * @param code
    98.      * @throws IOException
    99.      */
    100.     public static void outputImage(int w, int h, File outputFile, String code) throws IOException {
    101.         if (outputFile == null) {
    102.             return;
    103.         }
    104.         File dir = outputFile.getParentFile();
    105.         //文件不存在
    106.         if (!dir.exists()) {
    107.             //创建
    108.             dir.mkdirs();
    109.         }
    110.         try {
    111.             outputFile.createNewFile();
    112.             FileOutputStream fos = new FileOutputStream(outputFile);
    113.             outputImage(w, h, fos, code);
    114.             fos.close();
    115.         } catch (IOException e) {
    116.             throw e;
    117.         }
    118.     }
    119.  
    120.     /**
    121.      * 输出指定验证码图片流
    122.      *
    123.      * @param w
    124.      * @param h
    125.      * @param os
    126.      * @param code
    127.      * @throws IOException
    128.      */
    129.     public static void outputImage(int w, int h, OutputStream os, String code) throws IOException {
    130.         int verifySize = code.length();
    131.         BufferedImage image = new BufferedImage(w, h, BufferedImage.TYPE_INT_RGB);
    132.         Random rand = new Random();
    133.         Graphics2D g2 = image.createGraphics();
    134.         g2.setRenderingHint(RenderingHints.KEY_ANTIALIASING, RenderingHints.VALUE_ANTIALIAS_ON);
    135.  
    136.         // 创建颜色集合，使用java.awt包下的类
    137.         Color[] colors = new Color[5];
    138.         Color[] colorSpaces = new Color[]{Color.WHITE, Color.CYAN,
    139.                 Color.GRAY, Color.LIGHT_GRAY, Color.MAGENTA, Color.ORANGE,
    140.                 Color.PINK, Color.YELLOW};
    141.         float[] fractions = new float[colors.length];
    142.         for (int i = 0; i < colors.length; i++) {
    143.             colors[i] = colorSpaces[rand.nextInt(colorSpaces.length)];
    144.             fractions[i] = rand.nextFloat();
    145.         }
    146.         Arrays.sort(fractions);
    147.         // 设置边框色
    148.         g2.setColor(Color.GRAY);
    149.         g2.fillRect(0, 0, w, h);
    150.  
    151.         Color c = getRandColor(200, 250);
    152.         // 设置背景色
    153.         g2.setColor(c);
    154.         g2.fillRect(0, 2, w, h - 4);
    155.  
    156.         // 绘制干扰线
    157.         Random random = new Random();
    158.         // 设置线条的颜色
    159.         g2.setColor(getRandColor(160, 200));
    160.         for (int i = 0; i < 20; i++) {
    161.             int x = random.nextInt(w - 1);
    162.             int y = random.nextInt(h - 1);
    163.             int xl = random.nextInt(6) + 1;
    164.             int yl = random.nextInt(12) + 1;
    165.             g2.drawLine(x, y, x + xl + 40, y + yl + 20);
    166.         }
    167.  
    168.         // 添加噪点
    169.         // 噪声率
    170.         float yawpRate = 0.05f;
    171.         int area = (int) (yawpRate * w * h);
    172.         for (int i = 0; i < area; i++) {
    173.             int x = random.nextInt(w);
    174.             int y = random.nextInt(h);
    175.             // 获取随机颜色
    176.             int rgb = getRandomIntColor();
    177.             image.setRGB(x, y, rgb);
    178.         }
    179.         // 添加图片扭曲
    180.         shear(g2, w, h, c);
    181.  
    182.         g2.setColor(getRandColor(100, 160));
    183.         int fontSize = h - 4;
    184.         Font font = new Font("Algerian", Font.ITALIC, fontSize);
    185.         g2.setFont(font);
    186.         char[] chars = code.toCharArray();
    187.         for (int i = 0; i < verifySize; i++) {
    188.             AffineTransform affine = new AffineTransform();
    189.             affine.setToRotation(Math.PI / 4 * rand.nextDouble() * (rand.nextBoolean() ? 1 : -1), (w / verifySize) * i + fontSize / 2, h / 2);
    190.             g2.setTransform(affine);
    191.             g2.drawChars(chars, i, 1, ((w - 10) / verifySize) * i + 5, h / 2 + fontSize / 2 - 10);
    192.         }
    193.  
    194.         g2.dispose();
    195.         ImageIO.write(image, "jpg", os);
    196.     }
    197.  
    198.     /**
    199.      * 随机颜色
    200.      *
    201.      * @param fc
    202.      * @param bc
    203.      * @return
    204.      */
    205.     private static Color getRandColor(int fc, int bc) {
    206.         if (fc > 255) {
    207.             fc = 255;
    208.         }
    209.         if (bc > 255) {
    210.             bc = 255;
    211.         }
    212.         int r = fc + random.nextInt(bc - fc);
    213.         int g = fc + random.nextInt(bc - fc);
    214.         int b = fc + random.nextInt(bc - fc);
    215.         return new Color(r, g, b);
    216.     }
    217.  
    218.     private static int getRandomIntColor() {
    219.         int[] rgb = getRandomRgb();
    220.         int color = 0;
    221.         for (int c : rgb) {
    222.             color = color << 8;
    223.             color = color | c;
    224.         }
    225.         return color;
    226.     }
    227.  
    228.     private static int[] getRandomRgb() {
    229.         int[] rgb = new int[3];
    230.         for (int i = 0; i < 3; i++) {
    231.             rgb[i] = random.nextInt(255);
    232.         }
    233.         return rgb;
    234.     }
    235.  
    236.     private static void shear(Graphics g, int w1, int h1, Color color) {
    237.         shearX(g, w1, h1, color);
    238.         shearY(g, w1, h1, color);
    239.     }
    240.  
    241.     private static void shearX(Graphics g, int w1, int h1, Color color) {
    242.  
    243.         int period = random.nextInt(2);
    244.  
    245.         boolean borderGap = true;
    246.         int frames = 1;
    247.         int phase = random.nextInt(2);
    248.  
    249.         for (int i = 0; i < h1; i++) {
    250.             double d = (double) (period >> 1)
    251.                     * Math.sin((double) i / (double) period
    252.                     + (6.2831853071795862D * (double) phase)
    253.                     / (double) frames);
    254.             g.copyArea(0, i, w1, 1, (int) d, 0);
    255.             if (borderGap) {
    256.                 g.setColor(color);
    257.                 g.drawLine((int) d, i, 0, i);
    258.                 g.drawLine((int) d + w1, i, w1, i);
    259.             }
    260.         }
    261.  
    262.     }
    263.  
    264.     private static void shearY(Graphics g, int w1, int h1, Color color) {
    265.  
    266.         int period = random.nextInt(40) + 10; // 50;
    267.  
    268.         boolean borderGap = true;
    269.         int frames = 20;
    270.         int phase = 7;
    271.         for (int i = 0; i < w1; i++) {
    272.             double d = (double) (period >> 1)
    273.                     * Math.sin((double) i / (double) period
    274.                     + (6.2831853071795862D * (double) phase)
    275.                     / (double) frames);
    276.             g.copyArea(i, 0, 1, h1, 0, (int) d);
    277.             if (borderGap) {
    278.                 g.setColor(color);
    279.                 g.drawLine(i, (int) d, i, 0);
    280.                 g.drawLine(i, (int) d + h1, i, h1);
    281.             }
    282.  
    283.         }
    284.  
    285.     }
    286. }
    287.

    9.SqlSessionFactoryUtils工具类

    1. package com.itheima.Util;
    2.  
    3. import org.apache.ibatis.io.Resources;
    4. import org.apache.ibatis.session.SqlSessionFactory;
    5. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    6.  
    7. import java.io.IOException;
    8. import java.io.InputStream;
    9.  
    10. public class SqlSessionFactoryUtils {
    11.  
    12.     private static SqlSessionFactory sqlSessionFactory;
    13.  
    14.     //静态代码快会随着类的加载二自动执行，并且只执行一次
    15.     static
    16.     {
    17.         String resource = "mybatis-config.xml";//现在在resource根目录下
    18.         InputStream inputStream = null;
    19.         try {
    20.             inputStream = Resources.getResourceAsStream(resource);
    21.         } catch (IOException e) {
    22.             e.printStackTrace();
    23.         }
    24.         sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    25.     }
    26.  
    27.     public static SqlSessionFactory getSqlSessionFactory(){
    28.         return sqlSessionFactory;
    29.     }
    30. }

    10.AddServlet（实现添加）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.pojo.Brand;
    4. import com.itheima.service.BrandService;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8. import javax.servlet.annotation.*;
    9. import java.io.IOException;
    10.  
    11. @WebServlet("/addServlet")
    12. public class AddServlet extends HttpServlet {
    13.     private BrandService service = new BrandService();
    14.  
    15.     @Override
    16.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    17.  
    18.         //解决乱码问题
    19.         request.setCharacterEncoding("UTF-8");
    20.  
    21.         //1.接受表单提交的数据，封装成一个brand对象的数据
    22.         String brandName = request.getParameter("brandName");
    23.         String companyName = request.getParameter("companyName");
    24.         String ordered = request.getParameter("ordered");
    25.         String description = request.getParameter("description");
    26.         String status = request.getParameter("status");
    27.  
    28.         Brand brand = new Brand(null,brandName,companyName,Integer.parseInt(ordered),description,Integer.parseInt(status));
    29.  
    30.  
    31.         //2.调用service添加数据
    32.         service.add(brand);
    33.  
    34.         //3.转发到查询所有的servlet
    35.         request.getRequestDispatcher("/selectAllServlet").forward(request,response);
    36.  
    37.     }
    38.  
    39.     @Override
    40.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    41.         this.doGet(request, response);
    42.     }
    43. }

    11.CheckCodeServlet（实现验证码的添加）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.Util.CheckCodeUtil;
    4.  
    5. import javax.servlet.*;
    6. import javax.servlet.http.*;
    7. import javax.servlet.annotation.*;
    8. import java.io.FileOutputStream;
    9. import java.io.IOException;
    10.  
    11. @WebServlet("/checkCodeServlet")
    12. public class CheckCodeServlet extends HttpServlet {
    13.     @Override
    14.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    15.         //生成验证码
    16.         ServletOutputStream outputStream = response.getOutputStream();
    17.         String checkCode = CheckCodeUtil.outputVerifyImage(100, 50, outputStream, 4);
    18.  
    19.         //把生成的验证码存入到session对象
    20.         HttpSession session = request.getSession();
    21.         session.setAttribute("checkCodeGen",checkCode);
    22.     }
    23.  
    24.     @Override
    25.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    26.         this.doGet(request, response);
    27.     }
    28. }

    12.DeleteServlet（实现删除）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.pojo.Brand;
    4. import com.itheima.service.BrandService;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8. import javax.servlet.annotation.*;
    9. import java.io.IOException;
    10.  
    11. @WebServlet("/deleteServlet")
    12. public class DeleteServlet extends HttpServlet {
    13.     @Override
    14.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    15.  
    16.         //1.传入id
    17.         String id = request.getParameter("id");
    18.  
    19.         //2.调用对象
    20.         BrandService service = new BrandService();
    21.         service.delete(Integer.parseInt(id));
    22.  
    23.         //3.把id传入到delete
    24.         request.setAttribute("id",id);
    25.  
    26.         //3.强求转发到主界面
    27.         request.getRequestDispatcher("/delete.jsp").forward(request,response);
    28.     }
    29.  
    30.     @Override
    31.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    32.         this.doGet(request, response);
    33.     }
    34. }

    13.LoginServlet（实现登录功能）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.pojo.User;
    4. import com.itheima.service.UserService;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8. import javax.servlet.annotation.*;
    9. import java.io.IOException;
    10.  
    11. @WebServlet("/loginServlet")
    12. public class LoginServlet extends HttpServlet {
    13.     @Override
    14.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    15.  
    16.         //1.获取表单传递的参数（实际上和php很类似，接受的表单信息，其实就是input的name属性）
    17.         String username = request.getParameter("username");
    18.         String password = request.getParameter("password");
    19.         //获取复选框数据
    20.         String remember = request.getParameter("remember");
    21.  
    22.         //2.获取UserService的方法来去查询
    23.         UserService service = new UserService();
    24.         User user = service.login(username, password);
    25.  
    26.         //进行条件判断
    27.         if(user != null ){
    28.  
    29.             //判断用户选中了remember,最好写成("1".equals(remember))，以免造成空指针异常
    30.             if("1".equals(remember)){
    31.                 //确定数值等于1
    32.  
    33.                 //1.创建cookie（可以把username当作一个cookie，把另外一个password当作另一个cookie）
    34.                 Cookie c_cookie = new Cookie("username",username);
    35.                 Cookie p_cookie = new Cookie("password",password);
    36.  
    37.                 //1.1设置此cookie在浏览器存活的时间
    38.                 c_cookie.setMaxAge(60*60*24*7);
    39.                 p_cookie.setMaxAge(60*60*24*7);
    40.  
    41.                 //2.发送cookie
    42.                 response.addCookie(c_cookie);
    43.                 response.addCookie(p_cookie);
    44.             }
    45.             //提前打开session
    46.             HttpSession session = request.getSession();
    47.             session.setAttribute("user",user);
    48.  
    49.             //登陆成功，跳转到查询所有的主页面（index.html），否则这个index.html将毫无意义(两个方法，请求转发（有参数），重定向)
    50.             String contextPath = request.getContextPath();//动态获取地址
    51.             response.sendRedirect(contextPath+"/index.html");
    52.         }else{
    53.             //登录失败，提供失败信息，跳转到login.jsp页面，引导客户进行注册
    54.  
    55.             //将错误信息存储到request里面，利用请求转发，来让register.jsp页面显示此错误信息
    56.             request.setAttribute("login_msg","用户名或密码错误,请您重新登录");
    57.             request.getRequestDispatcher("/login.jsp").forward(request,response);
    58.         }
    59.     }
    60.  
    61.     @Override
    62.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    63.         this.doGet(request, response);
    64.     }
    65. }

    14.RegisterServlet（实现注册功能）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.pojo.User;
    4. import com.itheima.service.UserService;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8. import javax.servlet.annotation.*;
    9. import java.io.IOException;
    10.  
    11. @WebServlet("/registerServlet")
    12. public class RegisterServlet extends HttpServlet {
    13.     @Override
    14.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    15.  
    16.         //解决乱码问题
    17.         request.setCharacterEncoding("UTF-8");
    18.  
    19.         //获取表单参数(与用户输入的验证码)
    20.         String username = request.getParameter("username");
    21.         String password = request.getParameter("password");
    22.         String checkCode = request.getParameter("checkCode");
    23.  
    24.         //获取session,把从session获取的checkCodeGen这个值，强转为String，利于之后的比对
    25.         HttpSession session = request.getSession();
    26.         String checkCodeGen = (String)session.getAttribute("checkCodeGen");
    27.  
    28.         User user = new User();
    29.         user.setUsername(username);
    30.         user.setPassword(password);
    31.  
    32.         //验证码的比对（前提是这个checkCode（用户填写的不准为空））
    33.         if(!checkCodeGen.equals(checkCode)){
    34.             //不允许注册
    35.             //如果验证码比对不正确，则就给出提示信息
    36.             request.setAttribute("register_msg", "验证码错误");
    37.             request.getRequestDispatcher("/register.jsp").forward(request, response);
    38.             return;//如果执行到return后，就不会在向下继续执行到mysql了
    39.         }
    40.  
    41.         //调取userService方法完成对数据的添加
    42.         UserService service = new UserService();
    43.         Boolean register = service.register(user);
    44.  
    45.         //判断注册成功与否
    46.         if (username.length()!=0 && password .length()!=0) {
    47.             if (register) {
    48.                 //register为true，则跳转到登录页面（因为还要显示注册成功，请登录的信息，所以使用请求转发比较稳妥）
    49.                 request.setAttribute("register_msg", "注册成功，请登录");
    50.                 request.getRequestDispatcher("/login.jsp").forward(request, response);
    51.  
    52.             } else {
    53.                 //register为false
    54.                 request.setAttribute("register_msg", "用户已经存在，请重新注册");
    55.                 request.getRequestDispatcher("/register.jsp").forward(request, response);
    56.             }
    57.         }else{
    58.             //用户名和密码为空的情况下
    59.             request.setAttribute("error_msg", "账号或密码为空，请重新注册");
    60.             request.getRequestDispatcher("/register.jsp").forward(request, response);
    61.         }
    62.     }
    63.     @Override
    64.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    65.         this.doGet(request, response);
    66.     }
    67. }

    15.SelectAllServlet（实现查找）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.pojo.Brand;
    4. import com.itheima.service.BrandService;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8. import javax.servlet.annotation.*;
    9. import java.io.IOException;
    10. import java.util.List;
    11.  
    12. @WebServlet("/selectAllServlet")
    13. public class SelectAllServlet extends HttpServlet {
    14.     private BrandService service = new BrandService();
    15.  
    16.     @Override
    17.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    18.  
    19.         //调用对应的BrandService完成查询
    20.         List brands = service.selectAll();
    21.  
    22.         //存入request域中
    23.         //void setAttribute（String name，Object o）存储数据到request域中
    24.         request.setAttribute("brands",brands);
    25.  
    26.         //请求转发
    27.         request.getRequestDispatcher("/brand.jsp").forward(request,response);
    28.     }
    29.  
    30.     @Override
    31.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    32.         this.doGet(request, response);
    33.     }
    34. }

    16.SelectByIdServlet（实现回显--update中的模块）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.pojo.Brand;
    4. import com.itheima.service.BrandService;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8. import javax.servlet.annotation.*;
    9. import java.io.IOException;
    10.  
    11.  
    12. @WebServlet("/selectByIdServlet")
    13. public class SelectByIdServlet extends HttpServlet {
    14.     @Override
    15.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    16.  
    17.         //1，在brand.jsp里面传输了一个id，之前在php里面学过，就不在赘述了（接收id）
    18.         String id = request.getParameter("id");
    19.  
    20.         //id有了之后，把这个id传入到SelectById的形参里面去（调用对应的service进行查询）
    21.         BrandService service = new BrandService();
    22.         Brand brand = service.selectById(Integer.parseInt(id));
    23.  
    24.         //储存到request域中
    25.         request.setAttribute("brand",brand);
    26.  
    27.         //转发到update.jsp中
    28.         request.getRequestDispatcher("/update.jsp").forward(request,response);
    29.  
    30.     }
    31.  
    32.     @Override
    33.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    34.         this.doGet(request, response);
    35.     }
    36. }

    17.UpdateServlet（实现更新）

    1. package com.itheima.web;
    2.  
    3. import com.itheima.pojo.Brand;
    4. import com.itheima.service.BrandService;
    5.  
    6. import javax.servlet.*;
    7. import javax.servlet.http.*;
    8. import javax.servlet.annotation.*;
    9. import java.io.IOException;
    10.  
    11. @WebServlet("/updateServlet")
    12. public class UpdateServlet extends HttpServlet {
    13.     @Override
    14.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    15.  
    16.         //解决乱码问题
    17.         request.setCharacterEncoding("UTF-8");
    18.  
    19.         //1.接受表单提交的数据，封装成一个brand对象的数据
    20.         String id = request.getParameter("id");
    21.         String brandName = request.getParameter("brandName");
    22.         String companyName = request.getParameter("companyName");
    23.         String ordered = request.getParameter("ordered");
    24.         String description = request.getParameter("description");
    25.         String status = request.getParameter("status");
    26.  
    27.         Brand brand = new Brand(Integer.parseInt(id),brandName,companyName,Integer.parseInt(ordered),description,Integer.parseInt(status));
    28.  
    29.         //调用service更改数据
    30.         BrandService service = new BrandService();
    31.         service.update(brand);
    32.  
    33.         //3.转发到查询所有的servlet
    34.         request.getRequestDispatcher("/selectAllServlet").forward(request,response);
    35.  
    36.     }
    37.  
    38.     @Override
    39.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    40.         this.doGet(request, response);
    41.     }
    42. }

    18.BrandMapper.xml（Brand映射文件）

    1. "1.0" encoding="UTF-8" ?>
    2. mapper
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="com.itheima.mapper.BrandMapper">
    6.  
    7. <resultMap id="brandResultMap" type="brand">
    8.     <result column="brand_name" property="brandName">result>
    9.     <result column="company_name" property="companyName">result>
    10. resultMap>
    11.  
    12.  
    13.  
    14. mapper>

    19.UserMapper.xml（User映射文件，没有用到）

    20.Mybatis-config.xml（Mybatis实现连接数据库）

    1. "1.0" encoding="UTF-8" ?>
    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    5. <configuration>
    6.     
    7.     <typeAliases>
    8.         <package name="com.itheima.pojo"/>
    9.     typeAliases>
    10.  
    11.     <environments default="development">
    12.         <environment id="development">
    13.             <transactionManager type="JDBC"/>
    14.             <dataSource type="POOLED">
    15.                 <property name="driver" value="com.mysql.jdbc.Driver"/>
    16.                 <property name="url" value="jdbc:mysql:///db1?useSSL=false&useServerPrepStmts=true"/>
    17.                 <property name="username" value="root"/>
    18.                 <property name="password" value="root"/>
    19.             dataSource>
    20.         environment>
    21.     environments>
    22.     <mappers>
    23.         
    24.         <package name="com.itheima.mapper"/>
    25.     mappers>
    26. configuration>

    21.CSS文件（登录注册页面的CSS文件）

    1.login.css

    1. * {
    2.     margin: 0;
    3.     padding: 0;
    4. }
    5.  
    6. html {
    7.     height: 100%;
    8.     width: 100%;
    9.     overflow: hidden;
    10.     margin: 0;
    11.     padding: 0;
    12.     background: url(../imgs/Desert1.jpg) no-repeat 0px 0px;
    13.     background-repeat: no-repeat;
    14.     background-size: 100% 100%;
    15.     -moz-background-size: 100% 100%;
    16. }
    17.  
    18. body {
    19.     display: flex;
    20.     align-items: center;
    21.     justify-content: center;
    22.     height: 100%;
    23. }
    24.  
    25. #loginDiv {
    26.     width: 37%;
    27.     display: flex;
    28.     justify-content: center;
    29.     align-items: center;
    30.     height: 380px;
    31.     background-color: rgba(75, 81, 95, 0.3);
    32.     box-shadow: 7px 7px 17px rgba(52, 56, 66, 0.5);
    33.     border-radius: 5px;
    34. }
    35.  
    36. #name_trip {
    37.     margin-left: 50px;
    38.     color: red;
    39. }
    40.  
    41. p {
    42.     margin-top: 30px;
    43.     margin-left: 20px;
    44.     color: azure;
    45. }
    46.  
    47.  
    48. #remember{
    49.     margin-left: 15px;
    50.     border-radius: 5px;
    51.     border-style: hidden;
    52.     background-color: rgba(216, 191, 216, 0.5);
    53.     outline: none;
    54.     padding-left: 10px;
    55.     height: 20px;
    56.     width: 20px;
    57. }
    58. #username{
    59.     width: 200px;
    60.     margin-left: 15px;
    61.     border-radius: 5px;
    62.     border-style: hidden;
    63.     height: 30px;
    64.     background-color: rgba(216, 191, 216, 0.5);
    65.     outline: none;
    66.     color: #f0edf3;
    67.     padding-left: 10px;
    68. }
    69. #password{
    70.     width: 202px;
    71.     margin-left: 15px;
    72.     border-radius: 5px;
    73.     border-style: hidden;
    74.     height: 30px;
    75.     background-color: rgba(216, 191, 216, 0.5);
    76.     outline: none;
    77.     color: #f0edf3;
    78.     padding-left: 10px;
    79. }
    80. .button {
    81.     border-color: cornsilk;
    82.     background-color: rgba(100, 149, 237, .7);
    83.     color: aliceblue;
    84.     border-style: hidden;
    85.     border-radius: 5px;
    86.     width: 100px;
    87.     height: 31px;
    88.     font-size: 16px;
    89. }
    90.  
    91. #subDiv {
    92.     text-align: center;
    93.     margin-top: 30px;
    94. }
    95. #loginMsg{
    96.     text-align: center;
    97.     color: aliceblue;
    98. }
    99. #errorMsg{
    100.     text-align: center;
    101.     color:red;
    102. }

    2.register.css

    1. * {
    2.     margin: 0;
    3.     padding: 0;
    4.     list-style-type: none;
    5. }
    6. .reg-content{
    7.     padding: 30px;
    8.     margin: 3px;
    9. }
    10. a, img {
    11.     border: 0;
    12. }
    13.  
    14. body {
    15.     background-image: url("../imgs/reg_bg_min.jpg") ;
    16.     text-align: center;
    17. }
    18.  
    19. table {
    20.     border-collapse: collapse;
    21.     border-spacing: 0;
    22. }
    23.  
    24. td, th {
    25.     padding: 0;
    26.     height: 90px;
    27.  
    28. }
    29. .inputs{
    30.     vertical-align: top;
    31. }
    32.  
    33. .clear {
    34.     clear: both;
    35. }
    36.  
    37. .clear:before, .clear:after {
    38.     content: "";
    39.     display: table;
    40. }
    41.  
    42. .clear:after {
    43.     clear: both;
    44. }
    45.  
    46. .form-div {
    47.     background-color: rgba(255, 255, 255, 0.27);
    48.     border-radius: 10px;
    49.     border: 1px solid #aaa;
    50.     width: 424px;
    51.     margin-top: 150px;
    52.     margin-left:1050px;
    53.     padding: 30px 0 20px 0px;
    54.     font-size: 16px;
    55.     box-shadow: inset 0px 0px 10px rgba(255, 255, 255, 0.5), 0px 0px 15px rgba(75, 75, 75, 0.3);
    56.     text-align: left;
    57. }
    58.  
    59. .form-div input[type="text"], .form-div input[type="password"], .form-div input[type="email"] {
    60.     width: 268px;
    61.     margin: 10px;
    62.     line-height: 20px;
    63.     font-size: 16px;
    64. }
    65.  
    66. .form-div input[type="checkbox"] {
    67.     margin: 20px 0 20px 10px;
    68. }
    69.  
    70. .form-div input[type="button"], .form-div input[type="submit"] {
    71.     margin: 10px 20px 0 0;
    72. }
    73.  
    74. .form-div table {
    75.     margin: 0 auto;
    76.     text-align: right;
    77.     color: rgba(64, 64, 64, 1.00);
    78. }
    79.  
    80. .form-div table img {
    81.     vertical-align: middle;
    82.     margin: 0 0 5px 0;
    83. }
    84.  
    85. .footer {
    86.     color: rgba(64, 64, 64, 1.00);
    87.     font-size: 12px;
    88.     margin-top: 30px;
    89. }
    90.  
    91. .form-div .buttons {
    92.     float: right;
    93. }
    94.  
    95. input[type="text"], input[type="password"], input[type="email"] {
    96.     border-radius: 8px;
    97.     box-shadow: inset 0 2px 5px #eee;
    98.     padding: 10px;
    99.     border: 1px solid #D4D4D4;
    100.     color: #333333;
    101.     margin-top: 5px;
    102. }
    103.  
    104. input[type="text"]:focus, input[type="password"]:focus, input[type="email"]:focus {
    105.     border: 1px solid #50afeb;
    106.     outline: none;
    107. }
    108.  
    109. input[type="button"], input[type="submit"] {
    110.     padding: 7px 15px;
    111.     background-color: #3c6db0;
    112.     text-align: center;
    113.     border-radius: 5px;
    114.     overflow: hidden;
    115.     min-width: 80px;
    116.     border: none;
    117.     color: #FFF;
    118.     box-shadow: 1px 1px 1px rgba(75, 75, 75, 0.3);
    119. }
    120.  
    121. input[type="button"]:hover, input[type="submit"]:hover {
    122.     background-color: #5a88c8;
    123. }
    124.  
    125. input[type="button"]:active, input[type="submit"]:active {
    126.     background-color: #5a88c8;
    127. }
    128. .err_msg{
    129.     color: red;
    130.     padding-right: 170px;
    131. }
    132. #password_err,#tel_err{
    133.     padding-right: 195px;
    134. }
    135.  
    136. #reg_btn{
    137.     margin-right:50px; width: 285px; height: 45px; margin-top:20px;
    138. }
    139.  
    140. #checkCode{
    141.     width: 100px;
    142. }
    143.  
    144. #changeImg{
    145.     color: aqua;
    146. }

    22.IMG文件（登陆注册的IMG文件）

    1.a.jpg

    2.Desert1.jpg

    3.reg_bg_min.jpg

    23.addBrand.jsp（显示添加页面）

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2.  
    3. <html>
    4.  
    5. <head>
    6.     <meta charset="UTF-8">
    7.     <title>添加品牌title>
    8. head>
    9. <body>
    10. <h3>添加品牌h3>
    11. <form action="/brand_demo/addServlet" method="post">
    12.     品牌名称：<input type="text" name="brandName"><br>
    13.     企业名称：<input type="text" name="companyName"><br>
    14.     排序：   <input type="text" name="ordered"><br>
    15.     描述信息：<textarea rows="5" cols="3" name="description">textarea><br>
    16.     状态：
    17.             <input type="radio" name="status"value="0">禁用
    18.             <input type="radio" name="status"value="1">启用<br>
    19.  
    20.     <input type="submit" value="提交">
    21. form>
    22. body>
    23. html>

    24.brand.jsp（实现查找的页面）

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    3. <html>
    4. <script>
    5.     function add(){
    6.         let flag = window.confirm("您确定要添加数据吗？");
    7.         if (flag==true){
    8.             window.location="/brand_demo/addBrand.jsp";
    9.         }else{
    10.             window.location="/brand_demo/brand.jsp";
    11.         }
    12.     }
    13.     function del(){
    14.         let flag = window.confirm("您确定要删除数据吗？");
    15.         if (flag==true){
    16.             window.location="/brand_demo/brand.jsp";
    17.         }else{
    18.             return 0;
    19.         }
    20.     }
    21. script>
    22. <head>
    23.     <title>Titletitle>
    24. head>
    25. <body>
    26. <center>
    27. <h1>欢迎${user.username}访问阿里云数据库h1>
    28. <input type="button" value="添加数据" onclick="add()">
    29. <hr>
    30. <table border="1" cellspacing="0" width="800">
    31.     <tr>
    32.         <th>序号th>
    33.         <th>品牌名称th>
    34.         <th>企业名称th>
    35.         <th>排序th>
    36.         <th>品牌介绍th>
    37.         <th>状态th>
    38.         <th>操作th>
    39.  
    40.     tr>
    41.     <c:forEach items="${brands}" var="brand" varStatus="status">
    42.         <tr align="center">
    43.                 <%--        <td>${brand.id}td>--%>
    44.             <td>${status.count}td>
    45.             <td>${brand.brandName}td>
    46.             <td>${brand.companyName}td>
    47.             <td>${brand.ordered}td>
    48.             <td>${brand.description}td>
    49.             <c:if test="${brand.status == 0 }">
    50.                 <td>禁用td>
    51.             c:if>
    52.             <c:if test="${brand.status == 1 }">
    53.                 <td>启用td>
    54.             c:if>
    55.             <td><a href="/brand_demo/selectByIdServlet?id=${brand.id}">修改a>/
    56.                 <a href="/brand_demo/deleteServlet?id=${brand.id}" onclick="del()">删除a>td>
    57.         tr>
    58.     c:forEach>
    59. table>
    60. center>
    61. body>
    62. html>

    25.delete.jsp（实现删除的页面）

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: HP
    4.   Date: 2022/8/21
    5.   Time: 16:05
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <html>
    10. <script>
    11.     function del(){
    12.         let flag = window.confirm("您确定要返回主页面吗？");
    13.         if (flag=true){
    14.             window.location="/brand_demo/selectAllServlet";
    15.         }
    16.     }
    17. script>
    18. <head>
    19.     <title>Deletetitle>
    20. head>
    21. <body>
    22. <center>
    23.     <h1>提醒您！！<br>
    24.         已经删除了id为${id}的数据h1>
    25.     <input type="button"value="返回主页面"onclick="del()">
    26. center>
    27. body>
    28. html>

    26.index.html（主页面，显示brand.jsp的链接）

    1. html>
    2. <html lang="en">
    3. <head>
    4.     <meta charset="UTF-8">
    5.     <title>Titletitle>
    6. head>
    7. <body>
    8. <center>
    9.     <h2>h2>
    10.     <h1> 欢迎访问h1>
    11.     <a href="/brand_demo/selectAllServlet" >点击查询所有数据库数据a>
    12. center>
    13. body>
    14. html>

    27.login.jsp（实现登录的页面）

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. html>
    3. <html lang="en">
    4.  
    5. <head>
    6.     <meta charset="UTF-8">
    7.     <title>logintitle>
    8.     <link href="css/login.css" rel="stylesheet">
    9. head>
    10.  
    11. <body>
    12. <div id="loginDiv" style="height: 350px">
    13. <%--action一般指向处理这个页面的servlet，当点击submit的时候，就会把表单里面面的变量，提交到对应的servlet里面去--%>
    14.     <form action="/brand_demo/loginServlet" id="form">
    15.         <h1 id="loginMsg">LOGIN INh1>
    16.         <div id="errorMsg">${login_msg}${register_msg}div>
    17.         <p>Username:<input id="username" name="username" type="text" value="${cookie.username.value}">p>
    18.         <p>Password:<input id="password" name="password" type="password" value="${cookie.password.value}">p>
    19.         <p>Remember:<input id="remember" value="1" name="remember" type="checkbox">p>
    20.         <div id="subDiv">
    21.             <input type="submit" class="button" value="login up">
    22.             <input type="reset" class="button" value="reset">   
    23.             <a href="register.jsp">没有账号？a>
    24.         div>
    25.     form>
    26. div>
    27.  
    28. body>
    29. html>

    28.register.jsp（实现注册的页面）

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. html>
    3. <html lang="en">
    4. <head>
    5.     <meta charset="UTF-8">
    6.     <title>欢迎注册title>
    7.     <link href="css/register.css" rel="stylesheet">
    8. head>
    9. <body>
    10.  
    11. <div class="form-div">
    12.     <div class="reg-content">
    13.         <h1>欢迎注册h1>
    14.         <span>已有帐号？span> <a href="login.html">登录a>
    15.     div>
    16.     <form id="reg-form" action="/brand_demo/registerServlet" method="post">
    17.         <table>
    18.             <tr>
    19.                 <td>用户名td>
    20.                 <td class="inputs">
    21.                     <input name="username" type="text" id="username">
    22.                     <br>
    23.                     <span id="username_err" class="err_msg" >${register_msg}${error_msg}span>
    24.                 td>
    25.             tr>
    26.             <tr>
    27.                 <td>密码td>
    28.                 <td class="inputs">
    29.                     <input name="password" type="password" id="password">
    30.                     <br>
    31.                     <span id="password_err" class="err_msg" style="display: none">密码格式有误span>
    32.                 td>
    33.             tr>
    34.             <tr>
    35.                 <td>验证码td>
    36.                 <td class="inputs">
    37.                     <input name="checkCode" type="text" id="checkCode">
    38.                     <img id="CheckCodeImage" src="/brand_demo/checkCodeServlet" onclick="check()">
    39.                     <a href="#" id="changeImg" onclick="check()">看不清？a>
    40.                 td>
    41.             tr>
    42.         table>
    43.         <div class="buttons">
    44.             <input value="注 册" type="submit" id="reg_btn">
    45.         div>
    46.         <br class="clear">
    47.     form>
    48.  
    49. div>
    50. <script>
    51.     function check(){
    52.         // 利用时间来当作参数来获取图片
    53.         let milliseconds = new Date().getMilliseconds();//获取当前时间的毫米值
    54.         document.getElementById("CheckCodeImage").src = "/brand_demo/checkCodeServlet?"+milliseconds;
    55.     }
    56. script>
    57. body>
    58. html>

    29.update.jsp（显示更新的界面）

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
    3. <html>
    4. <head>
    5.     <title>修改数据title>
    6. head>
    7. <body>
    8. <h3>回显数据，修改数据h3>
    9. <h3>可以封装成一个brand的数据，然后利用el表达式来回显数据h3>
    10. <form action="/brand_demo/updateServlet" method="post">
    11. <%--    隐藏域--%>
    12.     <input type="hidden" name="id" value="${brand.id}">
    13.     品牌名称：<input type="text" name="brandName"  value="${brand.brandName}"><br>
    14.     企业名称：<input type="text" name="companyName"value="${brand.companyName}"><br>
    15.     排序：   <input type="text" name="ordered" value="${brand.ordered}"><br>
    16.     描述信息：<textarea rows="10" cols="3" name="description" >${brand.description}textarea><br>
    17.     状态：
    18.     <c:if test="${brand.status == 0}">
    19.         <input type="radio" name="status"value="0" checked >禁用
    20.         <input type="radio" name="status"value="1">启用<br>
    21.     c:if>
    22.     <c:if test="${brand.status == 1}">
    23.         <input type="radio" name="status"value="0"  >禁用
    24.         <input type="radio" name="status"value="1" checked>启用<br>
    25.     c:if>
    26.     <input type="submit" value="提交">
    27. form>
    28.  
    29. body>
    30. html>

    30.pom文件（存储的关于Java的一些依赖）

    1. "1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0modelVersion>
    6.  
    7.     <groupId>org.examplegroupId>
    8.     <artifactId>brand_demoartifactId>
    9.     <version>1.0-SNAPSHOTversion>
    10.  
    11.     <properties>
    12.         <maven.compiler.source>18maven.compiler.source>
    13.         <maven.compiler.target>18maven.compiler.target>
    14.     properties>
    15.  
    16.     <packaging>warpackaging>
    17.  
    18.     <build>
    19.         <plugins>
    20.             
    21.             <plugin>
    22.                 <groupId>org.apache.tomcat.mavengroupId>
    23.                 <artifactId>tomcat7-maven-pluginartifactId>
    24.                 <version>2.2version>
    25.             plugin>
    26.             <plugin>
    27.                 <groupId>org.apache.maven.pluginsgroupId>
    28.                 <artifactId>maven-compiler-pluginartifactId>
    29.                 <configuration>
    30.                     <source>17source>
    31.                     <target>17target>
    32.                 configuration>
    33.             plugin>
    34.         plugins>
    35.     build>
    36.  
    37.     <dependencies>
    38.         <dependency>
    39.             <groupId>javax.servletgroupId>
    40.             <artifactId>javax.servlet-apiartifactId>
    41.             <version>3.1.0version>
    42.             <scope>providedscope>
    43.         dependency>
    44.         
    45.         <dependency>
    46.             <groupId>commons-iogroupId>
    47.             <artifactId>commons-ioartifactId>
    48.             <version>2.6version>
    49.         dependency>
    50.         
    51.         <dependency>
    52.             <groupId>org.mybatisgroupId>
    53.             <artifactId>mybatisartifactId>
    54.             <version>3.5.5version>
    55.         dependency>
    56.         
    57.         <dependency>
    58.             <groupId>mysqlgroupId>
    59.             <artifactId>mysql-connector-javaartifactId>
    60.             <version>8.0.29version>
    61.         dependency>
    62.         
    63.         <dependency>
    64.             <groupId>junitgroupId>
    65.             <artifactId>junitartifactId>
    66.             <version>4.13.2version>
    67.             <scope>Testscope>
    68.         dependency>
    69.         
    70.         <dependency>
    71.             <groupId>org.slf4jgroupId>
    72.             <artifactId>slf4j-apiartifactId>
    73.             <version>1.7.36version>
    74.         dependency>
    75.         
    76.         <dependency>
    77.             <groupId>ch.qos.logbackgroupId>
    78.             <artifactId>logback-classicartifactId>
    79.             <version>1.2.3version>
    80.         dependency>
    81.         
    82.         <dependency>
    83.             <groupId>ch.qos.logbackgroupId>
    84.             <artifactId>logback-coreartifactId>
    85.             <version>1.2.3version>
    86.         dependency>
    87.         <dependency>
    88.             <groupId>jstlgroupId>
    89.             <artifactId>jstlartifactId>
    90.             <version>1.2version>
    91.         dependency>
    92.         <dependency>
    93.             <groupId>taglibsgroupId>
    94.             <artifactId>standardartifactId>
    95.             <version>1.1.2version>
    96.         dependency>
    97.     dependencies>
    98. project>

    31.展示页面

    (算了，不想展示了，如果有哪位朋友愿意来看的话，给我留言我私信给你)

  • 相关阅读:
    ORB_SLAM3 判断关键帧与创建关键帧
    Vim实用技巧_7.模式匹配和查找
    【21天学习挑战赛—Java编程进阶之路】(6)
    JAVA_SSM+VUE校园二手物品交易平台(含论文)源码
    【自然语言处理】seq2seq模型—机器翻译
    cleanmymacX4.14免费版mac清除浏览器缓存软件
    向毕业妥协系列之机器学习笔记:监督学习-回归与分类（一）
    mysql与磁盘的关系
    MATLAB学习笔记（系统学习）
    使用GD32F207的高级定时器来产生PWM波出现的隐藏BUG
  • 原文地址：https://blog.csdn.net/qq_51272114/article/details/126527074