java连接数据库 实现用户登录 进行增删改查操作

java连接mysql数据库 实现用户登录 进行增删改查操作

工具类

package com.nara.util;

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

public class JdbcUtil {
   

    private JdbcUtil(){
   }
    static  Connection conn=null;
    static final String DRIVER_NAME="com.mysql.jdbc.Driver";

    static final String URL="jdbc:mysql://localhost:3306/kk";
    static final String USER="root";
    static final String PASS="1234";

    //为了方便使用,定义成静态方法,不需要new,只需要类名.方法 调用就可
    public static Connection getConn()  {
   
            try {
   
                Class.forName(DRIVER_NAME);
                conn = DriverManager.getConnection(URL, USER, PASS);
            } catch (ClassNotFoundException e) {
   
                e.printStackTrace();
            } catch (SQLException e) {
   
                e.printStackTrace();
            }
        return conn;
    }
}

方法类

写登录\增\删\改\查的方法

package com.nara.demo;

import com.nara.util.JdbcUtil;
import java.sql.*;
import java.util.Scanner;

public class Demo1 {
   
    Connection conn;
    PreparedStatement pt;
    ResultSet rs;

    Scanner sc = new Scanner(System.in);

    //登录
    public boolean login() throws SQLException {
   
       conn = JdbcUtil.getConn();
        // 获取用户输入
        System.out.println("~v~登录~v~");

            System.out.print("请输入用户名:");
            String name = sc.nextLine();
            System.out.print("请输入密码:");
            String pass = sc.nextLine();
            pt = conn.prepareStatement("select * from user where name=? and password=?");