第八篇

最新推荐文章于 2024-07-19 17:37:28 发布
最新推荐文章于 2024-07-19 17:37:28 发布
阅读量100 收藏
点赞数
文章标签： java web
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/java_tht/article/details/102473219
版权

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
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【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.
【第8篇】M2Det
AI浩
04-18 8804
QijieZhao1, TaoSheng1, YongtaoWang1∗, ZhiTang1, YingChen2, LingCai2 and HaibinLing3 1 Institute of Computer Science and Technology, Peking University, Beijing, P.R. China 2 AI Labs, DAMO Academy, Al...
c语言小白学习历程第八篇
qq_33565495的博客
11-07 2364
学习目标： 难的咱也看不懂，先把简单的看了再说，加油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
MySQL数据库，从入门到精通：第八篇——MySQL聚合函数实战探究：优化SELECT过程助力高效查询
沉淀、分享、成长，让自己和他人都能有所收获！
02-06 1万+
本文主要分为四个部分，第一部分介绍MySQL中的聚合函数，包括AVG、SUM、MIN、MAX和COUNT函数等。 第二部分讲解分组查询的使用方法，包括基本使用和使用多个列分组。另外，还介绍了GROUP BY中使用WITH ROLLUP实现层次细分分组。 第三部分深入讲解HAVING的使用方法和用途，包括基本使用和WHERE和HAVING的对比等。
Java8笔记第八篇（Stream API 的综合练习）
Spring Boot-Common On With You
05-09 3104
深入 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
dubbo源码分析第八篇一服务引用内核剖析
小麒麟的博客
01-15 1466
这里写目录标题服务引用原理图一服务引用原理图二源码分析ReferenceBean获取消费者代理对象createProxy 创建消费者接口动态代理RegistryProtocol.doRefer第一部分RegistryProtocol.doRefer核心RegistryDirectory.subscribeZookeeperRegistry.doSubscribeZookeeperRegistry.notifyRegistryDirectory.notify通知核心RegistryDirectory.refr
Agv、Rgv 车辆控制调度系统开发第八篇-错误纠正
持续分享调度系统开发过程
06-13 3446
开始写博客到现在也有一年多了，这一年多短短分析了调度的很多东西，我也全网搜索过，网上真正分享调度知识的基本没有，虽然我也没有把核心的代码展示出来，但是我基本上把理论和方法说的很明白了，所以真正懂调度的是能看懂我的文章和受到启发的。 这些年也在不断改进，不断优化，所以之前文章里面很多的东西都被抛弃了或者重构了， 为什么不删除之前的文章是因为，在哪个阶段是对的。 今天针对之前文章一些已经被我改动和抛弃的东西进行一次纠正。交通管制算法这一年我重构过多次了，之前写的红绿灯理论，也基本抛弃了， 最新版的算法是基于空间
干翻Mybatis源码系列之第八篇：Mybatis提供的缓存方案细节注意
热门推荐
七叔的博客
05-11 1万+
干翻Mybatis源码系列之第八篇：Mybatis提供的缓存方案细节注意
【第八篇】Vue中的过滤器
波波烤鸭的博客
07-12 1万+
  本文我们来介绍下Vue中的过滤器的使用 过滤器 概念：   Vue.js 允许你自定义过滤器，可被用作一些常见的文本格式化。过滤器可以用在两个地方：mustache 插值和 v-bind 表达式。过滤器应该被添加在 JavaScript 表达式的尾部，由“管道”符指示(" | ")； 分类：过滤器分为全局过滤器和局部过滤器(私有过滤器) 全局过滤器   我们先通过案例来介绍下过滤器的使用，然...
Raspberry-Pi-PICO系列--第八篇 高级篇使用SWD接口下载和调试（第二章）
coderma的博客
02-21 5275
一、目的 在上一篇《Raspberry-Pi-PICO系列--第八篇 高级篇使用SWD接口下载和调试（第一章）》 我们已经介绍了如何准备openocd、如何编译picoprobe、如何进行接线，本篇将继续介绍openocd命令如何使用，如何进行下载调试。 二、准备 首先准备好两块raspberry_pi_pico开发板，其中一块已经烧写好picoprobe.uf2固件，我们称之为pico A；另外一块我们称之为pico B。 ...
第八篇-电子商务监察诚信演讲稿.doc
11-29
第八篇-电子商务监察诚信演讲稿.doc
第八篇 中断
07-21
本文章是关于中断过程的。
第八篇 Ext应用篇
05-29
NULL 博文链接：https://rzy.iteye.com/blog/799136
从零开始学python第八篇
01-20
从零开始学python第八篇 太原理工大学机器人团队20日打卡day8 ​ 今天的内容主要是对前面内容的一部分补充，也就是说，到今天为止，python的所有基础内容就学习完了，剩下的主要为面向对象和项目实战 1、 可变类型...
后端编程开发-第8篇.pptx
04-26
后端编程开发-第8篇.pptx
Java内存模型
最新发布
weixin_44267758的博客
07-19 312
此处的变量不是指java编程中的变量，它包括了实例字段，静态字段和构成数值对象的元素，但不包括局部变量和方法参数。JMM规定所有变量都存储在主内存中。每条线程有自己的工作内存，工作内存中保留了该线程使用到变量的主内存的副本。线程对变量的所有操作都必须在工作内存中进行，不能直接读写主内存的变量，不同的线程间也无法直接访问对方工作内存的变量，线程之间的变量值传递需要通过主内存来完成。
JVM-垃圾回收与内存分配
m0_50846237的博客
07-19 576
JVM-垃圾回收与内存分配
day04：Redis和店铺营业状态设置
m0_69266818的博客
07-15 844
介绍了Redis命令和用java操作redis还有营业额状态接口的书写
【Java算法】前缀和 下
2302_79806056的博客
07-18 892
这段代码实现了一个寻找数组中具有相等数量的0和1的最长子数组长度的算法。具体来说，它使用了前缀和（prefix sum）的概念以及哈希映射（HashMap）来优化查找过程。初始化哈希映射：计算前缀和：检查相等数量的0和1：更新哈希映射：返回结果：这种方法的时间复杂度为O(n)，因为我们只遍历数组一次，并且对每个元素执行常数时间的操作。空间复杂度也是O(n)，最坏情况下需要存储n个前缀和值。 初始化阶段:开始遍历数组:继续
孙子兵法第七篇往后讲解
02-16
孙子兵法的第七篇至第十三篇，分别是兵势、军争、九变、行军、地形、九地、虚实，这些篇章是关于作战策略和战术的进一步讲解。 第七篇《兵势篇》论述的是军队的优劣势和制胜的方法。孙子认为，战争中最重要的是兵势，即军队的整体态势和形势，只有充分利用兵势，才能制胜于敌。这篇篇章主要包括了以下几个方面的内容： 1. 分析兵势的形式：孙子在这里提出了九种不同的兵势形式，包括势均力敌、攻其不备、出奇制胜、以逸待劳、以进为退、虚实相生、形如棋局、变化莫测、水能载舟，亦能覆舟。 2. 论述兵势的变化：孙子认为，兵势不断变化，战场上的胜利者往往是能够适应变化的人。他提出了“势生因变化，变化因乘势”的观点，强调了灵活应对变化的重要性。 3. 论述兵势的利用：孙子认为，兵势的利用需要在多方面考虑，包括战争的时间、地点、人员等。他提出了“知己知彼，百战不殆”的观点，强调了充分了解自己和敌人的重要性。 第八篇《军争篇》主要论述了战争的规模、作战的目标和策略，以及如何应对各种情况。这篇篇章主要包括了以下几个方面的内容： 1. 论述作战的目标：孙子认为，战争的目标不应该仅仅是摧毁敌人的军队，而应该是达到一定的政治目的。他提出了“战争的终极目标是和平”这一观点。 2. 论述如何取胜：孙子提出了“攻其无备，出其不意”这一战争策略，强调了在作战中利用敌人的弱点和意外性的重要性。 3. 论述军队的规模和组织：孙子认为，军队的规模不是唯一的决定性因素，重要的是军队的组织和指挥。他

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值