package pro.com.service;
import java.sql.SQLException;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import pro.com.bean.userBean;
import pro.com.dao.UserDao;
import pro.com.utils.JDBCUtils;
public class UserAdminService {
//Search方法，用于查询搜索框中给出的信息对应用户资料
public static List<userBean> Search(String email,String name,String username,String job,String sex) throws SQLException{
List<userBean> list=null;
UserDao dao=new UserDao();
System.out.println(email);
System.out.println(name);
System.out.println(username);
System.out.println(job);
System.out.println(sex);
if (email!="") {
list=dao.findEmail(email);
}else {
//单条件查询
if (name!=""&&username==""&&job==""&&sex=="")
list=dao.findName(name);
if (name==""&&username!=""&&job==""&&sex=="")
list=dao.findUserName(username);
if (name==""&&username==""&&job!=""&&sex=="")
list=dao.findJob(job);
if (name==""&&username==""&&job==""&&sex!="")
list=dao.findSex(sex);
//双条件查询
if (name!=""&&username!=""&&job==""&&sex=="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where name=? and username=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),name,username);
}
if (name!=""&&username==""&&job!=""&&sex=="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where name=? and job=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),name,job);
}
if (name!=""&&username==""&&job==""&&sex!="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where name=? and sex=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),name,sex);
}
if (name==""&&username!=""&&job!=""&&sex=="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where username=? and job=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),username,job);
}
if (name==""&&username!=""&&job==""&&sex!="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where username=? and sex=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),username,sex);
}
if (name==""&&username==""&&job!=""&&sex!="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where job=? and sex=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),job,sex);
}
//三个条件查询
if (name==""&&username!=""&&job!=""&&sex!="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where username=? and job=? and sex=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),username,job,sex);
}
if (name!=""&&username==""&&job!=""&&sex!="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where name=? and job=? and sex=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),name,job,sex);
}
if (name!=""&&username!=""&&job==""&&sex!="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where name=? and username=? and sex=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),name,username,sex);
}
if (name!=""&&username!=""&&job!=""&&sex=="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where name=? and username=? and job=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),name,username,job);
}
if (name!=""&&username!=""&&job!=""&&sex!="") {
QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where name=? and username=? and job=? and sex=?";
list = runner.query(sql, new BeanListHandler<userBean>(userBean.class),name,username,job,sex);
}
}
return list;
}
//添加用户的方法，添加一个用户
public static Boolean UserAdd(String email,String name,String username,String password,String address,
String phone,String job,String sex,String role) throws SQLException {
userBean user=new userBean();
UserDao dao=new UserDao();
user.setEmail(email);
user.setPassword(password);
user.setName(name);
user.setUsername(username);
user.setSex(sex);
user.setJob(job);
user.setPhone(phone);
user.setAddress(address);
user.setDescribe("");
user.setRole(role);
user.setBirthday(null);
return dao.insert(user);
}
}
一个基于Servlet + jsp + mysql 的简单的 病历管理系统。.zip
需积分: 4 137 浏览量
2024-02-17
17:01:35
上传
评论
收藏 4.06MB ZIP 举报
一个基于Servlet + jsp + mysql 的简单的 病历管理系统。.zip （160个子文件） 
UserAdminService.class 5KB MedicalAddServlet_Sure.class 5KB MedicalDao.class 5KB EditServlet_Patient_Sure.class 4KB MedicalBean.class 4KB PatientDao.class 4KB DoctorDao.class 4KB TabChangeServlet.class 4KB UserDao.class 4KB EditServlet_Medical_Sure.class 4KB PatientBean.class 4KB EditServlet_Doctor_Sure.class 4KB DoctorAdminService.class 3KB EditServlet_User_Sure.class 3KB PatientAdminService.class 3KB DoctorBean.class 3KB DoctorAddServlet.class 3KB PatientAddServlet.class 3KB PageBean.class 3KB UserAdminServlet.class 3KB test1.class 3KB EditServlet_Doctor.class 3KB UserAddServlet.class 3KB EditServlet_Patient.class 3KB PatientSearchServlet.class 3KB DoctorSearchServlet.class 3KB loginServlet.class 3KB UserSearchServlet.class 3KB MedicalSearchServlet.class 2KB userBean.class 2KB MedicalAddServlet.class 2KB DeleteServlet_Medical.class 2KB DeleteServlet_Patient.class 2KB DeleteServlet_Doctor.class 2KB EditServlet_Medical.class 2KB DeleteServlet_User.class 2KB EditServlet_User.class 2KB JDBCUtils.class 2KB PagePatientAdminDao.class 2KB PageMedicalAdminDao.class 2KB PageDoctorAdminDao.class 2KB PageUserAdminDao.class 2KB MedicalAdminService.class 2KB PagePatientAdminService.class 2KB PageMedicalAdminService.class 2KB PageDoctorAdminService.class 2KB PageUserAdminService.class 2KB LoginOutServlet.class 2KB MainServlet.class 1KB test_lineSum.class 857B test_patient.class 287B .classpath 1KB org.eclipse.wst.common.component 502B org.eclipse.wst.jsdt.ui.superType.container 49B layui.css 73KB zpp.css 19KB NewFile.css 51B
mysql-connector-java-8.0.21.jar 2.29MB jstl-1.2.jar 405KB standard-1.1.2.jar 384KB servlet-api.jar 277KB commons-beanutils-1.9.4.jar 241KB commons-dbcp2-2.8.0.jar 203KB commons-pool2-2.9.0.jar 132KB commons-dbutils-1.7.jar 95KB commons-logging-1.2.jar 60KB UserAdminService.java 5KB MedicalDao.java 4KB PatientDao.java 4KB UserDao.java 4KB DoctorDao.java 4KB EditServlet_Medical_Sure.java 4KB TabChangeServlet.java 4KB MedicalAddServlet_Sure.java 4KB EditServlet_Patient_Sure.java 4KB MedicalBean.java 3KB EditServlet_Doctor_Sure.java 3KB EditServlet_User_Sure.java 3KB PatientBean.java 3KB PatientAdminService.java 2KB DoctorAdminService.java 2KB UserAdminServlet.java 2KB loginServlet.java 2KB PatientSearchServlet.java 2KB PatientAddServlet.java 2KB EditServlet_Patient.java 2KB UserSearchServlet.java 2KB UserAddServlet.java 2KB DoctorAddServlet.java 2KB PageBean.java 2KB DoctorBean.java 2KB MedicalSearchServlet.java 2KB DoctorSearchServlet.java 2KB JDBCUtils.java 2KB MedicalAddServlet.java 2KB EditServlet_Doctor.java 2KB test1.java 2KB DeleteServlet_Patient.java 2KB userBean.java 2KB DeleteServlet_User.java 1KB共 160 条
- 1
- 2
资源评论
