博客涉及Java后端相关内容，但具体信息缺失。Java是后端开发常用语言，在后端开发领域有广泛应用。
|
1．本课题的研究目的和意义： 随着学校规模的不断扩大，实验室的不断增多，传统的计信系实验室管理已经无法满足计信系实验室管理需求，因此要将进行新的计信系实验室管理模式，因此开发设计了该系统，可以使得管理员在进行计信系实验室管理的时候更加的方便规范，节省管理的时间以及工作量。 本计信系实验室管理系统是为了管理员的需求以及情况进行开发研究的，系统的设计采用的是JAVA编程语言，JSP技术以及MYSQL数据库来进行系统的开发设计的，希望通过该系统可以减轻管理员的工作量，提高管理学效率。为了更好的满足用户的所有需求以及可以使得任何人都可以进行使用，该系统在操作方面设计的是非常简单易懂的，只需要经过简单的学习就可以进行系统的使用了。 本系统的使用可以实现本计信系实验室管理的信息化，可以方便管理员进行更加方便快捷的管理，可以提高实验室的管理效率。 【573】基于ssm实验室管理系统源码和论文 |
学校实验室是科研、教学的重要组成部分，是实现素质教育的基地，是培养具有创新意识和实践能力人才的摇篮。实验室的建设、实验室的管理、实验设备的配置与使用的科学化等不仅影响着学校的教学、科研水平，而且是关系到学校发展前途的大事。因此，学校实验室都迫切需要改革传统的实验室管理方法，对实验室实行现代化管理。 随着学校人数的不断增加，学生也在随着增加，更多的学生在这里进行实验室的学习以及能力的提升，但是，随着学生人数的不断增加，给学生的管理工作也带来了挑战，传统的计信系实验室管理模式是通过人工在纸上进行信息管理的，管理效率极低。随着实验室学生的不断增加，给管理者带来巨大的工作量，传统基于手工管理模式已经无法满足庞大的学生实验室信息的需求，随着信息化时代的到来，使得计信系实验室管理系统的开发成了必然。通过该系统，实验室管理人员可以对学生进行更清晰和规范的管理，所有的信息都一目了然，而且计算机拥有强大的存储能力，因此可以对庞大的信息进行存储，而且还不会出现丢失的现象，在寻找实验室学生信息上也非常的方便，因此开发该系统不仅可以对所有的信息进行存储而且管理人员在进行管理工作的时候更加的方便快捷。 学校人数的不断增加，对于实验室管理的需求也得到了更一步的发展，在对计信系实验室管理的过程中难免会出现很多问题，因此工作人员更倾向于寻找专业化的信息管理方式，来对计信系实验室管理进行更加规范的管理。 计信系实验室管理系统的开发和设计施根据用户的实际情况出发，然后通过对系统各方面进行了详细的分析之后，确保该系统在任何方面都是可以实行的，因此开发设计了该系统，最后对系统进行测试使得系统可以正常稳定的运行，并且所有的功能都能实现，形成一个非常完善的计信系实验室管理系统。在进行该系统的开发之前，我首先对开发该系统所用到的所有开发工具以及相关的技术进行了详细的了解，将系统的整体框架设计出来，然后根据实际的需求进行每一个功能模块的设计，将系统中所有的功能结果一一列举出来，然后进行需求分析，最后对所有的功能模块进行编码，最后完成系统的整体测试，实现系统的正常运行，确保系统的完整性以及可操作性。 现在网络的快速发展，人们的生活工作方式都将开始信息化，网络已经融入到我们的生活工作的各个领域中，网络技术的不断发展，人们的生活工作都在运用网络进行信息的管理。本文是为了顺应如今信息时代的网络在线需求，运用新时代技术，分析设计了一个计信系实验室管理系统，可以改变传统的实验室管理模式，大大提高管理的效率。 在学校的实验室管理过程中，发现了一些问题。其中如：在统筹安排各班级上实验课的时间需要人工实现，而且常常会出现由于第二批次实验冲突确需人员及时通知认可老师以及班级的麻烦。因此，伟乐方便机房管理，我们提出利用网络来管理实验室的方案，以学校的网络实验室的管理为该管理系统的应用背景，开发一个机遇网络的实验室管理系统。因此，开发这样一套管理软件成为很有必要的事情，它能够具体化、合理化的管理实验室设备以及相关信息，用结构化的思维方式去了解计算机的工作原理。 本系统是针对目前实验室手工管理效率低下，缺乏安全性、可控性等缺点，以校园网为依托，采用科学、高效的教学管理方式，使学校的教学资源得到充分的利用。本系统主要实现了教师根据实际教学情况预约实验室、查看预约结果，学生查询实验室教学安排，实验室管理员对实验室的管理、用户信息的管理和系统消息发布等功能，同时系统提供了简单友好的用户界面，并通过身份验证机制实现了系统的安全性。考虑到可能出现的教师同时预约实验室的情况，本系统采用了预约时避免冲突、受理时解决冲突的方法，尽最大努力实现实验室资源的优化配置。系统具有网络化、界面友好、操作简单、功能强大、管理方便等优点，能够完全按照用户的需要，稳定、安全快速地运行于校园局域网之上。最后总结了本系统的不足之处，和还有待开发的后续工作。
【573】基于ssm实验室管理系统源码和论文 |
package control;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUpload;
import org.apache.commons.fileupload.RequestContext;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.fileupload.servlet.ServletRequestContext;
import util.Info;
import util.StrUtil;
import dao.CommDAO;
public class MainCtrl extends HttpServlet {
public MainCtrl() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void go(String url,HttpServletRequest request, HttpServletResponse response)
{
try {
request.getRequestDispatcher(url).forward(request, response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void gor(String url,HttpServletRequest request, HttpServletResponse response)
{
try {
response.sendRedirect(url);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String ac = request.getParameter("ac");
if(ac==null)ac="";
CommDAO dao = new CommDAO();
String date = Info.getDateStr();
String today = date.substring(0,10);
String tomonth = date.substring(0,7);
HttpSession session = request.getSession();
if(ac.equals("login"))
{
String pagerandom = request.getParameter("pagerandom")==null?"":request.getParameter("pagerandom");
String random = (String)request.getSession().getAttribute("random");
if(!pagerandom.equals(random)&&request.getParameter("a")!=null)
{
request.setAttribute("random", "");
go("/admin/login.jsp", request, response);
}
else{
String username = request.getParameter("uname");
String password = request.getParameter("upass");
String utype = request.getParameter("utype");
request.getSession().setAttribute("utype", utype);
List<HashMap> list = dao
.select("select * from sysuser where status='正常' and uname='"
+ username + "'");
if (list.size() == 1) {
HashMap map = list.get(0);
List<HashMap> ulist = dao
.select("select * from sysuser where utype='"+utype+"' and uname='"
+ username + "' and upass='" + password
+ "'");
if (ulist.size() == 1&& password.equals(map.get("upass").toString())) {
request.getSession().setAttribute("admin", map);
gor("/experiments/admin/index.jsp", request, response);
} else {
request.setAttribute("error", "");
go("/admin/login.jsp", request, response);
}
} else {
request.setAttribute("error", "");
go("/admin/login.jsp", request, response);
}
}
}
//修改密码
if(ac.equals("uppass"))
{
String userpass = request.getParameter("upass");
String copyuserpass = request.getParameter("copyuserpass");
HashMap user = dao.getmap(Info.getUser(request).get("id").toString(), "sysuser");
String id = (String)user.get("id");
String sql = "update sysuser set upass='"+userpass+"' where id="+id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/uppass.jsp", request, response);
}
if(ac.equals("uploaddoc"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploaddoc.jsp?docname="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploaddoc2"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploaddoc2.jsp?docname="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploaddoc3"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploaddoc3.jsp?docname="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
//导excel
if(ac.equals("importexcel"))
{
String page = request.getParameter("page");
String whzdstr = request.getParameter("whzdstr");
String tablename = request.getParameter("tablename");
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
if(filename.indexOf(".xls")>-1)
{
Workbook workbook;
try {
workbook = Workbook.getWorkbook(new File(request.getRealPath("/upfile/")+"/"+filename));
//通过Workbook的getSheet方法选择第一个工作簿（从0开始）
Sheet sheet = workbook.getSheet(0);
//通过Sheet方法的getCell方法选择位置为C2的单元格（两个参数都从0开始）
//int empty = 0;
for(int i=1;i<1000;i++)
{
Cell cell = null;
try{
String isql = "insert into "+tablename+"(";
for(String str:whzdstr.split("-"))
{
isql+=str+",";
}
isql = isql.substring(0,isql.length()-1);
isql+=")values(";
int j=0;
int empty = 1;
for(String str:whzdstr.split("-"))
{
cell = sheet.getCell(j,i);
isql+="'"+cell.getContents()+"',";
String content = cell.getContents()==null?"":cell.getContents();
if(!"".equals(content.trim()))
{
empty = 0;
}
j++;
}
if(empty==1)continue;
isql = isql.substring(0,isql.length()-1);
isql+=")";
dao.commOper(isql);
}catch (Exception e) {
continue;
}
}
workbook.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
go("/admin/"+page+"?docname="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploadimg"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploadimg.jsp?filename="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploadimg2"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploadimg2.jsp?filename="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploadimg3"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploadimg3.jsp?filename="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploadimg4"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploadimg4.jsp?filename="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploadimg5"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploadimg5.jsp?filename="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
//sysusertj.jsp请求处理开始
if(ac.equals("sysusertj")){
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String savetime = date;
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String utype = "系统管理员";
String sql = "insert into sysuser(uname,upass,tname,sex,tel,depart,sfid,savetime,filename,utype "+
")values('"+uname+"','"+upass+"','"+tname+"','"+sex+"','"+tel+"','"+depart+"','"+sfid+"','"+savetime+"','"+filename+"','"+utype+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/sysusertj.jsp");
}
//sysusertj.jsp请求处理结束
//sysuserxg.jsp请求处理开始
if(ac.equals("sysuserxg")){
String id = request.getParameter("id");
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set uname='"+uname+"',upass='"+upass+"',tname='"+tname+"',sex='"+sex+"',tel='"+tel+"',depart='"+depart+"',sfid='"+sfid+"',filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/sysuserxg.jsp?id="+id+"");
}
//sysuserxg.jsp请求处理结束
//sysysusertj.jsp请求处理开始
if(ac.equals("sysysusertj")){
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String savetime = date;
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String utype = "实验室管理员";
String sql = "insert into sysuser(uname,upass,tname,sex,tel,depart,sfid,savetime,filename,utype "+
")values('"+uname+"','"+upass+"','"+tname+"','"+sex+"','"+tel+"','"+depart+"','"+sfid+"','"+savetime+"','"+filename+"','"+utype+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/sysysusertj.jsp");
}
//sysysusertj.jsp请求处理结束
//sysysuserxg.jsp请求处理开始
if(ac.equals("sysysuserxg")){
String id = request.getParameter("id");
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set uname='"+uname+"',upass='"+upass+"',tname='"+tname+"',sex='"+sex+"',tel='"+tel+"',depart='"+depart+"',sfid='"+sfid+"',filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/sysysuserxg.jsp?id="+id+"");
}
//sysysuserxg.jsp请求处理结束
//pvisysysuserxg.jsp请求处理开始
if(ac.equals("pvisysysuserxg")){
String id = request.getParameter("id");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvisysysuserxg.jsp?id="+id+"");
}
//pvisysysuserxg.jsp请求处理结束
//zblssysusertj.jsp请求处理开始
if(ac.equals("zblssysusertj")){
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String savetime = date;
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String utype = "值班老师";
String sql = "insert into sysuser(uname,upass,tname,sex,tel,depart,sfid,savetime,filename,utype "+
")values('"+uname+"','"+upass+"','"+tname+"','"+sex+"','"+tel+"','"+depart+"','"+sfid+"','"+savetime+"','"+filename+"','"+utype+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/zblssysusertj.jsp");
}
//zblssysusertj.jsp请求处理结束
//zblssysuserxg.jsp请求处理开始
if(ac.equals("zblssysuserxg")){
String id = request.getParameter("id");
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set uname='"+uname+"',upass='"+upass+"',tname='"+tname+"',sex='"+sex+"',tel='"+tel+"',depart='"+depart+"',sfid='"+sfid+"',filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/zblssysuserxg.jsp?id="+id+"");
}
//zblssysuserxg.jsp请求处理结束
//pvizblssysuserxg.jsp请求处理开始
if(ac.equals("pvizblssysuserxg")){
String id = request.getParameter("id");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvizblssysuserxg.jsp?id="+id+"");
}
//pvizblssysuserxg.jsp请求处理结束
//zbxssysusertj.jsp请求处理开始
if(ac.equals("zbxssysusertj")){
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String savetime = date;
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String utype = "值班学生";
String sql = "insert into sysuser(uname,upass,tname,sex,tel,depart,sfid,savetime,filename,utype "+
")values('"+uname+"','"+upass+"','"+tname+"','"+sex+"','"+tel+"','"+depart+"','"+sfid+"','"+savetime+"','"+filename+"','"+utype+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/zbxssysusertj.jsp");
}
//zbxssysusertj.jsp请求处理结束
//zbxssysuserxg.jsp请求处理开始
if(ac.equals("zbxssysuserxg")){
String id = request.getParameter("id");
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set uname='"+uname+"',upass='"+upass+"',tname='"+tname+"',sex='"+sex+"',tel='"+tel+"',depart='"+depart+"',sfid='"+sfid+"',filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/zbxssysuserxg.jsp?id="+id+"");
}
//zbxssysuserxg.jsp请求处理结束
//pvizbxssysuserxg.jsp请求处理开始
if(ac.equals("pvizbxssysuserxg")){
String id = request.getParameter("id");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvizbxssysuserxg.jsp?id="+id+"");
}
//pvizbxssysuserxg.jsp请求处理结束
//sklssysusertj.jsp请求处理开始
if(ac.equals("sklssysusertj")){
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String savetime = date;
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String utype = "授课老师";
String sql = "insert into sysuser(uname,upass,tname,sex,tel,depart,sfid,savetime,filename,utype "+
")values('"+uname+"','"+upass+"','"+tname+"','"+sex+"','"+tel+"','"+depart+"','"+sfid+"','"+savetime+"','"+filename+"','"+utype+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/sklssysusertj.jsp");
}
//sklssysusertj.jsp请求处理结束
//sklssysuserxg.jsp请求处理开始
if(ac.equals("sklssysuserxg")){
String id = request.getParameter("id");
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set uname='"+uname+"',upass='"+upass+"',tname='"+tname+"',sex='"+sex+"',tel='"+tel+"',depart='"+depart+"',sfid='"+sfid+"',filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/sklssysuserxg.jsp?id="+id+"");
}
//sklssysuserxg.jsp请求处理结束
//pvisklssysuserxg.jsp请求处理开始
if(ac.equals("pvisklssysuserxg")){
String id = request.getParameter("id");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvisklssysuserxg.jsp?id="+id+"");
}
//pvisklssysuserxg.jsp请求处理结束
//skxssysusertj.jsp请求处理开始
if(ac.equals("skxssysusertj")){
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String savetime = date;
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String utype = "学生";
String sql = "insert into sysuser(uname,upass,tname,sex,tel,depart,sfid,savetime,filename,utype "+
")values('"+uname+"','"+upass+"','"+tname+"','"+sex+"','"+tel+"','"+depart+"','"+sfid+"','"+savetime+"','"+filename+"','"+utype+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/skxssysusertj.jsp");
}
//skxssysusertj.jsp请求处理结束
//skxssysuserxg.jsp请求处理开始
if(ac.equals("skxssysuserxg")){
String id = request.getParameter("id");
String uname = request.getParameter("uname")==null?"":request.getParameter("uname");
String upass = request.getParameter("upass")==null?"":request.getParameter("upass");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set uname='"+uname+"',upass='"+upass+"',tname='"+tname+"',sex='"+sex+"',tel='"+tel+"',depart='"+depart+"',sfid='"+sfid+"',filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/skxssysuserxg.jsp?id="+id+"");
}
//skxssysuserxg.jsp请求处理结束
//pviskxssysuserxg.jsp请求处理开始
if(ac.equals("pviskxssysuserxg")){
String id = request.getParameter("id");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pviskxssysuserxg.jsp?id="+id+"");
}
//pviskxssysuserxg.jsp请求处理结束
//psysuserxg.jsp请求处理开始
if(ac.equals("psysuserxg")){
String id = request.getParameter("id");
String tname = request.getParameter("tname")==null?"":request.getParameter("tname");
String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
String tel = request.getParameter("tel")==null?"":request.getParameter("tel");
String depart = request.getParameter("depart")==null?"":request.getParameter("depart");
String sfid = request.getParameter("sfid")==null?"":request.getParameter("sfid");
String filename = request.getParameter("filename")==null?"":request.getParameter("filename");
String sql = "update sysuser set tname='"+tname+"',sex='"+sex+"',tel='"+tel+"',depart='"+depart+"',sfid='"+sfid+"',filename='"+filename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/psysuserxg.jsp?id="+id+"");
}
//psysuserxg.jsp请求处理结束
//mroomtj.jsp请求处理开始
if(ac.equals("mroomtj")){
String mno = request.getParameter("mno")==null?"":request.getParameter("mno");
String status = request.getParameter("status")==null?"":request.getParameter("status");
String sql = "insert into mroom(mno,status "+
")values('"+mno+"','"+status+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/mroomtj.jsp");
}
//mroomtj.jsp请求处理结束
//mroomxg.jsp请求处理开始
if(ac.equals("mroomxg")){
String id = request.getParameter("id");
String mno = request.getParameter("mno")==null?"":request.getParameter("mno");
String status = request.getParameter("status")==null?"":request.getParameter("status");
String sql = "update mroom set mno='"+mno+"',status='"+status+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/mroomxg.jsp?id="+id+"");
}
//mroomxg.jsp请求处理结束
//pvimroomxg.jsp请求处理开始
if(ac.equals("pvimroomxg")){
String id = request.getParameter("id");
String sql = "update mroom set where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvimroomxg.jsp?id="+id+"");
}
//pvimroomxg.jsp请求处理结束
//computerstj.jsp请求处理开始
if(ac.equals("computerstj")){
String rno = request.getParameter("rno")==null?"":request.getParameter("rno");
String rnokey = dao.getID("computers","rno","mroom","mno~hnoname",rno);
String cno = request.getParameter("cno")==null?"":request.getParameter("cno");
String status = request.getParameter("status")==null?"":request.getParameter("status");
String remo = request.getParameter("remo")==null?"":request.getParameter("remo");
String sql = "insert into computers(rno,rnokey,cno,status,remo "+
")values('"+rno+"','"+rnokey+"','"+cno+"','"+status+"','"+remo+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/computerstj.jsp");
}
//computerstj.jsp请求处理结束
//classadjtj.jsp请求处理开始
if(ac.equals("classadjtj")){
String cname = request.getParameter("cname")==null?"":request.getParameter("cname");
String stime = request.getParameter("stime")==null?"":request.getParameter("stime");
String etime = request.getParameter("etime")==null?"":request.getParameter("etime");
String suname = request.getParameter("suname")==null?"":request.getParameter("suname");
String sunamekey = dao.getID("classadj","suname","sysuser","uname~hnoname",suname);
String rno = request.getParameter("rno")==null?"":request.getParameter("rno");
String rnokey = dao.getID("classadj","rno","mroom","mno~hnoname",rno);
String frgroupno = request.getParameter("frgroupno");
String dytablename = request.getParameter("dytablename");
String dytabdelrows = request.getParameter("dytab_del_rows");
dao.insertDYTable(dytablename, frgroupno,dytabdelrows,request);
String sql = "insert into classadj(cname,stime,etime,suname,sunamekey,rno,rnokey,frgroupno,stus "+
")values('"+cname+"','"+stime+"','"+etime+"','"+suname+"','"+sunamekey+"','"+rno+"','"+rnokey+"','"+frgroupno+"','dytab-"+dytablename+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/classadjtj.jsp");
}
//classadjtj.jsp请求处理结束
//classadjxg.jsp请求处理开始
if(ac.equals("classadjxg")){
String id = request.getParameter("id");
String cname = request.getParameter("cname")==null?"":request.getParameter("cname");
String stime = request.getParameter("stime")==null?"":request.getParameter("stime");
String etime = request.getParameter("etime")==null?"":request.getParameter("etime");
String suname = request.getParameter("suname")==null?"":request.getParameter("suname");
String sunamekey = dao.getID("classadj","suname","sysuser","uname~hnoname",suname);
String rno = request.getParameter("rno")==null?"":request.getParameter("rno");
String rnokey = dao.getID("classadj","rno","mroom","mno~hnoname",rno);
String frgroupno = request.getParameter("frgroupno");
String dytablename = request.getParameter("dytablename");
String dytabdelrows = request.getParameter("dytab_del_rows");
dao.insertDYTable(dytablename, frgroupno,dytabdelrows,request);
String sql = "update classadj set cname='"+cname+"',stime='"+stime+"',etime='"+etime+"',suname='"+suname+"',sunamekey='"+sunamekey+"',rno='"+rno+"',rnokey='"+rnokey+"',frgroupno='"+frgroupno+"',stus='dytab-"+dytablename+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/classadjxg.jsp?id="+id+"");
}
//classadjxg.jsp请求处理结束
//pviclassadjxg.jsp请求处理开始
if(ac.equals("pviclassadjxg")){
String id = request.getParameter("id");
String sql = "update classadj set where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pviclassadjxg.jsp?id="+id+"");
}
//pviclassadjxg.jsp请求处理结束
//sshhworksxg.jsp请求处理开始
if(ac.equals("sshhworksxg")){
String id = request.getParameter("id");
String sql = "update hworks set where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/sshhworksxg.jsp?id="+id+"");
}
//sshhworksxg.jsp请求处理结束
//hworkstj.jsp请求处理开始
if(ac.equals("hworkstj")){
String cname = request.getParameter("cname")==null?"":request.getParameter("cname");
String cnamekey = dao.getID("hworks","cname","","",cname);
String tno = request.getParameter("tno")==null?"":request.getParameter("tno");
String savetime = date;
String docname = request.getParameter("docname")==null?"":request.getParameter("docname");
String sno = Info.getUser(request).get("uname").toString();
String sname = Info.getUser(request).get("tname").toString();
String sdepart = Info.getUser(request).get("depart").toString();
String fshstatus = "待批改";
String sql = "insert into hworks(cname,cnamekey,tno,savetime,docname,sno,sname,sdepart,fshstatus "+
")values('"+cname+"','"+cnamekey+"','"+tno+"','"+savetime+"','"+docname+"','"+sno+"','"+sname+"','"+sdepart+"','"+fshstatus+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/hworkstj.jsp");
}
//hworkstj.jsp请求处理结束
//hworksxg.jsp请求处理开始
if(ac.equals("hworksxg")){
String id = request.getParameter("id");
String cname = request.getParameter("cname")==null?"":request.getParameter("cname");
String cnamekey = dao.getID("hworks","cname","","",cname);
String tno = request.getParameter("tno")==null?"":request.getParameter("tno");
String docname = request.getParameter("docname")==null?"":request.getParameter("docname");
String sql = "update hworks set cname='"+cname+"',cnamekey='"+cnamekey+"',tno='"+tno+"',docname='"+docname+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/hworksxg.jsp?id="+id+"");
}
//hworksxg.jsp请求处理结束
//fshhworksxg.jsp请求处理开始
if(ac.equals("fshhworksxg")){
String id = request.getParameter("id");
String fshstatus = request.getParameter("fshstatus")==null?"":request.getParameter("fshstatus");
String fshscore = request.getParameter("fshscore")==null?"":request.getParameter("fshscore");
String fshremo = request.getParameter("fshremo")==null?"":request.getParameter("fshremo");
String sql = "update hworks set fshstatus='"+fshstatus+"',fshscore='"+fshscore+"',fshremo='"+fshremo+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/fshhworksxg.jsp?id="+id+"");
}
//fshhworksxg.jsp请求处理结束
//pvihworksxg.jsp请求处理开始
if(ac.equals("pvihworksxg")){
String id = request.getParameter("id");
String sql = "update hworks set where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvihworksxg.jsp?id="+id+"");
}
//pvihworksxg.jsp请求处理结束
//filestj.jsp请求处理开始
if(ac.equals("filestj")){
String subject = request.getParameter("subject")==null?"":request.getParameter("subject");
String ptitle = request.getParameter("ptitle")==null?"":request.getParameter("ptitle");
String cont = request.getParameter("cont")==null?"":request.getParameter("cont");
String savetime = date;
String docname = request.getParameter("docname")==null?"":request.getParameter("docname");
String uname = Info.getUser(request).get("uname").toString();
String tname = Info.getUser(request).get("tname").toString();
String sql = "insert into files(subject,ptitle,cont,savetime,docname,uname,tname "+
")values('"+subject+"','"+ptitle+"','"+cont+"','"+savetime+"','"+docname+"','"+uname+"','"+tname+"')";
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/filestj.jsp");
}
//filestj.jsp请求处理结束
//filesxg.jsp请求处理开始
if(ac.equals("filesxg")){
String id = request.getParameter("id");
String subject = request.getParameter("subject")==null?"":request.getParameter("subject");
String ptitle = request.getParameter("ptitle")==null?"":request.getParameter("ptitle");
String cont = request.getParameter("cont")==null?"":request.getParameter("cont");
String docname = request.getParameter("docname")==null?"":request.getParameter("docname");
String sql = "update files set subject='"+subject+"',ptitle='"+ptitle+"',cont='"+cont+"',docname='"+docname+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/filesxg.jsp?id="+id+"");
}
//filesxg.jsp请求处理结束
//pvifilesxg.jsp请求处理开始
if(ac.equals("pvifilesxg")){
String id = request.getParameter("id");
String sql = "update files set where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvifilesxg.jsp?id="+id+"");
}
//pvifilesxg.jsp请求处理结束
//computersxg.jsp请求处理开始
if(ac.equals("computersxg")){
String id = request.getParameter("id");
String rno = request.getParameter("rno")==null?"":request.getParameter("rno");
String rnokey = dao.getID("computers","rno","mroom","mno~hnoname",rno);
String cno = request.getParameter("cno")==null?"":request.getParameter("cno");
String status = request.getParameter("status")==null?"":request.getParameter("status");
String remo = request.getParameter("remo")==null?"":request.getParameter("remo");
String sql = "update computers set rno='"+rno+"',rnokey='"+rnokey+"',cno='"+cno+"',status='"+status+"',remo='"+remo+"' where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/computersxg.jsp?id="+id+"");
}
//computersxg.jsp请求处理结束
//pvicomputersxg.jsp请求处理开始
if(ac.equals("pvicomputersxg")){
String id = request.getParameter("id");
String sql = "update computers set where id="+id ;
dao.commOper(sql);
session.setAttribute("suc", "suc");
response.sendRedirect("/experiments/admin/pvicomputersxg.jsp?id="+id+"");
}
//pvicomputersxg.jsp请求处理结束
//--业务层代码块结束--
dao.updateById("computers","rno","mroom","mno~hnoname","");
dao.updateById("classadj","suname","sysuser","uname~hnoname","");
dao.updateById("classadj","rno","mroom","mno~hnoname","");
dao.updateById("classadj","stus","classstus","","");
dao.updateById("classstus","sno","sysuser","uname~hnoname","");
dao.updateById("classstus","sname","sysuser","tname~hnoname","sno");
dao.updateById("classstus","sdepart","sysuser","depart~hnoname","sno");
dao.updateById("hworks","cname","","","");
dao.close();
out.flush();
out.close();
}
public void init() throws ServletException {
// Put your code here
}
}
扫一扫
1092
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
