JDBC使用

public class JDBCDEMO1 {
    public static void main(String[] args) throws Exception {
        //1 加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2用户信息  url
        String url ="jdbc:mysql://localhost:3306/test?    useUnicode=true&characterEncoding=utf8&useSSL=false";
        String username = "root";
        String password = "root";
        //3连接成功  返回数据库对象 connection
        Connection connection =DriverManager.getConnection(url,username,password);
        //4执行sql对象 statement
        Statement statement  = connection.createStatement();
        String sql = "SELECT * FROM `student`";
        //执行sql 返回结果集合
        ResultSet resultSet = statement.executeQuery(sql);
        //遍历 resultSet
        while (resultSet.next()){
            System.out.print("ID:"+resultSet.getObject("sid")+"\t");
            System.out.print("name:"+resultSet.getObject("name")+"\t");
            System.out.print("age:"+resultSet.getObject("sage")+"\t");
            System.out.print("sex:"+resultSet.getObject("sex")+"\t");
            System.out.print("更新时间:"+resultSet.getObject("UPDATE_TIME")+"\t");
            System.out.print("年级:"+resultSet.getObject("grade")+"\t");
            System.out.print("地址:"+resultSet.getObject("sadd")+"\n");
        }

        //释放连接
        resultSet.close();
        statement.close();
        connection.close();
    }
}

终于连到数据库了