java web管理员--教师(用户)管理系统。附数据库

package dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import beas.Teacher; public class TeacherDao { String name,password,sex,age,pro; Teacher teacher; public TeacherDao(String name,String password,String sex,String age,String pro){ this.name=name; this.password=password; this.sex=sex; this.age=age; this.pro=pro; } public TeacherDao(String name,String password){ this.name=name; this.password=password; } public TeacherDao(String name){ this.name=name; } public TeacherDao(){ } public TeacherDao(Teacher teacher){ this.teacher=teacher; } /* * 检查此登陆用户是否合法，并跳转 */ public String loginTeacher() throws Exception{ String loginResult=null; try{ //连接数据库查询 Connection conn=null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=DB_Teacher","sa","123456"); Statement stat1=(Statement) conn.createStatement(); String sql="select * from Tb_Teacher where TeacherName='"+name+"' and TeacherPassword='"+password+"' "; ResultSet rs=(stat1).executeQuery(sql); while(rs.next()){ loginResult="用户登陆成功！"; } if(loginResult==null){ loginResult="用户名或密码出错，登陆失败！"; } rs.close(); stat1.close(); conn.close(); } catch(Exception e){ loginResult=e.getMessage(); } return loginResult; } /* * 将注册的用户信息存入数据库，并跳转 */ public String saveTeacher() throws Exception{ String registResult=null; //boolean flag=false; try{ Connection conn=null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=DB_Teacher","sa","123456"); Statement stat1=(Statement) conn.createStatement(); //查询是否有重名 String sql="select * from Tb_Teacher where TeacherName='"+name+"'"; ResultSet rs=(stat1).executeQuery(sql); while(rs.next()){ registResult="用户名已存在！"; } //插入数据库 if(registResult==null){ sql="insert into Tb_Teacher(TeacherName,TeacherPassword,TeacherSex,TeacherAge,TeacherPof) values('"+name+"','"+password+"','"+sex+"','"+age+"','"+pro+"')"; int rs1=(stat1).executeUpdate(sql); if(rs1==1) registResult="注册成功！"; } rs.close(); stat1.close(); conn.close(); }catch(Exception e){ registResult=e.getMessage(); } //System.out.print(registResult); return registResult; } /* * 获取所有教师信息 */ public ArrayList getAllUsers() throws Exception{ ArrayList teachers=new ArrayList(); try{ //连接数据库查询 Connection conn=null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=DB_Teacher","sa","123456"); Statement stat1=(Statement) conn.createStatement(); String sql="select * from Tb_Teacher"; ResultSet rs=(stat1).executeQuery(sql); while(rs.next()){ Teacher teacher=new Teacher(); teacher.setTeahcerId(Integer.parseInt(rs.getString("TeahcerId"))); teacher.setTeacherName(rs.getString("TeacherName")); teacher.setTeacherPassword(rs.getString("TeacherPassword")); teacher.setTeacherPof(rs.getString("TeacherPof")); teacher.setTeacherSex(rs.getString("TeacherSex")); teacher.setTeacherAge(rs.getString("TeacherAge")); teachers.add(teacher); } rs.close(); stat1.close(); conn.close(); } catch(Exception e){ System.out.print(e.getMessage()); } return teachers; } /* * 删除某个教师 */ public String AdminDelTeacher() throws Exception{ try{ //连接数据库查询 Connection conn=null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=DB_Teacher","sa","123456"); Statement stat1=(Statement) conn.createStatement(); String sql="delete from Tb_Teacher where TeacherName='"+name+"'"; int rs=(stat1).executeUpdate(sql); stat1.close(); conn.close(); if(rs==1)return "success"; else return "fail"; } catch(Exception e){ System.out.print(e.getMessage()); return "fail"; } } /* * 获取某一教师信息 */ public Teacher getTeacherInfo() throws Exception{ Teacher teacher=null;; try{ //连接数据库查询 Connection conn=null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=DB_Teacher","sa","123456"); Statement stat1=(Statement) conn.createStatement(); String sql="select * from Tb_Teacher where TeacherName='"+name+"'"; ResultSet rs=(stat1).executeQuery(sql); while(rs.next()){ teacher=new Teacher(); teacher.setTeahcerId(rs.getInt("TeahcerId")); teacher.setTeacherName(rs.getString("TeacherName")); teacher.setTeacherPassword(rs.getString("TeacherPassword")); teacher.setTeacherAge(rs.getString("TeacherAge")); teacher.setTeacherSex(rs.getString("TeacherSex")); teacher.setTeacherPof(rs.getString("TeacherPof")); } rs.close(); stat1.close(); conn.close(); } catch(Exception e){ System.out.print(e.getMessage()); } return teacher; } /* * 保存修改后的用户信息 */ public String AdminSaveUserInfoChange() throws Exception{ String saveState=null; String sql=null; ResultSet rs=null; try{ //连接数据库查询 Connection conn=null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=DB_Teacher","sa","123456"); Statement stat1=(Statement) conn.createStatement(); /*查询想要修改的名字是否已存在 sql="select * from t_Admin where AdminName='"+admin.AdminName+"'"; rs=(stat1).executeQuery(sql); while(rs.next()){ saveState="管理员名称已存在,修改失败！"; } if(saveState==null){