📄 addservlet.java
字号:
package list.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import bean.listbean;
import data.DBUtil;
public class AddServlet extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException,IOException
{
request.setCharacterEncoding("GBK");
response.setContentType("text/html;charset=GBK");
String address = "unknownlist.jsp";
try
{
new oracle.jdbc.driver.OracleDriver();
String url="jdbc:oracle:thin:@localhost:1521:ora9i";
Connection conn = DriverManager.getConnection(url,"scott","tiger");
String sql = "insert into addrestlist values(?,?,?,?,?,?,?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1,request.getParameter("id"));
stmt.setString(2,request.getParameter("name"));
stmt.setString(3,request.getParameter("phone"));
stmt.setString(4,request.getParameter("mobile"));
stmt.setString(5,request.getParameter("address"));
stmt.setString(6,request.getParameter("email"));
stmt.setString(7,request.getParameter("qq"));
stmt.executeUpdate();
stmt.close();
conn.close();
address = "cachePages.jsp";
//PrintWriter out=response.getWriter();
//out.println("<html><head><title>");
//out.println("添加成功</title></head>");
//out.println("<body><center>succesfully!");
//
//out.println("<a href=\"cachePages.jsp\">ckick to main</a>");
//out.println("</center></body></html>");
RequestDispatcher dis = request.getRequestDispatcher(address);
dis.forward(request,response);
}
catch(SQLException e)
{
System.err.println(e);
}
}
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException,IOException
{
doGet(request,response);
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -