每日总结58

学生信息管理系统（部分）

public class Student {
private int sid;
private String sname;
private String gender;
private String phone;
private String hobby;
private String info;
private Date birthday;
}

// 分页的学生数据列表
public class PageBean<T> {
private int currentPage; //当前页
private int totalPage;//总页数
private int pageSize;//每页的记录数
private int totalSize; //总的记录数
private List<T> list; //当前页的学生集合
}

public class JDBCUtil {

static ComboPooledDataSource dataSource = null;
static{
dataSource = new ComboPooledDataSource();}

public static DataSource getDataSource(){
return dataSource;}

/**
* 获取连接对象
* @return
* @throws SQLException
*/
public static Connection getConn() throws SQLException{
return dataSource.getConnection();}

/**
* 释放资源
* @param conn
* @param st
* @param rs
*/
public static void release(Connection conn , Statement st , ResultSet rs){
closeRs(rs);
closeSt(st);
closeConn(conn);}
public static void release(Connection conn , Statement st){
closeSt(st);
closeConn(conn);}

private static void closeRs(ResultSet rs){
try {
if(rs != null){
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
rs = null;
}}

private static void closeSt(Statement st){
try {
if(st != null){
st.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
st = null;
}
}

private static void closeConn(Connection conn){
try {
if(conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}
}

public class JDBCUtil {

static ComboPooledDataSource dataSource = null;
static{
dataSource = new ComboPooledDataSource();}

public static DataSource getDataSource(){
return dataSource;}

/**
* 获取连接对象
* @return
* @throws SQLException
*/
public static Connection getConn() throws SQLException{
return dataSource.getConnection();}

/**
* 释放资源
* @param conn
* @param st
* @param rs
*/
public static void release(Connection conn , Statement st , ResultSet rs){
closeRs(rs);
closeSt(st);
closeConn(conn);}
public static void release(Connection conn , Statement st){
closeSt(st);
closeConn(conn);}

private static void closeRs(ResultSet rs){
try {
if(rs != null){
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
rs = null;
}}

private static void closeSt(Statement st){
try {
if(st != null){
st.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
st = null;
}
}

private static void closeConn(Connection conn){
try {
if(conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}
}