如果要这样做的话,该如何实现呢?
这是代码
package cn.taobao.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class BaseDao {
private static DataSource ds;
/**
* 初始化
* */
static {
try {
InitialContext cxt = new InitialContext();
ds = (DataSource) cxt.lookup( "java:/comp/env/jdbc/school" );
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 获得连接
* */
public static Connection connection() {
Connection conn = null;
try {
conn = ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
/**
* 释放资源
* */
public static void allClose(ResultSet rs, PreparedStatement ps,
Connection conn) {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 增删改操作
* */
public static int update(String sql, Object[] objects) {
int result = 0;
Connection conn = null;
PreparedStatement ps = null;
try {
if (objects != null) {
conn = connection();
ps = conn.prepareStatement(sql);
for (int i = 0; i < objects.length; i++) {
ps.setObject(i + 1, objects[i]);
}
result = ps.executeUpdate();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
allClose(null, ps, conn);
}
return result;
}
}