第八篇

最新推荐文章于 2025-11-27 10:55:11 发布
原创 最新推荐文章于 2025-11-27 10:55:11 发布 · 138 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java #web

本文详细介绍了医院信息系统的用户模块设计与实现过程，包括患者、医生及管理员的登录注册功能，挂号系统，以及部门和医生信息查询等功能。通过具体代码示例展示了如何使用Java和SQL进行数据库操作，如查询、更新、删除等。

MyHospital08

UserDao.java

package com.chinasofti.hospital.user.dao;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.chinasofti.hospital.user.sql.UserSql;
import com.chinasofti.hospital.user.vo.Department;
import com.chinasofti.hospital.user.vo.Doctor;
import com.chinasofti.hospital.user.vo.GuaHao;
import com.chinasofti.hospital.user.vo.Notice;
import com.chinasofti.hospital.user.vo.Patient;
import com.chinasofti.hospital.util.JDBCDao;
import com.chinasofti.hospital.util.JDBCUtil;
import com.chinasofti.hospital.util.PageHelper;






public class UserDao {

	public boolean findNameDao(String name) {
		// TODO Auto-generated method stub		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		boolean bn=false;
		String patientName = null;
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.FIND_NAME);
			pstmt.setString(1, name);
			rs = pstmt.executeQuery();
			while(rs.next()){
				patientName = rs.getString(1);
				if (patientName!=null) {
					bn=true;
				} 
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {				
				e.printStackTrace();
			}
		}
		
		return bn;
	}

	public int registerDao(Patient patient) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.REGISTER);
			pstmt.setString(1, patient.getPATIENT_NAME());
			pstmt.setString(2, patient.getAccount());
			pstmt.setString(3, patient.getUserPwd());
			pstmt.setString(4, patient.getSex());
			pstmt.setString(5, patient.getAge());
			pstmt.setString(6, patient.getTelphone());
			pstmt.setString(7, patient.getMail());
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public String patientLoginDao(String userName) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;	
		String pwd = null;
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.PATIENT_LOGIN);
			pstmt.setString(1, userName);
			rs = pstmt.executeQuery();
			while(rs.next()){
				pwd = rs.getString(1);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {				
				e.printStackTrace();
			}
		}
		
		return pwd;
	}

	public String adminLoginDao(String adminName) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;	
		String apwd = null;
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.ADMIN_LOGIN);
			pstmt.setString(1, adminName);
			rs = pstmt.executeQuery();
			while(rs.next()){
				apwd = rs.getString(1);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {				
				e.printStackTrace();
			}
		}
		
		return apwd;
	}

	public String doctoLoginDao(String doctorName) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;	
		String dpwd = null;
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.DOCTOR_LOGIN);
			pstmt.setString(1, doctorName);
			rs = pstmt.executeQuery();
			while(rs.next()){
				dpwd = rs.getString(1);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {				
				e.printStackTrace();
			}
		}
		
		return dpwd;
	}

	public Doctor queryDoctorDao(String DOCTOR_NAME){
		// TODO Auto-generated method stub
		List<Doctor> doctor = JDBCDao.queryAll(Doctor.class, UserSql.SQL_QUERY_DOCTOR_BYNAME, DOCTOR_NAME);
		if(doctor.size()>0){
			return doctor.get(0);
		}
		return null;
	}

	public Department queryDepartmentDao(String DEPARTMENT_NAME) {
		// TODO Auto-generated method stub
		List<Department> department = JDBCDao.queryAll(Department.class, UserSql.SQL_QUERY_DEPARTMENT_BYNAME, DEPARTMENT_NAME);
		if(department.size()>0){
			return department.get(0);
		}
		return null;
	}

	public int getCountDao() {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		int result=0;
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.QUERY_DEPARTMENT_COUNT);
			rs=pstmt.executeQuery();
			while(rs.next()){
				result=rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return result;
	}

	public List<Department> queryDepartmentDao(PageHelper helper) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Department> list = new ArrayList<>();
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.QUERY_DEPARTMENT_FENYE);
			pstmt.setInt(1, helper.getEnd());
			pstmt.setInt(2, helper.getStart());
			rs=pstmt.executeQuery();
			while(rs.next()){
				Department department =new Department();
				department.setDEPARTMENT_ID(rs.getString("DEPARTMENT_ID"));
				department.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				department.setDEPARTMENT_SYNOPSIS(rs.getString("DEPARTMENT_SYNOPSIS"));
				department.setDEPARTMENT_NOTICE_HEAD(rs.getString("DEPARTMENT_NOTICE_HEAD"));
				department.setDEPARTMENT_NOTICE_CONTENT(rs.getString("DEPARTMENT_NOTICE_CONTENT"));
				list.add(department);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return list;
	}

	public List<Doctor> queryDoctorDao(PageHelper helper) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Doctor> list = new ArrayList<>();
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.QUERY_DOCTOR_FENYE);
			pstmt.setInt(1, helper.getEnd());
			pstmt.setInt(2, helper.getStart());
			rs=pstmt.executeQuery();
			while(rs.next()){
				Doctor doctor =new Doctor();
				doctor.setDOCTOR_ID(rs.getString("DOCTOR_ID"));
				doctor.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				doctor.setDOCTOR_NAME(rs.getString("DOCTOR_NAME"));
				doctor.setJOB_TITLE(rs.getString("JOB_TITLE"));
				doctor.setGOOD_JOB(rs.getString("GOOD_JOB"));
				list.add(doctor);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return list;
	}

	public int getCountDoctorDao() {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		int result=0;
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.QUERY_DOCTOR_COUNT);
			rs=pstmt.executeQuery();
			while(rs.next()){
				result=rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return result;
	}

	public boolean queryBySnameDao(String sname) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		boolean bn=false;
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.QUERY_DEPARTMENT_BY_NAME);
			pstmt.setString(1, sname);
			rs=pstmt.executeQuery();
			String sName = null;
			
			while(rs.next()){
				Department department =new Department();
				sName = rs.getString(1);
				System.out.println(sName);
				if (sName!=null) {
					bn=true;
				} 
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return bn;
	}

	public int registerGuaHaoDao(GuaHao guaHao) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.GUAHAOREGISTER);
			pstmt.setString(1, guaHao.getDEPARTMENT_NAME());
			pstmt.setString(2, guaHao.getWORK_TIME());
			pstmt.setString(3, guaHao.getDOCTOR_NAME());
			pstmt.setString(4, guaHao.getPATIENT_NAME());
			pstmt.setString(5, guaHao.getSEX());
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public List<Patient> patientQueryDao(String account) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Patient> list =new ArrayList<Patient>();
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.PATIENT_QUERY_BY_ACCOUNT);
			pstmt.setString(1, account);
			rs = pstmt.executeQuery();
			while(rs.next()){
				Patient patient = new Patient();
				patient.setPATIENT_ID(rs.getString("PATIENT_ID"));
				patient.setPATIENT_NAME(rs.getString("PATIENT_NAME"));
				patient.setAccount(rs.getString("ACCOUNT"));
				patient.setUserPwd(rs.getString("USERPWD"));
				patient.setSex(rs.getString("SEX"));
				patient.setAge(rs.getString("AGE"));
				patient.setTelphone(rs.getString("TELPHONE"));
				patient.setMail(rs.getString("MAIL"));
				list.add(patient);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		
		return list;
	}

	public List<GuaHao> guaHaoQueryDao(String PATIENT_NAME) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<GuaHao> list =new ArrayList<GuaHao>();
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.GuaHao_QUERY_BY_PATIENT_NAME);
			pstmt.setString(1, PATIENT_NAME);
			rs = pstmt.executeQuery();
			while(rs.next()){
				GuaHao guaHao = new GuaHao();
				guaHao.setGUAHAO_ID(rs.getString("GUAHAO_ID"));
				guaHao.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				guaHao.setWORK_TIME(rs.getString("WORK_TIME"));
				guaHao.setDOCTOR_NAME(rs.getString("DOCTOR_NAME"));
				guaHao.setMONEY(rs.getString("MONEY"));
				guaHao.setPATIENT_NAME(rs.getString("PATIENT_NAME"));
				guaHao.setSEX(rs.getString("SEX"));
				list.add(guaHao);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		
		return list;
	}

	public int updatePatientDao(String account,Patient patient) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
		/*	Patient patient=new Patient()*/
			pstmt=conn.prepareStatement(UserSql.UPDATE_PATIENT_BY_ACCOUNT);
			pstmt.setString(1, patient.getUserPwd());
			pstmt.setString(2, patient.getSex());
			pstmt.setString(3, patient.getAge());
			pstmt.setString(4, patient.getTelphone());
			pstmt.setString(5, patient.getMail());
			pstmt.setString(6, account);
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public List<Doctor> doctorQueryDao(String DOCTOR_NAME) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Doctor> list =new ArrayList<Doctor>();
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.DOCTOR_QUERY_BY_DOCTOR_NAME);
			pstmt.setString(1, DOCTOR_NAME);
			rs = pstmt.executeQuery();
			while(rs.next()){
				Doctor doctor =new Doctor();
				doctor.setDOCTOR_ID(rs.getString("DOCTOR_ID"));
				doctor.setPASSWORD(rs.getString("PASSWORD"));
				doctor.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				doctor.setDOCTOR_NAME(rs.getString("DOCTOR_NAME"));
				doctor.setJOB_TITLE(rs.getString("JOB_TITLE"));
				doctor.setGOOD_JOB(rs.getString("GOOD_JOB"));
				doctor.setJOB_SYNOPSIS(rs.getString("JOB_SYNOPSIS"));
				doctor.setINTRODUCTION(rs.getString("INTRODUCTION"));
				list.add(doctor);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		
		return list;
	}

	public List<GuaHao> guaHaoQueryByDoctorNameDao(String DOCTOR_NAME) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<GuaHao> list =new ArrayList<GuaHao>();
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.GuaHao_QUERY_BY_DOCTOR_NAME);
			pstmt.setString(1, DOCTOR_NAME);
			rs = pstmt.executeQuery();
			while(rs.next()){
				GuaHao guaHao = new GuaHao();
				guaHao.setGUAHAO_ID(rs.getString("GUAHAO_ID"));
				guaHao.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				guaHao.setWORK_TIME(rs.getString("WORK_TIME"));
				guaHao.setDOCTOR_NAME(rs.getString("DOCTOR_NAME"));
				guaHao.setMONEY(rs.getString("MONEY"));
				guaHao.setPATIENT_NAME(rs.getString("PATIENT_NAME"));
				guaHao.setSEX(rs.getString("SEX"));
				list.add(guaHao);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		
		return list;
	}

	public List<Doctor> queryAllDoctorDao() {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Doctor> list =new ArrayList<Doctor>();
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.DOCTOR_QUERY_ALL);
			rs = pstmt.executeQuery();
			while(rs.next()){
				Doctor doctor =new Doctor();
				doctor.setDOCTOR_ID(rs.getString("DOCTOR_ID"));
				doctor.setPASSWORD(rs.getString("PASSWORD"));
				doctor.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				doctor.setDOCTOR_NAME(rs.getString("DOCTOR_NAME"));
				doctor.setJOB_TITLE(rs.getString("JOB_TITLE"));
				doctor.setGOOD_JOB(rs.getString("GOOD_JOB"));
				doctor.setJOB_SYNOPSIS(rs.getString("JOB_SYNOPSIS"));
				doctor.setINTRODUCTION(rs.getString("INTRODUCTION"));
				list.add(doctor);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		
		return list;
	}

	public List<GuaHao> queryAllGuaHaoDao() {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<GuaHao> list =new ArrayList<GuaHao>();
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.GuaHao_QUERY_ALL);
			rs = pstmt.executeQuery();
			while(rs.next()){
				GuaHao guaHao = new GuaHao();
				guaHao.setGUAHAO_ID(rs.getString("GUAHAO_ID"));
				guaHao.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				guaHao.setWORK_TIME(rs.getString("WORK_TIME"));
				guaHao.setDOCTOR_NAME(rs.getString("DOCTOR_NAME"));
				guaHao.setMONEY(rs.getString("MONEY"));
				guaHao.setPATIENT_NAME(rs.getString("PATIENT_NAME"));
				guaHao.setSEX(rs.getString("SEX"));
				list.add(guaHao);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		
		return list;
	}

	public List<Department> queryAllDepartmentDao() {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Department> list = new ArrayList<>();
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.QUERY_DEPARTMENT_ALL);
			rs=pstmt.executeQuery();
			while(rs.next()){
				Department department =new Department();
				department.setDEPARTMENT_ID(rs.getString("DEPARTMENT_ID"));
				department.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				department.setDEPARTMENT_SYNOPSIS(rs.getString("DEPARTMENT_SYNOPSIS"));
				department.setDEPARTMENT_NOTICE_HEAD(rs.getString("DEPARTMENT_NOTICE_HEAD"));
				department.setDEPARTMENT_NOTICE_CONTENT(rs.getString("DEPARTMENT_NOTICE_CONTENT"));
				list.add(department);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return list;
	}

	public String queryPatientByNameDao(String PATIENT_NAME) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String account = null;
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.QUERY_ACCOUNT_BY_PATIENT_NAME);
			pstmt.setString(1, PATIENT_NAME);
			rs = pstmt.executeQuery();
			while(rs.next()){
				account = rs.getString(1);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {				
				e.printStackTrace();
			}
		}
		
		return account;
	}

	public int updateDoctortDao(String DOCTOR_ID, Doctor doctor) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
		/*	Patient patient=new Patient()*/
			pstmt=conn.prepareStatement(UserSql.UPDATE_DOCTOR_BY_DOCTOR_ID);
			pstmt.setString(1, doctor.getDOCTOR_NAME());
			pstmt.setString(2, doctor.getPASSWORD());
			pstmt.setString(3, doctor.getDEPARTMENT_NAME());
			pstmt.setString(4, doctor.getJOB_TITLE());
			pstmt.setString(5, doctor.getGOOD_JOB());
			pstmt.setString(6, doctor.getJOB_SYNOPSIS());
			pstmt.setString(7, doctor.getINTRODUCTION());
			pstmt.setString(8,DOCTOR_ID);
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public int deleteDoctortDao(String DOCTOR_ID) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
		/*	Patient patient=new Patient()*/
			pstmt=conn.prepareStatement(UserSql.DELETE_DOCTOR_BY_DOCTOR_ID);
			pstmt.setString(1, DOCTOR_ID);
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public int updateDepartmentDao(String DEPARTMENT_ID, Department department) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
		/*	Patient patient=new Patient()*/
			pstmt=conn.prepareStatement(UserSql.UPDATE_DEPARTMENT_BY_DEPARTMENT_ID);
			pstmt.setString(1, department.getDEPARTMENT_SYNOPSIS());
			pstmt.setString(2, department.getDEPARTMENT_NOTICE_CONTENT());
			pstmt.setString(3, department.getDEPARTMENT_NOTICE_HEAD());
			pstmt.setString(4,DEPARTMENT_ID);
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public int deleteDepartmentDao(String DEPARTMENT_ID) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
		/*	Patient patient=new Patient()*/
			pstmt=conn.prepareStatement(UserSql.DELETE_DEPARTMENT_BY_DEPARTMENT_ID);
			pstmt.setString(1, DEPARTMENT_ID);
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public int addDoctortDao(Doctor doctor) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
		/*	Patient patient=new Patient()*/
			pstmt=conn.prepareStatement(UserSql.ADD_DOCTOR);
			pstmt.setString(1, doctor.getDOCTOR_ID());
			pstmt.setString(2, doctor.getDOCTOR_NAME());
			pstmt.setString(3, doctor.getPASSWORD());
			pstmt.setString(4, doctor.getDEPARTMENT_NAME());
			pstmt.setString(5, doctor.getJOB_TITLE());
			pstmt.setString(6, doctor.getGOOD_JOB());
			pstmt.setString(7, doctor.getJOB_SYNOPSIS());
			pstmt.setString(8, doctor.getINTRODUCTION());
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public int addDepartmentDao(Department department) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
		/*	Patient patient=new Patient()*/
			pstmt=conn.prepareStatement(UserSql.ADD_DEPARTMENT);
			pstmt.setString(1, department.getDEPARTMENT_NAME());
			pstmt.setString(2, department.getDEPARTMENT_SYNOPSIS());
			pstmt.setString(3, department.getDEPARTMENT_NOTICE_CONTENT());
			pstmt.setString(4, department.getDEPARTMENT_NOTICE_HEAD());
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public int addNoticeDao(Notice notice) {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt=null;
		int num=0;
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.ADD_NOTICE);
			pstmt.setString(1, notice.getNOTICE_HEAD());
			pstmt.setString(2, notice.getNOTICE_CONTENT());
			num=pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}

	public List<Notice> noticeQueryDao() {
		// TODO Auto-generated method stub
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Notice> list = new ArrayList<>();
		try {
			conn=JDBCUtil.getConn();
			pstmt=conn.prepareStatement(UserSql.QUERY_NOTICE_ALL);
			rs=pstmt.executeQuery();
			while(rs.next()){
				Notice notice =new Notice();
				notice.setNOTICE_HEAD(rs.getString("NOTICE_HEAD"));
				notice.setNOTICE_CONTENT(rs.getString("NOTICE_CONTENT"));
				list.add(notice);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return list;
	}

	public List<Doctor> queryDoctorByDepartmentNameDao(String DEPARTMENT_NAME) {
		// TODO Auto-generated method stub
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<Doctor> list =new ArrayList<Doctor>();
		try {
			conn = JDBCUtil.getConn();
			pstmt = conn.prepareStatement(UserSql.DOCTOR_QUERY_BY_DEPARTMENT_NAME);
			pstmt.setString(1, DEPARTMENT_NAME);
			rs = pstmt.executeQuery();
			while(rs.next()){
				Doctor doctor =new Doctor();
				doctor.setDOCTOR_ID(rs.getString("DOCTOR_ID"));
				doctor.setPASSWORD(rs.getString("PASSWORD"));
				doctor.setDEPARTMENT_NAME(rs.getString("DEPARTMENT_NAME"));
				doctor.setDOCTOR_NAME(rs.getString("DOCTOR_NAME"));
				doctor.setJOB_TITLE(rs.getString("JOB_TITLE"));
				doctor.setGOOD_JOB(rs.getString("GOOD_JOB"));
				doctor.setJOB_SYNOPSIS(rs.getString("JOB_SYNOPSIS"));
				doctor.setINTRODUCTION(rs.getString("INTRODUCTION"));
				list.add(doctor);
			}
		}
		catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				JDBCUtil.CloseAll(conn, pstmt, rs);
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		
		return list;
	}
}
java_tht
关注
【Burp入门第八篇】使用BurpSuite进行目标分析
等风来
04-06 2893
选项卡中选择一个参数，Burp 将显示包含该参数的所有 URL 的列表。选择一个 URL 以查看完整的请求和响应。选项卡以查看有关目标的更多信息。并选择一个或多个主机或分支。【2】右键单击并选择。
【rtthread设备】第八篇：看门狗设备
weixin_43810563的博客
05-15 2150
一、watchdog设备概念 看门狗启动后，可以在空闲线程或者关键任务喂狗，在产品化的嵌入式系统保证在系统异常时能够自动复位。 二、watchdog设备api //查找设备 /* name：设备名称，一般为wdt */ rt_device_t rt_device_find(const char* name); //初始化看门狗 /* 看门狗句柄 */ rt_err_t rt_device_init(rt_device_t dev) //控制看门狗 /* dev：看门狗句柄 cmd：控制命令，可取
SpringBoot入门实战（第八篇：项目接口-订单管理）完结篇
博客主要分享技术教程、工具教程、bug解决、前沿技术动态、编程经验、心得感悟等。 内容同步、干货获取、推广宣发请看侧栏推广信息
04-24 1557
SpringBoot入门实战（第八篇-完结篇：项目接口-订单管理）
OkHttp原理第八篇-CallServerInterceptor
zjm807778317的博客
07-03 1143
最后一个拦截器了，兄弟们到这OkHttp系列就更新完毕了，最后一篇文章重点分析CallServerInterceptor如何对网络流进行操作
第八篇 filter过滤 - 模糊查询
灵魂学者的博客
08-24 2988
内容是通过filter过滤来实现一个简单的模糊查询功能，讲解的内容也会逐步上调！
Vue3第八篇：集成axios
Good Luck
06-14 1724
1.安装 或者 2.配置 3.使用新建user.js存放访问用户相关的接口，内容如下：
【MySQL进阶之路丨第八篇】MySQL数据的插入及查询
热门推荐
等风来
10-08 1万+
在MySQL数据库中，使用 INSERT INTO 语句来插入数据。而INSERT INTO语法有两种常见的格式，是需要我们掌握的：1.插入单行数据：INSERT INTO 表名 (列1, 列2, 列3, ...) VALUES (值1, 值2, 值3, ...);例如，要向名为 “users” 的表中插入一条记录，包含id、name和email字段：INSERT INTO users (id, name, email) VALUES (1, 'John', 'john@example.
c语言小白学习历程第八篇
qq_33565495的博客
11-07 2423
学习目标： 难的咱也看不懂，先把简单的看了再说，加油L 冲冲冲！ 学习时间： 2020年11月7日 学习产出： #include <stdio.h> /********* 冒泡排序 **********/ void fun_1(int a[], int length) { int i = 0; int j = 0; int temp = 0; for (i = 0; i < length - 1; i++) { for (j = 0; j < length - 1
Java8笔记第八篇（Stream API 的综合练习）
Spring Boot-Common On With You
05-09 3284
深入 java8 第 08 篇 （ Stream API 的综合练习 ） 8.1 Stream API 的相关练习 8.1.1 准备测试数据 private List<SalesPerson> sales = null; private Integer[] num = new Integer[]{1,2,3,4,5,6,}; @Before public
Agv、Rgv 车辆控制调度系统开发第八篇-错误纠正
持续分享调度系统开发过程
06-13 4583
开始写博客到现在也有一年多了，这一年多短短分析了调度的很多东西，我也全网搜索过，网上真正分享调度知识的基本没有，虽然我也没有把核心的代码展示出来，但是我基本上把理论和方法说的很明白了，所以真正懂调度的是能看懂我的文章和受到启发的。 这些年也在不断改进，不断优化，所以之前文章里面很多的东西都被抛弃了或者重构了， 为什么不删除之前的文章是因为，在哪个阶段是对的。 今天针对之前文章一些已经被我改动和抛弃的东西进行一次纠正。交通管制算法这一年我重构过多次了，之前写的红绿灯理论，也基本抛弃了， 最新版的算法是基于空间
外刊精读-第八篇.pdf
02-14
外刊精读-第八篇.pdf
第八篇-电子商务监察诚信演讲稿.doc
06-27
第八篇-电子商务监察诚信演讲稿.doc
输配电设备手册第8篇--低压成套开关设备和控制设备.pdf
09-05
本篇编辑了低压成套配电装置的产品，基本上代表了国内的品种和水平，具有行业的代表性和先进性。
从零开始学python第八篇
01-20
从零开始学python第八篇 太原理工大学机器人团队20日打卡day8 ​ 今天的内容主要是对前面内容的一部分补充，也就是说，到今天为止，python的所有基础内容就学习完了，剩下的主要为面向对象和项目实战 1、 可变类型...
【手写 Vue2.x 源码】第八篇 - 数组的深层劫持
01-11
文章：【手写 Vue2.x 源码】第八篇 - 数组的深层劫持 链接：https://brave.blog.csdn.net/article/details/128588563 内容：本篇，介绍了数组的深层观测实现，核心几个点如下： - 在之前对数组类型的处理中，仅对...
MyBatis + PageHelper 分页内幕，PageHelper 是如何动态构建 LIMIT 分页 SQL 的
日常笔记 | 干货分享 | 毕设源码 | 毕设指导 | 答辩指导
11-26 546
若依系统中有很多的表格数据、后端接口实体中并没有看到有接收分页大小和页码的属性，在系统的mapper层面SQL语句中并没有看到对应的分页限制。它是如何实现这个分页效果的呢？是将所有的数据查询出来，然后再分页吗？这样效率岂不是非常低。带着这样的疑问，稍微研究了一下这个系统的分页方法。更多详细文章后端是通过从 HttpServletRequest 对象中获取分页的页码和大小，然后创建Page分页对象，在执行sql查询的时候，动态构建分页限制条件。从而实现分页，并不是在查询到所有数据之后再进行的分页处理。
Java原生网络编程-BIO与NIO
照母山挖洋芋
11-24 833
摘要：本文对比了Java原生JDK中的BIO(阻塞I/O)和NIO(非阻塞I/O)网络编程模型。BIO采用"一连接一线程"模式，存在线程资源浪费和性能瓶颈问题，可通过线程池优化为伪异步I/O模型。NIO通过Selector、Channel和Buffer三大核心组件实现非阻塞通信，支持单线程管理多个通道。重点介绍了NIO的Reactor模式、事件类型(OP_READ/OP_WRITE等)及服务端/客户端的不同关注点，展示了NIO相比BIO在高并发场景下的优势。（149字）
SpringBoot后端服务重定向
最新发布
2509_94200968的博客
11-27 149
选择哪种方法取决于具体需求和架构。在我的场景中，使用了Spring MVC的重定向。但如果需要一个长期的解决方案，需要考虑前端同步更新，避免不必要的重定向的开销。或者使用反向代理或者Spring Cloud Gateway。愿你我都能在各自的领域里不断成长，勇敢追求梦想，同时也保持对世界的好奇与善意！
2025最新 SpringCloud 教程，教程简介，笔记01
Rockandrollman的博客
11-24 123
2025最新 SpringCloud 教程，教程简介，笔记01
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值