package www.shetuan.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import www.shetuan.dao.StudentDAO;
import www.shetuan.dbtools.JdbcUtils;
import www.shetuan.domain.Admin;
import www.shetuan.domain.DeptAndJob;
import www.shetuan.domain.Student;
import www.shetuan.factory.GetDAO;
public class StudentDAOImpl implements StudentDAO {
//全部查询
public ArrayList<Student> getStudents(int start,int number) {
ResultSet rs=null;
PreparedStatement ps =null;
ArrayList<Student> students = new ArrayList<Student>();
Connection conn = JdbcUtils.getConnection();
String sql = "select id,stu_id,stu_name,stu_password,stu_yuanxi,stu_job,stu_email" +
",stu_phone,stu_qq,stu_sex,stu_age,stu_join,depart_id,role_id,stu_like from student where u_id=2 LiMIT ?,?";
try {
ps = conn.prepareStatement(sql);
ps.setInt(1,start);
ps.setInt(2,number);
rs = ps.executeQuery();
while(rs.next()){
Student student = new Student();
student.setId(rs.getInt("id"));
student.setStu_id(rs.getString("stu_id"));
student.setStu_name(rs.getString("stu_name"));
student.setStu_password(rs.getString("stu_password"));
student.setStu_yuanxi(rs.getString("stu_yuanxi"));
student.setStu_job(rs.getString("stu_job"));
student.setStu_email(rs.getString("stu_email"));
student.setStu_phone(rs.getString("stu_phone"));
student.setStu_qq(rs.getString("stu_qq"));
student.setStu_sex(rs.getString("stu_sex"));
student.setStu_age(rs.getString("stu_age"));
student.setStu_join(rs.getString("stu_join"));
student.setDepart_id(rs.getInt("depart_id"));
student.setDepart_name(GetDAO.getStudentDAO().getDepartName(rs.getInt("depart_id")));
student.setRole_id(rs.getInt("role_id"));
student.setStu_like(rs.getString("stu_like"));
students.add(student);
}
} catch (SQLException e) {
e.printStackTrace();
}
return students;
}
//按社团查询
public ArrayList<Student> getStudents(int start,int number,int depart_id){
ResultSet rs=null;
PreparedStatement ps =null;
ArrayList<Student> students = new ArrayList<Student>();
Connection conn = JdbcUtils.getConnection();
String sql = "select id,stu_id,stu_name,stu_password,stu_yuanxi,stu_job,stu_email" +
",stu_phone,stu_qq,stu_sex,stu_age,stu_join,depart_id,role_id,stu_like from student where u_id=2 and depart_id=? LiMIT ?,?";
try {
ps = conn.prepareStatement(sql);
ps.setInt(1, depart_id);
ps.setInt(2,start);
ps.setInt(3,number);
rs = ps.executeQuery();
while(rs.next()){
Student student = new Student();
student.setId(rs.getInt("id"));
student.setStu_id(rs.getString("stu_id"));
student.setStu_name(rs.getString("stu_name"));
student.setStu_password(rs.getString("stu_password"));
student.setStu_yuanxi(rs.getString("stu_yuanxi"));
student.setStu_job(rs.getString("stu_job"));
student.setStu_email(rs.getString("stu_email"));
student.setStu_phone(rs.getString("stu_phone"));
student.setStu_qq(rs.getString("stu_qq"));
student.setStu_sex(rs.getString("stu_sex"));
student.setStu_age(rs.getString("stu_age"));
student.setStu_join(rs.getString("stu_join"));
student.setDepart_id(rs.getInt("depart_id"));
student.setDepart_name(GetDAO.getStudentDAO().getDepartName(rs.getInt("depart_id")));
student.setRole_id(rs.getInt("role_id"));
student.setStu_like(rs.getString("stu_like"));
students.add(student);
}
} catch (SQLException e) {
e.printStackTrace();
}
return students;
}
//按部门查询全部会员
public ArrayList<Student> getStudents(int depart_id){
ResultSet rs=null;
PreparedStatement ps =null;
ArrayList<Student> students = new ArrayList<Student>();
Connection conn = JdbcUtils.getConnection();
String sql = "select id,stu_id,stu_name,stu_password,stu_yuanxi,stu_job,stu_email" +
",stu_phone,stu_qq,stu_sex,stu_age,stu_join,depart_id,role_id,stu_like from student where u_id=2 and depart_id=?";
try {
ps = conn.prepareStatement(sql);
ps.setInt(1, depart_id);
rs = ps.executeQuery();
while(rs.next()){
Student student = new Student();
student.setId(rs.getInt("id"));
student.setStu_id(rs.getString("stu_id"));
student.setStu_name(rs.getString("stu_name"));
student.setStu_password(rs.getString("stu_password"));
student.setStu_yuanxi(rs.getString("stu_yuanxi"));
student.setStu_job(rs.getString("stu_job"));
student.setStu_email(rs.getString("stu_email"));
student.setStu_phone(rs.getString("stu_phone"));
student.setStu_qq(rs.getString("stu_qq"));
student.setStu_sex(rs.getString("stu_sex"));
student.setStu_age(rs.getString("stu_age"));
student.setStu_join(rs.getString("stu_join"));
student.setDepart_id(rs.getInt("depart_id"));
student.setDepart_name(GetDAO.getStudentDAO().getDepartName(rs.getInt("depart_id")));
student.setRole_id(rs.getInt("role_id"));
student.setStu_like(rs.getString("stu_like"));
students.add(student);
}
} catch (SQLException e) {
e.printStackTrace();
}
return students;
}
//得到全部会员
public ArrayList<Student> getStudents(){
ResultSet rs=null;
PreparedStatement ps =null;
ArrayList<Student> students = new ArrayList<Student>();
Connection conn = JdbcUtils.getConnection();
String sql = "select id,stu_id,stu_name,stu_password,stu_yuanxi,stu_job,stu_email" +
",stu_phone,stu_qq,stu_sex,stu_age,stu_join,depart_id,role_id,stu_like from student where u_id=2";
try {
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
Student student = new Student();
student.setId(rs.getInt("id"));
student.setStu_id(rs.getString("stu_id"));
student.setStu_name(rs.getString("stu_name"));
student.setStu_password(rs.getString("stu_password"));
student.setStu_yuanxi(rs.getString("stu_yuanxi"));
student.setStu_job(rs.getString("stu_job"));
student.setStu_email(rs.getString("stu_email"));
student.setStu_phone(rs.getString("stu_phone"));
student.setStu_qq(rs.getString("stu_qq"));
student.setStu_sex(rs.getString("stu_sex"));
student.setStu_age(rs.getString("stu_age"));
student.setStu_join(rs.getString("stu_join"));
student.setDepart_id(rs.getInt("depart_id"));
student.setDepart_name(GetDAO.getStudentDAO().getDepartName(rs.getInt("depart_id")));
student.setRole_id(rs.getInt("role_id"));
student.setStu_like(rs.getString("stu_like"));
students.add(student);
}
} catch (SQLException e) {
e.printStackTrace();
}
return students;
}
//按条件查询
public ArrayList<Student> getStudents(int start,int number,String stu_id,String stu_name){
ResultSet rs=null;
PreparedStatement ps =null;
ArrayList<Student> students = new ArrayList<Student>();
Connection conn = JdbcUtils.getConnection();
String sql = "select id,stu_id,stu_name,stu_password,stu_yuanxi,stu_job,stu_email" +
",stu_phone,stu_qq,stu_sex,stu_age,stu_join,depart_id,role_id,stu_like from student where u_id=2 and " +
"stu_id like ? and stu_name like ? LiMIT ?,?";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, "%"+stu_id+"%");
ps.setString(2, "%"+stu_name+"%");
ps.setInt(3, start);
ps.setInt(4,number);
rs = ps.executeQuery();
while(rs.next()){
Student student = new Student();
student.setId(rs.getInt("id"));
student.setId(rs.getInt("id"));
student.setStu_id(rs.getString("stu_id"));
student.setStu_name(rs.getString("stu_name"));
student.setStu_password(rs.getString("stu_password"));
student.setStu_yuanxi(rs.getString("stu_yuanxi"));
student.setStu_job(rs.getString("stu_job"));
student.setStu_email(rs.getString("stu_email"));
studen
社团管理系统
3星 · 超过75%的资源 需积分: 13 29 浏览量
2013-06-05
17:11:27
上传
评论 8
收藏 5.72MB ZIP 举报 
社团管理系统 （1162个子文件） 
config.ascx 5KB class_upload.asp 10KB io.asp 7KB commands.asp 6KB config.asp 6KB connector.asp 2KB upload.asp 2KB basexml.asp 2KB util.asp 1KB connector.aspx 1KB upload.aspx 1KB image.cfc 46KB ImageObject.cfc 12KB cf5_upload.cfm 11KB cf5_connector.cfm 10KB cf_io.cfm 10KB cf_commands.cfm 8KB config.cfm 8KB spellchecker.cfm 5KB cf_util.cfm 4KB cf_connector.cfm 3KB cf_basexml.cfm 3KB cf_upload.cfm 2KB connector.cfm 1005B upload.cfm 993B connector.cgi 4KB upload.cgi 3KB StudentDAOImpl.class 17KB UnionDAOImpl.class 7KB WebActivityDAOImpl.class 6KB WebNewsDAOImpl.class 6KB UploadServlet.class 5KB NoticeDAOImpl.class 5KB PrintUnionAll.class 5KB PrintallByDept.class 5KB PrintAll.class 5KB KnowledgeDAOImpl.class 5KB MessageBoardDAOImpl.class 5KB AdminDAOImpl.class 4KB EditStudent.class 4KB EditUnion.class 4KB Upload.class 4KB EditStudent2.class 4KB Login.class 4KB Student.class 4KB DeptDAOImpl.class 4KB GetNoticeFile.class 4KB Addmessage.class 3KB AboutMe.class 3KB ModifyStudent.class 3KB EditAdmin.class 3KB AddStudent.class 3KB ListStudent.class 3KB AddUnion.class 3KB UnionList.class 3KB Weblogin.class 3KB EditActivity.class 3KB EditNews.class 3KB EditDept.class 3KB GetNewsList.class 3KB VipUserImpl.class 3KB GetVipUser.class 3KB GetAllMessageBoardDetil.class 3KB GetAllKnowledgesDetil.class 3KB ModifyPass.class 3KB GetAllNewsDetil.class 3KB ModifyStuSure.class 3KB GetActivityListDetil.class 3KB GetDepart.class 3KB GetAllJoininfos.class 3KB GetAllKnowledges.class 3KB GetActivityList.class 3KB GetAllMessageBoardService.class 3KB NoticePublish.class 3KB JdbcUtils.class 3KB ModifyStSure.class 3KB ManagerST.class 3KB WebNewsServlet.class 3KB AddAdmin.class 3KB RegisterDAOImp.class 3KB ListActivity.class 3KB JoininfoDaoImpl.class 3KB ModifySt.class 3KB UserImpl.class 3KB ManagerAdmin.class 3KB ListNews.class 3KB ListDept.class 3KB EditNoticeFinish.class 3KB AddActivity.class 3KB AddNews.class 3KB Register.class 2KB NoticeList.class 2KB ActcollectDaoImpl.class 2KB AddDept.class 2KB ActivityIdea.class 2KB GetNewsContent.class 2KB GetNoticeContent.class 2KB GetDAO.class 2KB WebUserDaoImple.class 2KB PropertiesUtil.class 2KB共 1162 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
u0137198582014-03-05整合的项目，界面能够运行出来，功能还可以。 .- ljz0721cx2014-01-26骗子 没有源码 反编译出来也不能 懒得搞了
tsyuanfeng2014-11-03感觉分值太高，新手慎重
huzhancheng2013-06-11struts+spring+hibernate+jsp整合的项目，界面能够运行出来，功能还可以。
