C3P0方法中fanh类型转换

来源:互联网 发布:啪啪啪软件下载 编辑:程序博客网 时间:2024/04/30 06:41
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:14px;"><strong>C3P0实现类中的方法:</strong></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:14px;"><strong>public long getTotalBookNumber(CriteriaBook cb) {</strong></span></span>
<span style="font-size:14px;"><strong>String sql = "select count(book_id) FROM book_table WHERE price >= ? AND price <= ?";return Integer.parseInt(String.valueOf(getSingleVal(sql, cb.getMinPrice(), cb.getMaxPrice())));}</strong></span>
<span style="background-color: rgb(204, 204, 204);"><span style="font-size:14px;"><strong>此方法查询数据库中price在minPrice - maxPrice之间的数据记录数,返回类型是Object</strong></span></span>
<p style="margin-top: 0px; margin-bottom: 5px; padding-top: 0px; padding-bottom: 0px; border: 0px; list-style: none; word-wrap: normal; word-break: normal; line-height: 21px; font-family: simsun;"><span style="background-color: rgb(204, 204, 204);"><span style="font-size:14px;"><strong>Object value=null;</strong></span></span></p><p style="margin-top: 0px; margin-bottom: 5px; padding-top: 0px; padding-bottom: 0px; border: 0px; list-style: none; word-wrap: normal; word-break: normal; line-height: 21px; font-family: simsun;"><span style="background-color: rgb(204, 204, 204);"><span style="font-size:14px;"><strong>Integer.parseInt(String.valueOf(value));</strong></span></span></p><p style="margin-top: 0px; margin-bottom: 5px; padding-top: 0px; padding-bottom: 0px; border: 0px; list-style: none; word-wrap: normal; word-break: normal; line-height: 21px; font-family: simsun;"><span style="background-color: rgb(204, 204, 204);"><span style="font-size:14px;"><strong>这就是将Object类型转化为int类型,而String.valueOf(value)是将value转化为String类型,然后由Integer.parseInt将String类型转化为int类型</strong></span></span></p>
0 0