实习笔记 java之jdbc(mysql)

jdbc封装工具类

public class DBUntil {
    //jdbc:mysql:localhost:端口号:数据库名?一些编码规则
    private static final String URL = "jdbc:mysql://127.0.0.1:3306/qm?useUnicode=true&characterEncoding=utf-8";
    //数据库账号密码
    private static final String USER = "root";
    private static final String PASSWORD = "123";

    private static Connection conn = null;

    public static void loadDriver() {
        try {
            //注册驱动
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            System.out.println("加载失败");
        }
    }

    //返回的类型为Connection
    public static Connection getConnection() {
        try {
            //1.注册驱动
            loadDriver();
            //2.获得数据库的连接
            conn = DriverManager.getConnection(URL, USER, PASSWORD);
        } catch (Exception e) {
            System.out.println("连接出现问题");
        }
        return conn;
    }

    //释放资源
    public static void release(Statement statement, Connection conn) {
        if (statement != null) {
            try {
                statement.close();
            } catch (Exception e) {
                e.getStackTrace();
            }
            statement = null;
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (Exception e) {
                e.getStackTrace();
            }
            conn = null;
        }
    }

    public static void release(ResultSet rs, Statement statement, Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch (Exception e) {
                e.getStackTrace();
            }
        }
        if (statement != null) {
            try {
                statement.close();
            } catch (Exception e) {
                e.getStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (Exception e) {
                e.getStackTrace();
            }
        }
    }
}

一些小知识

控制台监听回车

while (true) {
                System.out.println("按下回车返回主菜单");
                Scanner getEnter = new Scanner(System.in);
                String isEnter = getEnter.nextLine();
                if (isEnter.equals("")){
                    break;
                }
            }

jdbc模糊查询时where是变量

//给变量加上%
mailList.setName("%" + name + "%");
//用+连接变量
String sql = "SELECT * FROM maillist where name like " + "'" + mailList.getName() + "'";