?? stuupdateservlet.java
字號:
package com.sevenEleven.servlet.admin2;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.sevenEleven.javaBean.CDBOracle;
/**
* Servlet implementation class for Servlet: StuUpdateServlet
*
*/
public class StuUpdateServlet extends javax.servlet.http.HttpServlet implements
javax.servlet.Servlet {
/**
*
*/
private static final long serialVersionUID = 1L;
/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#HttpServlet()
*/
public StuUpdateServlet() {
super();
}
/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request,
* HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request, response);
}
/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request,
* HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String SID = request.getParameter("sid");
String SNUMBER = request.getParameter("username");
String SNAME = request.getParameter("name");
String SPASSWORD = request.getParameter("password");
String cname = request.getParameter("cname");
// String actionregister = request.getParameter("action");
/*
* System.out.print(sid); System.out.print(name);
* System.out.print(password); System.out.print(password2);
* System.out.print(cname);
*/
String sql = "update student set S_NAME='" + SNAME + "',S_NUMBER='"
+ SNUMBER + "',S_PASSWORD='" + SPASSWORD + "',C_ID=" + cname
+ " where S_ID=" + SID;
// CConnectMSSQL db = new CConnectMSSQL();
//System.out.print(sql);
CDBOracle db = new CDBOracle();
db.executeUpdate(sql);
db.execute("commit");
// System.out.print("success!!!!??");
// request.getRequestDispatcher("show_all_student.jsp").forward(
// request, response);
response.sendRedirect("info_admin.jsp");
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -