1.4 JDBC "连接"Mysql 数据库 >我的程序猿之路： 第四章

public class hh {
    public static void main(String[] args) {
        try {
            hh.getsqlConn();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    public static void getsqlConn() throws Exception {
        // 加载驱动
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        // 建立连接
        Connection conn = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/fan", "root", "123");
        //创建语句
        Statement sm= conn.createStatement();
        //执行语句
        ResultSet rs = sm.executeQuery("Select * from user");
        while(rs.next()){
            System.out.println(rs.getObject(2));
        }
        rs.close();
        sm.close();
        conn.close();
        
    }

}