spring学习之jdbc

创建jdbc基本步骤

public static void main(String[] args) throws SQLException {
        Connection con=null;
        //注册驱动
		DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        try {
			
            //反射
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        //连接数据库

        try {
            con = DriverManager.getConnection("jdbc:mysql:///test?characterEncoding=UTF-8", "root", "Cyp123..");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //获取操作对象
        Statement statement =con.createStatement();
        //编写sql
        String sql ="select *from comment";
        //执行sql,获取数据
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()){
            System.out.println("tx_img:"+resultSet.getObject("tx_img"));
        }
        //释放资源
        resultSet.close();
        statement.close();
        con.close();


    }