连接数据库，使用数据库

public class Conn {
    Connection cn = null;
    public Connection getConn() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://127.0.0.1:3306/store";
            String user = "root";
            String password = "123456";
            cn = DriverManager.getConnection(url, user, password);
            System.out.println("数据库连接成功");
        } catch (Exception e) {
            System.out.println("数据库连接失败");
        }
        return cn;
    }

}

Connection conn = DriverManager.getConnection("","","");

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select s.* from xxx where xxx");

while(rs.next()){

System.out.println(rs.getInt(1) + "\t" + rs.getString(2) + "\t")

execute 方法返回Boolean值

PrepareStatement 是Statement接口的子接口，可以预编译SQL语句，更加高效的执行

结构基本相似，只是插入的至不同，可以使用占位符

登录的时候：try(Connection conn = DriverManager.getConnection(xxx,xxx,xxx);PerparedStatement pstmt = conn.prepareStatemnt("select * from xxx where name = ? and mima =?"))

{

pstmt.setString(1,userName);

pstmt.setString(2,userPass);

try(ResultSet rs = pstmt.exeuteQuery()){

if(rs.next())

    return ture;

}

catch(Exception e){

e.printStackTrace();}

return false;