jdbc操作
public class Activityjdbc { private DataSource dataSource; protected static final Logger logger = LoggerFactory.getLogger(Activityjdbc.class); /** * 插入 */ public void insert() { String sql ="插入sql语句"; Connection conn = null; Statement state =null; try { conn = dataSource.getConnection(); state = conn.createStatement(); state.executeUpdate(sql); conn.commit();//提交(增,删,改) } catch (SQLException e) { JdbcUtil.rollbackConnection(conn); logger.info(e.getMessage(), e); }finally{ JdbcUtil.closeStatement(state); JdbcUtil.closeConnection(conn); } } /** * 查询 */ public void QueryHdIndex() { String sql = "查询语句";int a = 0; Connection conn = null; Statement state =null; ResultSet rs=null; try { conn = dataSource.getConnection(); state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { a = rs.getInt(0); } } catch (SQLException e) { JdbcUtil.rollbackConnection(conn); logger.info(e.getMessage(), e); }finally{ JdbcUtil.closeResultSet(rs); JdbcUtil.closeStatement(state); JdbcUtil.closeConnection(conn); } } public DataSource getDataSource() { return dataSource; } public void setDataSource(DataSource dataSource) { this.dataSource = dataSource; } }