addservlet.java

来自「java+oracle实现学生管理系统 学生信息的增删改查」· Java 代码 · 共 86 行

JAVA
86 行
字号 
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);
     }
}

addservlet.java - 源码说明

本页面展示了「java+oracle实现学生管理系统 学生信息的增删改查」中的 addservlet.java 源码文件，采用 Java 编程语言编写，共 86 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与学生管理系统相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?