使用阿里云数据连接池来完成JDBC连接数据库和登录注册功能

最新推荐文章于 2023-12-04 18:45:56 发布

原创

最新推荐文章于 2023-12-04 18:45:56 发布 · 434 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #mysql

本文介绍了如何使用阿里云数据连接池完成JDBC与MySQL数据库的连接，实现登录和注册功能。涵盖了从项目功能描述到各个功能模块的详细实现，包括User类、UserDaoImpl、UserServiceImpl的MD5加密加盐处理，JDBCUtil类的数据库操作，Login类的登录验证，Insert类的注册功能，以及GetCode类的验证码生成。同时，还展示了登录、注册和主页的前端页面设计。

一，项目的功能

二，数据库代码

create table t_user(
uid int(11) primary key not null auto_increment,
uname varchar(20),
pwd varchar(200),
realname varchar(20),
sex varchar(11),
address varchar(50),
userimg varchar(200),
salt varchar(200)
);
select*from t_user where uname='西红柿鸡蛋' and pwd='111';
insert into t_user(uname,pwd,realname,sex,address,userimg) values('西红柿鸡蛋','111','张三','男','河南','rqerqerw');
insert into t_user(uname,pwd,realname,sex,address,userimg) values('111','222','333','444','555','666');

三，创建项目，项目源码

1.bean层

User类

package com.wang.bean;

public class User {
    private Integer uid;
    private String uname;
    private String pwd;
    private String realname;
    private String sex;
    private String address;
    private String userimg;
    private String salt;

    public String getSalt() {
        return salt;
    }

    public void setSalt(String salt) {
        this.salt = salt;
    }

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public String getUname() {
        return uname;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    public String getRealname() {
        return realname;
    }

    public void setRealname(String realname) {
        this.realname = realname;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getUserimg() {
        return userimg;
    }

    public void setUserimg(String userimg) {
        this.userimg = userimg;
    }

    @Override
    public String toString() {
        return "User{" +
                "uid=" + uid +
                ", uname='" + uname + '\'' +
                ", pwd='" + pwd + '\'' +
                ", realname='" + realname + '\'' +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                ", userimg='" + userimg + '\'' +
                ", salt='" + salt + '\'' +
                '}';
    }
}

2.dao层

UserDao

package com.wang.dao;

import com.wang.bean.User;

import java.sql.SQLException;

public interface UserDao {
    User login(String uname) throws SQLException;
    User insert(User user) throws SQLException;
}

impl包UserDaoImpl类

package com.wang.dao.impl;

import com.wang.bean.User;
import com.wang.dao.UserDao;
import com.wang.util.JDBCUtil;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import java.sql.Connection;
import java.sql.SQLException;

public class UserDaoImpl implements UserDao {
    private QueryRunner queryRunner=new QueryRunner();
    private Connection con= JDBCUtil.getCon();
    private

最低0.47元/天解锁文章