JDBC控制台检验登录(代码)

最新推荐文章于 2024-06-14 21:59:15 发布

原创最新推荐文章于 2024-06-14 21:59:15 发布 · 640 阅读

CC 4.0 BY-SA版权

本文介绍了一个使用Java JDBC实现的简单用户登录系统的示例代码。该系统通过MySQL数据库进行用户验证，演示了如何连接数据库、执行SQL查询及处理用户输入。

package jdbcwork;

import sun.applet.Main;
import util.MD5Util;

import java.sql.*;
import java.util.Scanner;

public class Login {
    public static void main(String[] args) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet set = null;
        MD5Util md5Util=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://127.0.0.1:3306/scor?characterEncoding=utf-8&useSSL=false";
            String user = "root";
            String password = "12345";
            try {
                connection = DriverManager.getConnection(url, user, password);
                System.out.println("请输入你的编号:");
                String id=new Scanner(System.in).next();
                String sql="select *from users where uid="+id+"";
                preparedStatement=connection.prepareStatement(sql);
                set=preparedStatement.executeQuery();
                if(set.next())
                {
                    System.out.println("请输入你的密码");
                    String pwd=new Scanner(System.in).next();
                    //System.out.println(md5Util.MD5(pwd));
                    String password2=set.getString("pwd");
                    //System.out.println(password2);
                    String username=set.getString("username");

                    if(md5Util.MD5(pwd).equalsIgnoreCase(password2))
                    {
                        System.out.println("登录成功,欢迎"+username+"回来");
                    }else
                    {
                        System.out.println("请检查密码是否正确");
                    }
                }else
                {
                    System.out.println("请检查你的id是否正确");
                }


            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            try {
                preparedStatement.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            try {
                connection.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

    }
}