54-PreparedStatement使用

PreparedStatement使用

PreparedStatement特别好用
good good 



    public static void main(String[] args) {

        try {
            //加载驱动类
            Class.forName("com.mysql.jdbc.Driver");
            //地址
            String url = "jdbc:mysql://localhost:3306/abc?useSSL=false";
            //账号和密码
            String username = "root";
            String password = "123";

            //连接数据库
            Connection connection = DriverManager.getConnection(url, username, password);

            //来一条sql语句
            String sql = "select * from tb_teacher where name = ?";

            //获取statement对象
            PreparedStatement statement = connection.prepareStatement(sql);

            //设置参数替换?号
            statement.setString(1, "abc");

            //查询,返回结果集
            ResultSet resultSet = statement.executeQuery();

            //遍历结果集
            while (resultSet.next()) {
                String name = resultSet.getString("name");
                String number = resultSet.getString("number");
                System.out.println("" + name + "..." + number);
            }

            //最后要关闭set,statement,connection
            resultSet.close();
            statement.close();
            connection.close();

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }