jdbc存储过程 使用PreparedStatement执行mysql存储过

[java]代码库

      private static void doStatistics(PublicSentimentLite psl) throws SQLException,
            InstantiationException, IllegalAccessException, ClassNotFoundException {
        Connection con = null;
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            con = DriverManager.getConnection(ConfigLoader.getConnString(),
                    ConfigLoader.getDatabaseUser(), ConfigLoader.getDatabasePassword());

            String sql = "CALL proc_nstatistics_update_by_ps(?,?,?,?,?)";
            PreparedStatement pstmt = con.prepareStatement(sql);
            pstmt.setString(0, psl.getCategoryCode());
            pstmt.setDate(1, new java.sql.Date(psl.getPublishTime().getTime()));
            pstmt.setInt(2, psl.getAttribute());
            pstmt.setString(3, psl.getMediaType());

        } finally {
            if (con != null) {
                con.close();
            }
        }
    }
//源代码片段来自云代码http://yuncode.net