学生奖罚管理系统Java_学生管理系统

[java]代码库package com.ruide.db;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.List;

import com.ruide.mapper.IMapper;

public class DBManager {

private Connection getConn() throws SQLException {

return DBHelper.cpds.getConnection();

}

public int executeUpdate(String sql,Object[] params){

Connection conn=null;

PreparedStatement pst=null;

try {

conn=getConn();

pst=conn.prepareStatement(sql);

if(params!=null){

for(int i=0;i

pst.setObject(i+1, params[i]);

}

}

int i=pst.executeUpdate();

return i;

} catch (SQLException e) {

e.printStackTrace();

}

return -1;

}

public List executeQuery(String sql,IMapper mapper,Object params[]){

Connection conn=null;

PreparedStatement pst=null;

ResultSet rst=null;

try {

conn =getConn();

pst =conn.prepareStatement(sql);

if(params!=null){

for(int i=0;i

pst.setObject(i+1, params[i]);

}

}

rst=pst.executeQuery();

return mapper.map(rst);

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

}

[源代码打包下载]