📄 add_class.java
字号:
package teachmanage.Servlets;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import teachmanage.DB_management.DBbean;
import java.sql.*;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2007</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class add_class extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException {
}
//Process the HTTP Get request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
DBbean mybean = new DBbean();
String Cno=request.getParameter("Cno");
String SCno = request.getParameter("SCno");
String COption = request.getParameter("COption");
String Cname=request.getParameter("Cname");
String Credit=request.getParameter("Credit");
String Type=request.getParameter("Type");
String Tno=request.getParameter("Tno");
String Week=request.getParameter("Week");
String CTime=request.getParameter("CTime");
String Local=request.getParameter("Local");
System.out.println(Cno);
String sql="insert into chx04_Course (Cno,Cname,Credit,Type) values ('"+Cno+"','"+Cname+"','"+Credit+"','"+Type+"')";
String sql_1 = "insert into chx05_SetCourse(Cno,SCno,COption,CTime,CLocal) values ('"+Cno+"','"+SCno+"','"+COption+"','"+CTime+"','"+Local+"')";
System.out.println(sql);
try
{
mybean.executeDML(sql);
mybean.executeDML(sql_1);
}
catch(SQLException e){}
out.println("<html>");
out.println("<head><title>add_class</title></head>");
out.println("<body bgcolor=\"#ffffff\">");
out.println("<center>");
out.println("<p>成功添加课程信息!</p>");
out.println("<a href='manager.jsp'>返回</a>");
out.println("</center>");
out.println("</body>");
out.println("</html>");
out.close();
}
//Clean up resources
public void destroy() {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -