微信小程序用Servlet连接数据库源码.zip

package com.r.dao.impl; import java.util.ArrayList; import java.util.List; import com.r.dao.BaseDao; import com.r.dao.BaseDao1; import com.r.dao.TeacherDao; import com.r.pojo.Teacher; /** * 教师dao实现类 * @author * */ public class TeacherDaoImpl extends BaseDao1 implements TeacherDao { List<Teacher> teachers = new ArrayList<>(); /** * 获取全部信息 */ @Override public List<Teacher> getAll() { try { if (getConnection()) { String sql = "select * from t_teacher"; rs = executeSQL(sql, null); while(rs.next()) { Teacher tea = new Teacher(); tea.setTeano(rs.getString("teaNo")); tea.setTeapwd(rs.getString("teaPwd")); tea.setTeaname(rs.getString("teaName")); tea.setTeasex(rs.getString("teaSex")); tea.setTitle(rs.getString("title")); tea.setPhoto(rs.getString("photo")); tea.setBirthday(rs.getString("birthday")); tea.setCpp(rs.getBoolean("cpp")); tea.setSalary(rs.getFloat("salary")); teachers.add(tea); } return teachers; } } catch (Exception e) { e.printStackTrace(); return null; } finally { closeResources(); } return null; } @Override public List<Teacher> findInfo(String no) { try { if (getConnection()) { String sql = "select * from t_teacher where teano=?"; rs = executeSQL(sql, new Object[] {no}); while(rs.next()) { Teacher tea = new Teacher(); tea.setTeano(rs.getString("teaNo")); tea.setTeapwd(rs.getString("teaPwd")); tea.setTeaname(rs.getString("teaName")); tea.setTeasex(rs.getString("teaSex")); tea.setTitle(rs.getString("title")); tea.setPhoto(rs.getString("photo")); tea.setBirthday(rs.getString("birthday")); tea.setCpp(rs.getBoolean("cpp")); tea.setSalary(rs.getFloat("salary")); teachers.add(tea); } return teachers; } } catch (Exception e) { e.printStackTrace(); return null; } finally { closeResources(); } return null; } @Override public List<Teacher> someInfo(boolean cpp) { try { if (getConnection()) { String sql = "select * from t_teacher where cpp=?"; rs = executeSQL(sql, new Object[] {cpp}); while(rs.next()) { Teacher tea = new Teacher(); tea.setTeano(rs.getString("teaNo")); tea.setTeapwd(rs.getString("teaPwd")); tea.setTeaname(rs.getString("teaName")); tea.setTeasex(rs.getString("teaSex")); tea.setTitle(rs.getString("title")); tea.setPhoto(rs.getString("photo")); tea.setBirthday(rs.getString("birthday")); tea.setCpp(rs.getBoolean("cpp")); tea.setSalary(rs.getFloat("salary")); teachers.add(tea); } return teachers; } } catch (Exception e) { e.printStackTrace(); return null; } finally { closeResources(); } return null; } @Override public int addInfo(Teacher teacher) { try { if (getConnection()) { String sql = "insert into t_teacher (teano,teapwd,teaname,teasex,title,photo,birthday,cpp,salary) values (?,?,?,?,?,?,?,?,?)"; int n = executUpdate(sql, new Object[] {teacher.getTeano(),teacher.getTeapwd(),teacher.getTeaname(),teacher.getTeasex(),teacher.getTitle(),teacher.getPhoto(),teacher.getBirthday(),teacher.isCpp(),teacher.getSalary()}); return n; } } catch (Exception e) { e.printStackTrace(); return 0; } finally { closeResources(); } return 0; } @Override public int modInfo(Teacher teacher) { try { if (getConnection()) { String sql = "update t_teacher set teaname=?,teasex=?,title=? where teano=?"; int n = executUpdate(sql, new Object[] {teacher.getTeaname(),teacher.getTeasex(),teacher.getTitle(),teacher.getTeano()}); return n; } } catch (Exception e) { e.printStackTrace(); return 0; } finally { closeResources(); } return 0; } @Override public int delInfo(String no) { try { if (getConnection()) { String sql = " delete from t_teacher where teano=?"; int n = executUpdate(sql, new Object[] {no}); return n; } } catch (Exception e) { e.printStackTrace(); return 0; } finally { closeResources(); } return 0; } @Override public Teacher selectByTeacher(String teano, String teapwd) { try { if (getConnection()) { String sql = "select * from t_teacher where teano=? and teapwd=?"; rs = executeSQL(sql, new Object[] {teano,teapwd}); Teacher teacher = null; while (rs.next()) { teacher = new Teacher(); teacher.setTeano(rs.getString("teaNo")); teacher.setTeapwd(rs.getString("teaPwd")); if (teacher.getTeano().equals(teano) && teacher.getTeapwd().equals(teapwd)) { return teacher; } } return null; } } catch (Exception e) { e.printStackTrace(); return null; } finally { closeResources(); } return null; } }