基于struts2的博客网站Demo（自己学习）

package com.isoftstone.xiaonei.common.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; /** * * @author 张钦帝 * @创建时间：Jun 30, 2010 3:06:25 PM * @项目名：xiaonei * @文件名：BaseDAO.java * @包名：com.isoftstone.xiaonei.common.dao */ public class BaseDAO { private Connection conn; private PreparedStatement pstmt; private final static String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver"; private final static String JDBC_URL = "jdbc:oracle:thin:@10.40.81.29:1521:FRIENDS"; // private final static String JDBC_DRIVER = "com.mysql.jdbc.Driver"; // private final static String JDBC_URL = // "jdbc:mysql://localhost/test?useUnicode=true&amp;characterEncoding=UTF-8"; private final static String USER = "pubU"; private final static String PASSWORD = "pubu"; static { try { Class.forName(JDBC_DRIVER); } catch (ClassNotFoundException e) { e.printStackTrace(); } } /** * * @方法名：init * @参数： * @param sql * @param args * @throws SQLException * @新建日期：Jun 30, 2010 3:06:58 PM */ private void init(String sql, String... args) throws SQLException { conn = DriverManager.getConnection(JDBC_URL, USER, PASSWORD); pstmt = conn.prepareStatement(sql); for (int i = 0, l = args.length; i < l; i++) { pstmt.setString(i + 1, args[i]); } } /** * 添加 和 更新 * @方法名：createOrUpdate * @参数： * @param sql * @param args * @return * @新建日期：Jun 30, 2010 3:07:27 PM */ public boolean createOrUpdate(String sql, String... args) { try { free(null); init(sql, args); return pstmt.executeUpdate() > 0; } catch (SQLException e) { e.printStackTrace(); } finally { free(null); } return false; } /** * 查询返回 ResultSet * @方法名：query * @参数： * @param sql * @param args * @return * @新建日期：Jun 30, 2010 3:07:37 PM */ public ResultSet query(String sql, String... args) { try { init(sql, args); return pstmt.executeQuery(); } catch (SQLException e) { e.printStackTrace(); } return null; } /** * 添加 * @方法名：save * @参数： * @param sql * @param args * @return * @新建日前：Jul 5, 2010 4:01:26 PM */ public boolean delete(String sql, String... args) { try { init(sql, args); return pstmt.execute(); } catch (SQLException e) { e.printStackTrace(); } return false; } /** * 释放连接 * @方法名：free * @参数： * @param rs * @新建日期：Jun 30, 2010 3:08:37 PM */ public void free(ResultSet rs) { try { if (null != rs) { rs.close(); rs = null; } if (null != pstmt) { pstmt.close(); pstmt = null; } if (null != conn && !conn.isClosed()) { conn.close(); conn = null; } } catch (SQLException e) { } } }