📄 sqlservlet.java
字号:
/*
* CheckServlet.java
*
* Created on 2008年4月25日, 下午12:34
*/
import java.io.*;
import java.net.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author wlz
* @version
*/
public class SqlServlet extends HttpServlet {
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
HttpSession hsession = request.getSession();
if(hsession.getAttribute("userid")==null){
out.println("<script language='javascript'>alert('未登陆')</script>");
return;
}
String action = request.getParameter("action");
int result = 0;
Connection conn = null;
Statement stat;
String hostName = "localhost"; // 主机名或者IP地址
String portNumber = "1433"; // 端口号，默认为1521
String databaseSID = "student"; // SID名称
String userName = "sa"; // 用户名
String password = "sa"; // 用户密码
String url = "jdbc:microsoft:sqlserver://" + hostName + ":" + portNumber +
";databaseName=" + databaseSID; // 连接字符串
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); // 装载驱动程序
conn = DriverManager.getConnection(url, userName, password); // 建立连接
} catch (Exception e) {
e.printStackTrace();
}
try {
String actionStat = "";
stat = conn.createStatement();
if(action.compareTo("insert")==0){
String insid = request.getParameter("insid");
String insname = request.getParameter("insname");
actionStat = "insert into lesson(courseID,courseName) values('"+insid+"','"+insname +"')";
stat.execute(actionStat);
out.println("<script language='javascript'>alert('插入成功："+insid+" "+insname +"')</script>");
}else if(action.compareTo("delete")==0){
String delid = request.getParameter("delid");
actionStat = "delete from lesson where courseID='"+delid+"'";
stat.execute(actionStat);
out.println("<script language='javascript'>alert('删除成功："+delid+"')</script>");
}else if(action.compareTo("update")==0){
String updname = request.getParameter("updname");
String updid = request.getParameter("updid");
actionStat = "update lesson set courseName='"+updname+"' where courseID='"+updid+"'" ;
stat.execute(actionStat);
out.println("<script language='javascript'>alert('修改成功："+updid+" "+updname +"')</script>");
} else{
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet Table</title>");
out.println("</head>");
out.println("<body>");
out.println("<table border='2'>" +
"<tr><td width='100'>111</td><td width='100'>222</td></tr>" +
"<tr><td>333</td><td>444</td></tr>" +
"<tr><td>555</td><td>666</td></tr>" +
"</table>");
out.println("</body>");
out.println("</html>");
}
} catch (Exception e) {
System.out.println("驱动错误!" + e.getMessage());
}
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -