一个比较规范的jdbc连接方法类
主要是留意里面的关闭连接释放资源的写法~
public String viewCheck(String id) {
?? Session session = factory.openSession();
?? String sumAmount = "";
?? Transaction tx = session.beginTransaction();
?? String sql = "select * from t_merchant_cz where name='"+id+"'";
?? System.out.println(sql);
?? Connection conn = session.connection();??
?? try {
??? Statement stmt = conn.createStatement();
??? ResultSet rs = stmt.executeQuery(sql);
??? if(rs.next()){
???? sumAmount = (String)rs.getString("sum_amount");
??? }
???
?? } catch (Exception e){
??? try {
???? throw e;
??? } catch (Exception se) {
??? }
?? } finally {
??? try {
???? tx.commit();
???? conn.close();
??? } catch (Exception e) {
??? }
??? session.close();
?? }
?? return sumAmount;
}
?
