JDBC登录基础版

先创建数据表

#创建User
CREATE TABLE `user`(
	`id` INT PRIMARY KEY AUTO_INCREMENT,
	`username` VARCHAR(20) NOT NULL,
	`password` VARCHAR(16) NOT NULL,
	`email` VARCHAR(30),
	`phone` VARCHAR(20) 
);
INSERT INTO `user`(id,username,PASSWORD,email,phone) VALUES(NULL,'zhangsan','888','zhangsan@qq.com','110');
INSERT INTO `user`(id,username,PASSWORD,email,phone) VALUES(NULL,'shushu','666','zhangsan@qq.com','120');

登录Demo实现代码

package com.hqy;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;

public class LoginDemo {
    //基础版（不安全，可以sql注入）
    public static void main(String[] args)throws Exception  {
        System.out.println("------------欢迎访问----------------");
        Scanner sc = new Scanner(System.in);
        System.out.println("请输入用户名：");
        String username = sc.next();
        System.out.println("请输入密码");
        String password = sc.next();

        //调用数据库方法
        login(username, password);
    }

    //数据库方法
    public static void login(String username,String password)throws Exception {
        //连接数据库检查用户名和密码是否正确
        //注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //获取连接
        String url = "jdbc:mysql://localhost:3306/myhqy2?characterEncoding=utf8&useSSL=false";
        Connection coon = DriverManager.getConnection(url, "root", "123456");
        //创建命令
        Statement state = coon.createStatement();
        //查询
        ResultSet rs = state.executeQuery("select * from user where username='" + username + "' and password = '" + password + "'");
        if(rs.next()){
            System.out.println("登陆成功");
        }else{
            System.out.println("用户名或密码不正确，登录失败");
        }
        //关闭
        rs.close();
        state.close();
        coon.close();
    }
}