基于javaweb+mysql的ssm驾校管理系统(java+ssm+mysql+jsp)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SSM驾校管理系统(java+ssm+mysql+jsp)
管理员:admin 密码:123456
学员:zhangsan 密码:123456
教员:T102 密码:123456
List<TeacherAssment> list=ts.getTeaAssmentInfoList(startNum, 4);
Map<String,Object> map=new HashMap<String,Object>();
map.put("list" , list);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/getTeacherAssmentInfoById")
public void getTeacherAssmentInfoById(int id,PrintWriter pw){
TeacherAssment teacherAssment=ts.getTeaAssmentInfoByTeaId(id);
System.out.println("----===="+teacherAssment.toString());
Map<String,Object> map=new HashMap<String,Object>();
map.put("teacherAssment" , teacherAssment);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/toModifyTeacherAssmentInfoById")
public String toModifyTeacherAssmentInfoById(int id ,Model model){
TeacherAssment teacherAssment=ts.getTeaAssmentInfoByTeaId(id);
model.addAttribute("teacherAssment" , teacherAssment);
return"/jsp/teacherAssment_amodify.jsp";
}
@RequestMapping("/teacherAssment/ModifyTeacherAssmentInfoById")
public String ModifyPage(TeacherAssment teacherAssment){
boolean flag=ts.modifyTeaAssmentInfoById(teacherAssment);
return"redirect:/teacherAssment/toTAInfoPage";
}
@RequestMapping("/teacherAssment/toDeleteTeacherAssmentInfoById")
public void toDeleteTeacherAssmentInfoById(int id,PrintWriter pw){
boolean flag=false;
flag=ts.deleteTeacherAssmentInfoById(id);
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
@RequestMapping("/teacherAssment/toTargetTeacherAssmentInfoPage")
public void toTargetTeacherAssmentInfoPage(Integer Page,PrintWriter pw){
int startNum=(Page-1)*2;//开始坐标
List<TeacherAssment> list=ts.getTeaAssmentInfoList(startNum, 4);
Map<String,Object> map=new HashMap<String,Object>();
map.put("list" , list);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/getTeacherAssmentInfoById")
public void getTeacherAssmentInfoById(int id,PrintWriter pw){
TeacherAssment teacherAssment=ts.getTeaAssmentInfoByTeaId(id);
System.out.println("----===="+teacherAssment.toString());
Map<String,Object> map=new HashMap<String,Object>();
map.put("teacherAssment" , teacherAssment);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/toModifyTeacherAssmentInfoById")
public String toModifyTeacherAssmentInfoById(int id ,Model model){
TeacherAssment teacherAssment=ts.getTeaAssmentInfoByTeaId(id);
model.addAttribute("teacherAssment" , teacherAssment);
return"/jsp/teacherAssment_amodify.jsp";
}
@RequestMapping("/student/getStudentAssmentList")
public String getStudentAssmentList(HttpServletRequest request, Model model) {
HttpSession session = request.getSession();
String userAccount = (String) session.getAttribute("account");
System.out.println("账号" + userAccount);
List<TeacherAssment> list = ts.getStudentAssmentByStuId(userAccount, 0, 4);
System.out.println("获取信息----" + list);
int count = ts.getTeacherAssmentCount();
System.out.println(list.toString());
model.addAttribute("list", list);
model.addAttribute("count", count);
return "/jsp/student_assment.jsp";
}
@RequestMapping("/student/toTargetStudentAssmentList")
public void toTargetStudentAssmentList(Integer Page, HttpServletRequest request, PrintWriter pw) {
System.out.println(Page + "<<<<<<<<<------");
int startNum = (Page - 1) * 4;// 开始坐标
HttpSession session = request.getSession();
String userAccount = (String) session.getAttribute("account");
List<TeacherAssment> list = ts.getStudentAssmentByStuId(userAccount, startNum, 4);
Map<String, Object> map = new HashMap<String, Object>();
map.put("list", list);
ObjectMapper om = new ObjectMapper();
try {
String jsonString = om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
} catch (JsonProcessingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/student/studentToAddTeacherAssmentInfo")
public void toAddTeacherAssmentInfoById(HttpServletRequest request, TeacherAssment teacherAssment, PrintWriter pw) {
boolean flag = false;
HttpSession session = request.getSession();
@RequestMapping("/user/getStuScore")
public String getStuScore(String account, Model model) {
System.out.println("查询成绩" + account);
List<Student> list = ss.getStuScore(account);
System.out.println(list.toString() + "======" + list.size());
model.addAttribute("list", list);
model.addAttribute("account", account);
return "/jsp/stu_score.jsp";
}
@RequestMapping("/user/getStuScoreBySession")
public String getStuScore(HttpServletRequest request, Model model) {
HttpSession session = request.getSession();
String userAccount = (String) session.getAttribute("account");
List<Student> list = ss.getStuScore(userAccount);
System.out.println(list.toString() + "======" + list.size());
model.addAttribute("list", list);
model.addAttribute("account", userAccount);
return "/jsp/stu_score.jsp";
}
@RequestMapping("/user/toModifyStuScore")
public String toModifyStuScore() {
return "jsp/login.jsp";
}
@RequestMapping("/stu/modifyScore")
public void modifyScore(Student student, PrintWriter pw) {
ObjectMapper om = new ObjectMapper();
Map<String, Object> map = new HashMap<String, Object>();
boolean flag = false;
flag = ss.updateScoreInfo(student);
System.out.println(flag + "《《《-----");
map.put("flag", flag);
String jsonString;
try {
jsonString = om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
} catch (JsonProcessingException e) {
int startNum=(Page-1)*2;//开始坐标
List<Car> list=cs.getCarInfoList(startNum, 2);
Map<String,Object> map=new HashMap<String,Object>();
map.put("list" , list);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/car/getCarInfoById")
public void getCarInfoById(String car_id,PrintWriter pw){
Car car=cs.getCarInfoById(car_id);
Teacher teacher=ts.getTeaInfoByCarId(car_id);
Map<String,Object> map=new HashMap<String,Object>();
map.put("car" , car);
map.put("teacher" , teacher);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/car/toModifyCarInfoById")
public String toModifyPage(String carId ,Model model){
Car car=cs.getCarInfoById(carId);
model.addAttribute("car" , car);
return"/jsp/car_info_modify.jsp";
}
@RequestMapping("/car/ModifyCarInfoById")
public String ModifyPage(Car car){
System.out.println(car.toString());
boolean flag=cs.modifyCarInfoById(car);
return"redirect:/car/toCarInfoPage";
}
public void toDeleteFateInfoById(int id,PrintWriter pw){
boolean flag=false;
flag=fs.deleteFateInfoById(id);
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/fate/addFate")
public void addFate(Fate fate,PrintWriter pw){
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String fateTime=df.format(new Date());
fate.setFateTime(fateTime);
boolean flag=false;
flag=fs.addFate(fate);
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
}
}
@RequestMapping("/course/getSignalSchoolCourse")
public void getSignalSchoolCourse(String keywords,PrintWriter pw){
SchoolCourse schoolCourse=scs.getSignalSchoolCourseById(keywords);
Map<String,Object> map=new HashMap<String,Object>();
map.put("schoolCourse" , schoolCourse);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
}
}
@Controller
public class FateController {
@Autowired
FateService fs;
@RequestMapping("/fate/tofateInfoPage")
public String tofateInfoPage(Integer startPage,Integer Page,Model model){
//int startNum=(startPage-1)*Page;//开始坐标
List<Fate> list=fs.getFateList(0 , 4);
int count=fs.getCount();
model.addAttribute("list" , list);
model.addAttribute("count" , count);
return"/jsp/fate.jsp";
}
@RequestMapping("/fate/toTargetFateInfoPage")
public void toTargetFateInfoPage(Integer Page,PrintWriter pw){
int startNum=(Page-1)*4;//开始坐标
List<Fate> list=fs.getFateList(startNum , 4);
Map<String,Object> map=new HashMap<String,Object>();
map.put("list" , list);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
@Controller
public class FateController {
@Autowired
FateService fs;
@RequestMapping("/fate/tofateInfoPage")
public String tofateInfoPage(Integer startPage,Integer Page,Model model){
//int startNum=(startPage-1)*Page;//开始坐标
List<Fate> list=fs.getFateList(0 , 4);
int count=fs.getCount();
model.addAttribute("list" , list);
model.addAttribute("count" , count);
return"/jsp/fate.jsp";
}
@RequestMapping("/fate/toTargetFateInfoPage")
public void toTargetFateInfoPage(Integer Page,PrintWriter pw){
int startNum=(Page-1)*4;//开始坐标
List<Fate> list=fs.getFateList(startNum , 4);
Map<String,Object> map=new HashMap<String,Object>();
map.put("list" , list);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/fate/getFateInfoById")
public void getFateInfoById(String studentId,PrintWriter pw){
List<Fate> list=fs.getFateListBStudentId(studentId);
Map<String,Object> map=new HashMap<String,Object>();
StringBuffer sb=new StringBuffer();
for(int i=0;i<list.size();i++){
sb.append("编号:"+list.get(i).getId()+"      ");
sb.append("学生姓名:"+list.get(i).getStudent().getStudentName()+"       ");
sb.append("缴费项目:"+list.get(i).getCourse().getCourseName()+"       ");
sb.append("编缴费时间:"+list.get(i).getFateTime()+"      ");
sb.append("缴费金额:"+list.get(i).getMoney()+"      ");
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/course/toModSchoolCourseById")
public String toModSchoolCourseById(String keywords,Model model){
SchoolCourse schoolCourse=scs.getSignalSchoolCourseById(keywords);
model.addAttribute("schoolCourse" , schoolCourse);
System.out.println("获取到的信息-----"+schoolCourse);
return"/jsp/school_course_mod.jsp";
}
@RequestMapping("/course/ModSchoolCourseById")
public String toModSchoolCourseById(SchoolCourse schoolCourse,Model model){
System.out.println("更新----"+schoolCourse);
scs.updateSchoolCourseById(schoolCourse);
return"redirect:/course/toCourseList";
}
@RequestMapping("/course/getSignalSchoolCourse")
public void getSignalSchoolCourse(String keywords,PrintWriter pw){
SchoolCourse schoolCourse=scs.getSignalSchoolCourseById(keywords);
Map<String,Object> map=new HashMap<String,Object>();
map.put("schoolCourse" , schoolCourse);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
model.addAttribute("count" , count);
return"/jsp/teacher_assment.jsp";
}
@RequestMapping("/teacherAssment/toTargetTeacherAssmentInfoPage")
public void toTargetTeacherAssmentInfoPage(Integer Page,PrintWriter pw){
int startNum=(Page-1)*2;//开始坐标
List<TeacherAssment> list=ts.getTeaAssmentInfoList(startNum, 4);
Map<String,Object> map=new HashMap<String,Object>();
map.put("list" , list);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/getTeacherAssmentInfoById")
public void getTeacherAssmentInfoById(int id,PrintWriter pw){
TeacherAssment teacherAssment=ts.getTeaAssmentInfoByTeaId(id);
System.out.println("----===="+teacherAssment.toString());
Map<String,Object> map=new HashMap<String,Object>();
map.put("teacherAssment" , teacherAssment);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/toModifyTeacherAssmentInfoById")
flag=true;
}
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/course/toModSchoolCourseById")
public String toModSchoolCourseById(String keywords,Model model){
SchoolCourse schoolCourse=scs.getSignalSchoolCourseById(keywords);
model.addAttribute("schoolCourse" , schoolCourse);
System.out.println("获取到的信息-----"+schoolCourse);
return"/jsp/school_course_mod.jsp";
}
@RequestMapping("/course/ModSchoolCourseById")
public String toModSchoolCourseById(SchoolCourse schoolCourse,Model model){
System.out.println("更新----"+schoolCourse);
scs.updateSchoolCourseById(schoolCourse);
return"redirect:/course/toCourseList";
}
@RequestMapping("/course/getSignalSchoolCourse")
public void getSignalSchoolCourse(String keywords,PrintWriter pw){
SchoolCourse schoolCourse=scs.getSignalSchoolCourseById(keywords);
Map<String,Object> map=new HashMap<String,Object>();
map.put("schoolCourse" , schoolCourse);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
public void toDeleteFateInfoById(int id,PrintWriter pw){
boolean flag=false;
flag=fs.deleteFateInfoById(id);
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/fate/addFate")
public void addFate(Fate fate,PrintWriter pw){
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String fateTime=df.format(new Date());
fate.setFateTime(fateTime);
boolean flag=false;
flag=fs.addFate(fate);
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
}
@Controller
public class TeacherController {
@Autowired
SchoolCourseService sc;
@Autowired
TeacherService ts;
@Autowired
CarService cs;
@Autowired
TeacherAssmentService tas;
@RequestMapping("/tea/toGetCourseInfo")
public String toCourseInfo(){
return "/jsp/to_course_info.jsp";
}
@RequestMapping("/tea/GetCourseInfo")
public String CourseInfo(String tea_id,Model model){
System.out.println("进入查询");
List<SchoolCourse> list=sc.getCourseInfoByTeaId(tea_id);
Teacher teacher=ts.getCourseInfoByTeaId(tea_id);
System.out.println(teacher+"--->>"+list.toString());
model.addAttribute("list" , list);
model.addAttribute("teacher" , teacher);
return "/jsp/to_course_list.jsp";
}
@RequestMapping("/tea/GetCourseInfoBySession")
public String GetCourseInfoBySession(HttpServletRequest request,Model model){
HttpSession session=request.getSession();
String userAccount=(String)session.getAttribute("account");
List<SchoolCourse> list=sc.getCourseInfoByTeaId(userAccount);
Teacher teacher=ts.getCourseInfoByTeaId(userAccount);
System.out.println(teacher+"--->>"+list.toString());
model.addAttribute("list" , list);
model.addAttribute("teacher" , teacher);
return "/jsp/to_course_list.jsp";
}
@RequestMapping("/tea/toGetTeaListInfo")
public String toTeaList(Model model){
List<Teacher> list=ts.getTeaInfoList(0 , 3);
int count=ts.getTeacherCount();
System.out.println("数量"+count);
System.out.println(list.toString());
model.addAttribute("count" , count);
@Controller
public class UserController {
@Autowired
UserService us;
@Autowired
TeacherService ts;
@Autowired
StudentService ss;
@RequestMapping("/user/toStu")
public String stuInfo() {
return "/jsp/stu_info_modify.jsp";
}
@RequestMapping("/user/toTea")
public String teaInfo(String account) {
return "/jsp/tea_info_modify.jsp";
}
@RequestMapping("/user/getStuInfoById")
public String getUserInfo(String stuId, Model model) {
User user = us.getUserInfoById(stuId);
model.addAttribute("User", user);
return "/jsp/stuInfo.jsp";
}
@Controller
public class UserController {
@Autowired
UserService us;
@Autowired
TeacherService ts;
@Autowired
StudentService ss;
@RequestMapping("/user/toStu")
public String stuInfo() {
return "/jsp/stu_info_modify.jsp";
}
@RequestMapping("/user/toTea")
public String teaInfo(String account) {
return "/jsp/tea_info_modify.jsp";
}
@RequestMapping("/user/getStuInfoById")
public String getUserInfo(String stuId, Model model) {
User user = us.getUserInfoById(stuId);
model.addAttribute("User", user);
return;
}
@RequestMapping("/tea/toDeleteTeaInfoById")
public void deleteTeaInfoById(String tea_id,PrintWriter pw){
boolean flag=false;
flag=ts.deleteTeacherInfoById(tea_id);
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/tea/modifyTeacherById")
public String modifyTeacherById(Teacher teacher){
ts.modifyTeaInfoById(teacher);
return"redirect:/tea/toGetTeaListInfo";
}
@RequestMapping("/tea/addTeacher")
public void addTeacherInfo(Teacher teacher,Car car,PrintWriter pw){
boolean flag=false;
car.setCar_owner(teacher.getTea_name());
car.setStartTime(new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
cs.addCar(car);
flag=ts.addTeacher(teacher);
Map<String,Object> map=new HashMap<String,Object>();
map.put("flag" , flag);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
int startNum=(Page-1)*2;//开始坐标
List<TeacherAssment> list=ts.getTeaAssmentInfoList(startNum, 4);
Map<String,Object> map=new HashMap<String,Object>();
map.put("list" , list);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/getTeacherAssmentInfoById")
public void getTeacherAssmentInfoById(int id,PrintWriter pw){
TeacherAssment teacherAssment=ts.getTeaAssmentInfoByTeaId(id);
System.out.println("----===="+teacherAssment.toString());
Map<String,Object> map=new HashMap<String,Object>();
map.put("teacherAssment" , teacherAssment);
ObjectMapper om=new ObjectMapper();
try{
String jsonString =om.writeValueAsString(map);
pw.write(jsonString);
pw.flush();
pw.close();
}catch(JsonProcessingException e){
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
@RequestMapping("/teacherAssment/toModifyTeacherAssmentInfoById")
public String toModifyTeacherAssmentInfoById(int id ,Model model){
TeacherAssment teacherAssment=ts.getTeaAssmentInfoByTeaId(id);
model.addAttribute("teacherAssment" , teacherAssment);
return"/jsp/teacherAssment_amodify.jsp";
}
@RequestMapping("/teacherAssment/ModifyTeacherAssmentInfoById")
public String ModifyPage(TeacherAssment teacherAssment){
boolean flag=ts.modifyTeaAssmentInfoById(teacherAssment);
return"redirect:/teacherAssment/toTAInfoPage";
}
@RequestMapping("/teacherAssment/toDeleteTeacherAssmentInfoById")
public void toDeleteTeacherAssmentInfoById(int id,PrintWriter pw){