?? dbselectservlet.java
字號:
package ch03.section05;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import ch03.section04.*;
public class DBSelectServlet
extends HttpServlet {
String sqlStr;
static final private String CONTENT_TYPE = "text/html; charset=gb2312";
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
DBOperator db = new DBOperator();
HttpSession session = request.getSession();
try {
String studentID = request.getParameter("studentID");
if (studentID == null || studentID.equals("")) {
sqlStr =
"select studentID,studentName,studentAge,studentGrade from ch03section04 ";
ResultSet set = db.executeQuery(sqlStr, new String("access"));
session.setAttribute("set", set);
response.sendRedirect("../ch03/section05/DBModifySet.jsp");
return;
}
else {
sqlStr =
"select studentID,studentName,studentAge,studentGrade from ch03section04 where studentID = " +
studentID + "";
ResultSet set = db.executeQuery(sqlStr, new String("access"));
session.setAttribute("set", set);
session.setAttribute("studentID", studentID);
response.sendRedirect("../ch03/section05/ModifyDOSet.jsp");
return;
}
}
catch (Exception ex) {
System.out.println(ex.toString());
}
finally {
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}
public void destroy() {
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -