⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 add_friend.java

📁 用jsp和servlet开发的简单通讯录
💻 JAVA
字号:
🔍 
package project1;

import java.io.IOException;
import java.io.PrintWriter;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import javax.servlet.*;
import javax.servlet.http.*;

import sun.jdbc.odbc.JdbcOdbcDriver;

public class add_friend extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";

    public void init(ServletConfig config) throws ServletException {
        super.init(config);
    }

    public void service(HttpServletRequest request, 
                        HttpServletResponse response) throws ServletException, IOException {response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        out.println("<html>");
        out.println("<head><title>add_friend</title></head>");
        out.println("<body>");
        //设定编码类型，以便正确解码
        request.setCharacterEncoding("GBK");
        //验证身份
        HttpSession sess = request.getSession();
        if((sess.getAttribute("token"))==null){
            out.print("对不起，请先登录");
            response.setHeader("Refresh","1;URL=login.jsp"); 
        }
        else{
        
            //获取客户端输入的朋友的信息。
            String frd_name,frd_sex,frd_type_id,frd_tele,frd_email,frd_birth,frd_describe,frd_belong;        
            frd_name=request.getParameter("frd_name");
            //out.println(frd_name);
            frd_sex=request.getParameter("frd_sex");
            //out.println(frd_sex);
            frd_type_id=request.getParameter("frd_type_id");
            //out.println(frd_type_id);
            frd_tele=request.getParameter("frd_tele");
            //out.println(frd_tele);
            frd_email=request.getParameter("frd_email");
            //out.println(frd_email);
            frd_birth=request.getParameter("frd_birth");
            //out.println(frd_birth);
            frd_describe=request.getParameter("frd_describe");
            //out.println(frd_describe);
            
            frd_belong = (String)sess.getAttribute("token");
            //out.println(frd_belong);
            
            String dbUrl="jdbc:odbc:myaddressbook"; //addressbook是odbc数据源名称
            Connection conn;
            PreparedStatement pst;
            try{
                //装载JDBC驱动程序;
                //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
                
                DriverManager.registerDriver(new JdbcOdbcDriver());
                ////以上两个语句可以互换////
                
                //创建一个数据库连接；
                conn=DriverManager.getConnection(dbUrl); 
                
               //组装标准的SQL语句
                pst=conn.prepareStatement("insert into friends (frd_name,frd_sex,frd_type_id,frd_tele,frd_email,frd_birth,frd_describe,frd_belong) values (?,?,?,?,?,?,?,?)");
                pst.setString(1,frd_name);
                pst.setString(2,frd_sex);
                pst.setString(3,frd_type_id);
                pst.setString(4,frd_tele);
                pst.setString(5,frd_email);
                pst.setString(6,frd_birth);
                pst.setString(7,frd_describe);
                pst.setString(8,frd_belong);
                //执行SQL语句
                pst.execute();
                out.print("<p align=center><font size=5>联系人添加成功！</font></p>");
                // 回收连接资源
                pst.close();
                conn.close();
                response.setHeader("Refresh","1;URL=list_all");
            }catch (Exception ex) {
                out.print("<p align=center><font size=5 color=red>联系人添加不成功！</font></p>");
                ex.printStackTrace();
            }
        }        
        out.println("</body></html>");
        out.close();
    }
}

⌨️ 快捷键说明

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