连接MySQL的简单注册实例

JDBCUtils.java

import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;

public class JDBCUtils {
    private static String url;
    private static String user;
    private static String password;
    private static String driver;

    //读取文件，只需读取一次即可拿到这些值，使用静态代码块
    static {
        try{
            //1.创建Properties集合类
            Properties pro= new Properties();
            //获取src路径下文件-->ClassLoader类加载器
            ClassLoader classLoader = JDBCUtils.class.getClassLoader();
            URL res= classLoader.getResource("jdbc.properties");
            String path = res.getPath();
            System.out.println(path);

            //2.加载文件
            pro.load(new FileReader(path));

            //3.获取数据，赋值
            url = pro.getProperty("url");
            user = pro.getProperty("user");
            password = pro.getProperty("password");
            driver = pro.getProperty("driver");

            //4.注册驱动
            Class.forName(driver);
        }catch (IOException e){
            e.printStackTrace();
        }catch (ClassNotFoundException el){
            el.printStackTrace();
        }
    }

    //连接
    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url,user,password);
    }

    //释放资源
    public static void close(ResultSet rs, Statement stmt, Connection conn) throws SQLException {
        if(rs!=null){
            rs.close();
        }
        if(stmt!=null){
            stmt.close();
        }
        if(conn!=null){
            conn.close();
        }
    }

    public static void close(Statement stmt, Connection conn) throws SQLException {
        if(stmt!=null){
            stmt.close();
        }
        if(conn!=null){
            conn.close();
        }
    }
}

jdbc_test.java

public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Scanner sc=new Scanner(System.in);
        System.out.println("请输入用户名：");
        String username=sc.nextLine();

        //注册调用方法(确保用户名不重复)
        boolean flag1 = new jdbc_test().zhuce_1(username);
        while(flag1){
            System.out.println("用户已存在，请重新输入！");
            System.out.println("请输入用户名：");
            username=sc.nextLine();
            flag1 = new jdbc_test().zhuce_1(username);
        }

        System.out.println("请输入密码：");
        String password = sc.nextLine();

        boolean flag2 = new jdbc_test().zhuce_2(username,password);
        if(flag2){
            System.out.println("注册成功！");
        }else {
            System.out.println("注册失败！");
        }
	}
    
public boolean zhuce_1(String username) throws SQLException {
        if(username == null){
            return true;
        }
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try{
            conn = JDBCUtils.getConnection();
            String sql = "select * from user where name='"+username+"'";
            stmt = conn.createStatement();
            rs=stmt.executeQuery(sql);
            return rs.next();
        }catch (SQLException e){
            e.printStackTrace();
        }finally {
            JDBCUtils.close(rs,stmt,conn);
        }
        return false;
	}

public boolean zhuce_2(String username,String password) throws SQLException {
        if(password == null){
            return false;
        }
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try{
            conn = JDBCUtils.getConnection();
            String sql = "INSERT into user (name,password) VALUES('"+username+"','"+password+"')";
            stmt = conn.createStatement();
            if(stmt.executeUpdate(sql)>=1){
                return true;
            }
        }catch (SQLException e){
            e.printStackTrace();
        }finally {
            JDBCUtils.close(rs,stmt,conn);
        }
        return false;
    }