教师档案管理系统

数据库采用musql ，用到的技术有jsp+servlet+jquery+js

package com.John.servlet;


import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.John.utils.JT;

public class AddnewTeacherServlet extends HttpServlet {

	@Override
	protected void doPost（HttpServletRequest req HttpServletResponse resp）
			throws ServletException IOException {

		
		req.setCharacterEncoding（“utf-8“）;
		String id = req.getParameter（“id“）;
		String psw = req.getParameter（“psw“）;
		String name = req.getParameter（“name“）;
		String gender = req.getParameter（“gender“）;
		String age = req.getParameter（“age“）;
		String birthdate = req.getParameter（“birthdate“）;
		String mianmao = req.getParameter（“mianmao“）;
		String nation = req.getParameter（“nation“）;
		String stature = req.getParameter（“stature“）;
		String weight = req.getParameter（“weight“）;
		String position = req.getParameter（“position“）;
		String positionchange = req.getParameter（“positionchange“）;
		String leavecondition = req.getParameter（“leavecondition“）;
		String telphone = req.getParameter（“telphone“）;
		String address = req.getParameter（“address“）;
		String sql = “insert into base_infor values（ ‘“ + id + “‘ ‘“ + name + “‘ ‘“ + gender+ “‘“ + age+ “ “ +
				“ ‘“ + birthdate+ “‘ ‘“ + mianmao+ “‘ ‘“ + nation+ “‘ “ +
				 stature+ “ “ + weight+ “  ‘“ + position+ “‘ ‘“ + 
				positionchange+ “‘ ‘“ + leavecondition+ “‘ ‘“ + telphone+ “‘‘“ + address+ “‘）“;
		String sql2 = “insert into user values （ ‘“ + id + “‘‘“ + name +“‘‘“+  psw+ “‘）“;
System.out.println（sql）;
System.out.println（sql2）;
		JT jt = new JT（）;
		jt.update（sql2）;
		int affectedRows = jt.update（sql）;
		req.setAttribute（“affectedRows“ affectedRows）;
		req.getRequestDispatcher（“addnewteacherresult.jsp“）.forward（req resp）;
		
		
		
	
	}
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        174  2013-12-06 14:12  readme.txt

     文件        529  2013-12-03 13:05  teacher_file_management_system\.classpath

     文件        337  2013-12-03 13:06  teacher_file_management_system\.mymetadata

     文件       1773  2013-12-03 14:07  teacher_file_management_system\.project

     文件        500  2013-12-03 13:06  teacher_file_management_system\.settings\.jsdtscope

     文件        364  2013-12-03 13:05  teacher_file_management_system\.settings\org.eclipse.jdt.core.prefs

     文件        502  2013-12-03 13:05  teacher_file_management_system\.settings\org.eclipse.wst.common.component

     文件        252  2013-12-03 13:05  teacher_file_management_system\.settings\org.eclipse.wst.common.project.facet.core.xml

     文件         49  2013-12-03 13:05  teacher_file_management_system\.settings\org.eclipse.wst.jsdt.ui.superType.container

     文件          6  2013-12-03 13:05  teacher_file_management_system\.settings\org.eclipse.wst.jsdt.ui.superType.name

     文件       1923  2013-12-04 14:03  teacher_file_management_system\src\com\John\servlet\AddnewTeacherServlet.java

     文件       1148  2013-12-04 21:28  teacher_file_management_system\src\com\John\servlet\AddTeacherAcademicServlet.java

     文件        978  2013-12-04 21:59  teacher_file_management_system\src\com\John\servlet\AddTeacherStudyServlet.java

     文件       1138  2013-12-04 20:25  teacher_file_management_system\src\com\John\servlet\AddTeacherWorkServlet.java

     文件        754  2013-12-04 19:34  teacher_file_management_system\src\com\John\servlet\DeleteAcademicServlet.java

     文件        879  2013-12-04 16:43  teacher_file_management_system\src\com\John\servlet\DeletebaseInforServlet.java

     文件        736  2013-12-04 20:01  teacher_file_management_system\src\com\John\servlet\DeleteStudyServlet.java

     文件        832  2013-12-04 18:12  teacher_file_management_system\src\com\John\servlet\DeleteWorkInforServlet.java

     文件       1245  2013-12-03 17:32  teacher_file_management_system\src\com\John\servlet\LoginServlet.java

     文件       1188  2013-12-04 19:29  teacher_file_management_system\src\com\John\servlet\ModifyAcademicServlet.java

     文件       1891  2013-12-04 13:20  teacher_file_management_system\src\com\John\servlet\ModifybaseInforServlet.java

     文件       1018  2013-12-04 19:52  teacher_file_management_system\src\com\John\servlet\ModifyStudyServlet.java

     文件       1255  2013-12-04 17:59  teacher_file_management_system\src\com\John\servlet\ModifyWorkInforServlet.java

     文件       1060  2013-12-04 10:22  teacher_file_management_system\src\com\John\servlet\QueryAcademicServlet.java

     文件       1147  2013-12-04 16:22  teacher_file_management_system\src\com\John\servlet\QuerybaseServlet.java

     文件        875  2013-12-03 20:54  teacher_file_management_system\src\com\John\servlet\QueryOtherInfor.java

     文件       1044  2013-12-04 10:57  teacher_file_management_system\src\com\John\servlet\QueryStudyServlet.java

     文件       1081  2013-12-04 10:04  teacher_file_management_system\src\com\John\servlet\QueryWorkServlet.java

     文件       3372  2013-12-03 13:52  teacher_file_management_system\src\com\John\utils\JT.java

     文件       7831  2013-12-03 13:08  teacher_file_management_system\src\com\John\utils\TimeHelper.java

............此处省略81个文件信息