package com.wzxy.povertyidentification.dao.impl;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.wzxy.povertyidentification.bean.Pkrdsqb;
import com.wzxy.povertyidentification.dao.IPkrdsqbDao;
import com.wzxy.povertyidentification.database.DbUtils;
public class PkrdsqbDaoImpl implements IPkrdsqbDao {
private DbUtils dbUtils;
public PkrdsqbDaoImpl() {
this.dbUtils = new DbUtils();
}
public int addPkrdsqb(Pkrdsqb sqb) { //添加数据(学生)
int result = 0;
try {
//实例化DbUtils连接数据库
Connection conn = dbUtils.getConn();//获得数据库连接
Statement stmt = conn.createStatement();//连接类创建statement创建SQL语句
//构造SQL语句
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("INSERT INTO pkrdsqbxx(fullstuNo,stuName,sex,birth,idNo,money,xueyuan,className,phoneNum,reason,zhuangtai,tongguo,fandui,qingkuang,juti)");
sqlBuffer.append("VALUES('" + sqb.getFullstuNo() + "'," +
"'" + sqb.getStuName() + "','" + sqb.getSex() + "','" + sqb.getBirth() + "'," +
"'" + sqb.getIdNo() + "','" + sqb.getMoney() + "','" + sqb.getXueyuan() + "','" + sqb.getClassName() + "'" +
",'" + sqb.getPhoneNum() + "','" + sqb.getReason() + "','" + sqb.getZhuangtai() + "','" + sqb.getTongguo() + "','" + sqb.getFandui() + "','" + sqb.getQingkuang() + "','" + sqb.getJuti() + "')");
String sql = sqlBuffer.toString();
int c = stmt.executeUpdate(sql);
result = c;
} catch (Exception e) {
System.out.print("添加申请表失败:" + e.getMessage());
e.printStackTrace();
}
return result;
}
public List<Pkrdsqb> allsqb() { //查看所有数据,条件:无条件(管理员)
List<Pkrdsqb> result = new ArrayList<Pkrdsqb>();
try {
Connection conn = dbUtils.getConn();//获得数据库连接
Statement stmt = conn.createStatement();
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("SELECT * FROM pkrdsqbxx ORDER BY fullstuNo");
String sql = sqlBuffer.toString();
ResultSet rs = stmt.executeQuery(sql);
while (rs != null && rs.next()) {
Pkrdsqb sqb = new Pkrdsqb();
sqb.setFullstuNo(rs.getString("fullstuNo"));
sqb.setStuName(rs.getString("stuName"));
sqb.setSex(rs.getString("sex"));
sqb.setBirth(rs.getString("birth"));
sqb.setIdNo(rs.getString("idNo"));
sqb.setMoney(rs.getString("money"));
sqb.setXueyuan(rs.getString("xueyuan"));
sqb.setClassName(rs.getString("className"));
sqb.setPhoneNum(rs.getString("phoneNum"));
sqb.setReason(rs.getString("reason"));
sqb.setZhuangtai(rs.getString("zhuangtai"));
result.add(sqb);
}
} catch (Exception e) {
System.out.print("查看申请表出错:" + e.getMessage());
e.printStackTrace();
}
return result;
}
public List<Pkrdsqb> findByFullstuNo(String FullstuNo) { //查询所有字段数据,条件:学号
List<Pkrdsqb> result = new ArrayList<Pkrdsqb>();
try {
Connection conn = dbUtils.getConn();//获得数据库连接
Statement stmt = conn.createStatement();
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("SELECT * FROM pkrdsqbxx WHERE fullstuNo='" + FullstuNo + "'");
String sql = sqlBuffer.toString();
ResultSet rs = stmt.executeQuery(sql);
while (rs != null && rs.next()) {
Pkrdsqb sqb = new Pkrdsqb();
sqb.setFullstuNo(rs.getString("fullstuNo"));
sqb.setStuName(rs.getString("stuName"));
sqb.setSex(rs.getString("sex"));
sqb.setBirth(rs.getString("birth"));
sqb.setIdNo(rs.getString("idNo"));
sqb.setMoney(rs.getString("money"));
sqb.setXueyuan(rs.getString("xueyuan"));
sqb.setClassName(rs.getString("className"));
sqb.setPhoneNum(rs.getString("phoneNum"));
sqb.setReason(rs.getString("reason"));
sqb.setZhuangtai(rs.getString("zhuangtai"));
sqb.setTongguo(rs.getInt("tongguo"));
sqb.setFandui(rs.getInt("fandui"));
sqb.setQingkuang(rs.getString("qingkuang"));
sqb.setJuti(rs.getString("juti"));
result.add(sqb);
}
} catch (Exception e) {
System.out.print("查看申请表出错:" + e.getMessage());
e.printStackTrace();
}
return result;
}
public List<Pkrdsqb> findbyClassName(String ClassName) { //查询所有字段数据,条件:班级 查询以下字段组员查(组长和组员所查的字段不同)
List<Pkrdsqb> result = new ArrayList<Pkrdsqb>();
try {
Connection conn = dbUtils.getConn();//获得数据库连接
Statement stmt = conn.createStatement();
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("SELECT * FROM pkrdsqbxx WHERE className='" + ClassName + "'"); //pkrdsqbxx中可能是16xxxxx班, 管理员导入的xsxx中肯定是标准的专业名称
String sql = sqlBuffer.toString();
ResultSet rs = stmt.executeQuery(sql);
while (rs != null && rs.next()) {
Pkrdsqb sqb = new Pkrdsqb();
sqb.setFullstuNo(rs.getString("fullstuNo"));
sqb.setStuName(rs.getString("stuName"));
sqb.setSex(rs.getString("sex"));
sqb.setBirth(rs.getString("birth"));
sqb.setIdNo(rs.getString("idNo"));
sqb.setMoney(rs.getString("money"));
sqb.setXueyuan(rs.getString("xueyuan"));
sqb.setClassName(rs.getString("className"));
sqb.setPhoneNum(rs.getString("phoneNum"));
sqb.setReason(rs.getString("reason"));
sqb.setZhuangtai(rs.getString("zhuangtai"));
sqb.setTongguo(rs.getInt("tongguo"));
sqb.setFandui(rs.getInt("fandui"));
sqb.setQingkuang(rs.getString("qingkuang"));
sqb.setJuti(rs.getString("juti"));
result.add(sqb);
}
} catch (Exception e) {
System.out.print("查看班级申请表出错:" + e.getMessage());
e.printStackTrace();
}
return result;
}
public List<Pkrdsqb> fdychakan(String ClassName) { //辅导员查看已通过小组审核的同学
List<Pkrdsqb> result = new ArrayList<Pkrdsqb>();
try {
Connection conn = dbUtils.getConn();//获得数据库连接
Statement stmt = conn.createStatement();
StringBuffer sqlBuffer = new StringBuffer();
sqlBuffer.append("SELECT * FROM pkrdsqbxx WHERE className='" + ClassName + "' AND zhuangtai='班级小组通过并已提交,辅导员审核中'"); //pkrdsqbxx中可能是16xxxxx班, 管理员导入的xsxx中肯定是标准的专业名称
String sql = sqlBuffer.toString();
ResultSet rs = stmt.executeQuery(sql);
while (rs != null && rs.next()) {
Pkrdsqb sqb = new Pkrdsqb();
sqb.setFullstuNo(rs.getString("fullstuNo"));
sqb.setStuName(rs.getString("stuName"));
sqb.setXueyuan(rs.getString("xueyuan"));
sqb.setClassName(rs.getString("className"));
sqb.setZhuangtai(rs.getString("zhuangtai"));
result.add(sqb);
}
} catch (Exception e) {
System.out.print("查看班级申请表出错:" + e.getMessage());
e.printStackT
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
【资源说明】 1、该资源包括项目的全部源码,下载可以直接使用! 2、本项目适合作为计算机、数学、电子信息等专业的课程设计、期末大作业和毕设项目,作为参考资料学习借鉴。 3、本资源作为“参考资料”如果需要实现其他功能,需要能看懂代码,并且热爱钻研,自行调试。 基于JSP+Servlet+Dao实现的贫困认定管理系统源码.zip
资源推荐
资源详情
资源评论
收起资源包目录
基于JSP+Servlet+Dao实现的贫困认定管理系统源码.zip (52个子文件)
code_20105
src
com
wzxy
povertyidentification
servlet
XsServlet.java 8KB
PkrdsqbServlet.java 19KB
BjServlet.java 2KB
UserLoginServlet.java 6KB
FdyServlet.java 7KB
dao
IXsDao.java 816B
IUserLoginDao.java 227B
IBjDao.java 300B
IPkrdsqbDao.java 2KB
IToupiaoDao.java 681B
impl
PkrdsqbDaoImpl.java 23KB
BjDaoImpl.java 1KB
XsDaoImpl.java 9KB
UserLoginImpl.java 2KB
ToupiaoDaoImpl.java 5KB
FdyDaoImpl.java 6KB
IFdyDao.java 807B
factory
DaoFactory.java 1KB
database
DbUtils.java 1KB
util
filter
SetCharacterEncodingFilter.java 2KB
bean
Bj.java 651B
Xs.java 2KB
Fdy.java 851B
Pkrdsqb.java 3KB
Toupiao.java 1KB
UserLogin.java 629B
.idea
libraries
lib.xml 319B
vcs.xml 167B
misc.xml 258B
inspectionProfiles
Project_Default.xml 2KB
modules.xml 282B
.gitignore 232B
encodings.xml 157B
WebRoot
index.jsp 5KB
ClassAll.jsp 2KB
ChangePwd.jsp 2KB
Cksqb.jsp 6KB
welcome.jsp 1KB
css
bootstrap.min.css 111KB
add.css 1022B
login.css 3KB
index.css 6KB
images
copy_rignt_24.png 332B
005.jpg 59KB
excel2007@29124_25049.exe 1.28MB
003.jpg 61KB
002.jpg 47KB
004.jpg 133KB
captcha.jpg 2KB
001.jpg 114KB
login.jsp 5KB
PovertyIdentification.iml 899B
共 52 条
- 1
资源评论
土豆片片
- 粉丝: 1567
- 资源: 5642
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功