期中考试增删改查

青年志愿者服务网（20分）

 

1、项目需求：

为了适应社会主义市场经济发展的需要，推动青年志愿服务体系和多层次社会保障体系的建立和完善，促进青年健康成长，石家庄铁道大学急需建设青年志愿者服务网，推进石家庄铁道大学青年志愿者事业发展。

2.系统要求与功能设计

2.1 页面功能要求

（1）能够在Tomcat服务器中正确部署，并通过浏览器查看；（1分）

（2）网站页面整体风格统一；

 

 

 

 

图1 青年志愿者信息管理系统功能结构图

（3）主页面：要求显示志愿者登记、修改志愿者信息、删除志愿者信息、查询志愿者信息，志愿者信息浏览五个子菜单。（1分）

（4）志愿者登记页面：（5分）

①完成添加志愿者个人信息登记，基本信息如下表所示

②性别要求采用单选框形式，选项包括“男”、“女”两项；

③政治面目要求采用下拉框选择，选项内容包括“群众”、“共青团员”、“中共党员”三项。

④服务类别采用多选框形式选择，最多选择四项服务类别。

⑤点击“提交”按钮，保存成功则跳转到志愿者基本信息浏览界面，新录入的信息置顶显示。失败则提示错误信息，返回当前页面

评分标准：

①完成志愿者登记页面（未完成0分，完成1分）

②保存志愿者信息入库（未完成0分，完成1分）

③性别单选框录入（未完成0分，完成0.5分）

④ 政治面目下拉框录入（未完成0分，完成0.5分）

⑤服务类别多选框录入功能（未完成0分，完成0.5分）

⑥服务类别限制最多四项选项功能；（未完成0分，完成0.5分）

⑦提交后页面跳转功能；（未完成0分，完成1分）

（5）修改志愿者个人信息页面：

输入志愿者姓名，显示其余信息，可对性别、政治面目、服务类别进行修改。（性别、政治面目、服务类别必须符合录入要求）；如果该名志愿者信息数据库不存在，则提示“该志愿者信息不存在”。（3分）

评分标准：

①完成修改志愿者个人信息页面（未完成0分，完成0.5分）

② 实现数据库中信息更新（未完成0分，完成1分）

③修改信息判断是否符合要求。（未完成0分，完成0.5分）

④输入姓名，显示其余信息，若该信息不存在，提示错误信息；（未完成0分，完成1分）

（6）删除志愿者信息页面：录入志愿者姓名，显示详细信息后，点击“删除”按钮，弹出提示框，提示“是否确认删除该志愿者信息”，确认后删除该信息。（2分）

评分标准：

①输入志愿者姓名可显示其余信息。（未完成0分，完成0.5分）

②提示确认信息。（未完成0分，完成0.5分）

③对应删除数据库中信息（未完成0分，完成1分）

（7）浏览志愿者信息页面：（2分）

以列表形式显示志愿者基本信息，结果列表中显示姓名、性别，民族、政治面目基本信息，点击姓名，可以跳转到个人详细信息。

①实现以列表形式显示志愿者基本信息，结果列表中显示姓名、性别，民族、政治面目基本信息（未完成0分，完成1分）

②实现跳转个人详细信息页面。（未完成0分，完成1分）

（8）查询志愿者信息页面：（3分）

要求可以根据志愿者姓名、性别、民族、政治面目、服务类别、注册时间六种条件实现模糊查询，输出结果以列表形式显示，显示姓名、性别，民族、政治面目基本信息，点击列表中的姓名，跳转到志愿者个人详细信息页面。

评分标准：

①缺少一种查询条件扣除0.5分。（未完成0分，完成3分）

2.2 功能要求

（1）设计出合理的数据库和数据表，要求使用mysql、sqlserver、oracle三种数据库中一种（1分）

（2）使用Serverlet实现页面交互（1分）。

（3）使用Java Bean封装数据库连接操作（1分。）

 

 

下面是我的代码

package com.bean;

public class Bean {
    
    private String name;
    private String sex;
    private String mianmu;
    private String minzu;
    private String time;
    private String age;
    private String fuwu;
    


    public Bean() {
        super();
    }

    public Bean(String name, String sex, String mianmu, String minzu, String time, String age, String fuwu) {
        super();
        this.name = name;
        this.sex = sex;
        this.mianmu = mianmu;
        this.minzu = minzu;
        this.time = time;
        this.age = age;
        this.fuwu = fuwu;
    }


    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getMianmu() {
        return mianmu;
    }

    public void setMianmu(String mianmu) {
        this.mianmu = mianmu;
    }

    public String getMinzu() {
        return minzu;
    }

    public void setMinzu(String minzu) {
        this.minzu = minzu;
    }

    public String getTime() {
        return time;
    }

    public void setTime(String time) {
        this.time = time;
    }

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    public String getFuwu() {
        return fuwu;
    }

    public void setFuwu(String fuwu) {
         this.fuwu = fuwu;
    }
    
    @Override
    public String toString() {
        return "Bean [name=" + name + ", sex=" + sex + ", mianmu=" + mianmu + ", minzu=" + minzu + ", time=" + time
                + ", age=" + age + ", fuwu=" + fuwu + "]";
    }
    
    
}

 

package com.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.db.DB;
import com.servlet.selectNameServlet;
import com.servlet.updateServlet;
import com.db.DB;
import com.bean.Bean;

public class Dao {
    
    //增加
    @SuppressWarnings("static-access")
    
    public boolean add(Bean bean) {
        String tablename = "test";
        DB db=new DB();
        Connection con = db.getCon();
        
        try {
            String sql="insert into "+tablename+"(name,sex,mianmu,minzu,time,age,fuwu) values ('"+bean.getName()+"','"+bean.getSex()+"','"+bean.getMianmu()+"','"+bean.getMinzu()+"','"+bean.getTime()+"','"+bean.getAge()+"','"+bean.getFuwu()+"')";
            Statement stm = con.createStatement();
            System.out.println(sql);
            stm.execute(sql);
            db.close(stm, con);
        }catch(Exception e) {
            e.printStackTrace();
            System.out.println("add false");
            return false;
        }
        System.out.println("add true");
        return true;
    }

    
    //根据名称进行查询
    @SuppressWarnings("static-access")
    public static Bean selectName(String name) {
        String tablename = "test";
        System.out.println("select bean where name = "+name);
        Bean bean=null;
        DB db=new DB();
        Connection con = db.getCon();
        try {
            Statement stm = con.createStatement();
            //閿熸枻鎷烽敓鏂ゆ嫹value1=name閿熸枻鎷烽敓鏂ゆ嫹閿熸嵎锝忔嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓琛楄鎷烽敓鏂ゆ嫹閿熸枻鎷�
            ResultSet rs = stm.executeQuery("select * from "+tablename+" where name='" + name + "'");
            /*
             * 閿熸枻鎷烽敓鏂ゆ嫹value1=name閿熸枻鎷烽敓鏂ゆ嫹閿熸嵎锝忔嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓鏂ゆ嫹value3閿熸枻鎷烽敓琛楄鎷烽敓鏂ゆ嫹閿熸枻鎷�
             * ResultSet rs =stm.executeQuery("select value3 from "+tablename+" where value2="+i);
             */
            if(rs.next())
            {
                bean = new Bean();
                System.out.println("select the bean from mysql");
                bean.setName(rs.getString("name"));
                bean.setSex(rs.getString("sex"));
                bean.setMianmu(rs.getString("mianmu"));
                bean.setMinzu(rs.getString("minzu"));
                bean.setTime(rs.getString("time"));
                bean.setAge(rs.getString("age"));
                bean.setFuwu(rs.getString("fuwu"));
                //bean.setValue2(Integer.parseInt(rs.getString("teacher")));
                //bean.setValue3(Boolean.parseBoolean(rs.getString("address")));
                System.out.println("name of the bean is "+rs.getString("name"));
            }
            db.close(rs,stm, con);
        }catch(Exception e) {
            e.printStackTrace();
        }
        return bean;
    }
    
    //根据性别进行查询
        @SuppressWarnings("static-access")
        public static Bean selectSex(String sex) {
            String tablename = "test";
            System.out.println("select bean where sex = "+sex);
            Bean bean=null;
            DB db=new DB();
            Connection con = db.getCon();
            try {
                Statement stm = con.createStatement();
                //閿熸枻鎷烽敓鏂ゆ嫹value1=name閿熸枻鎷烽敓鏂ゆ嫹閿熸嵎锝忔嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓琛楄鎷烽敓鏂ゆ嫹閿熸枻鎷�
                ResultSet rs = stm.executeQuery("select * from "+tablename+" where sex='" + sex + "'");
                /*
                 * 閿熸枻鎷烽敓鏂ゆ嫹value1=name閿熸枻鎷烽敓鏂ゆ嫹閿熸嵎锝忔嫹閿熸枻鎷烽敓鏂ゆ嫹閿熸枻鎷烽敓鏂ゆ嫹value3閿熸枻鎷烽敓琛楄鎷烽敓鏂ゆ嫹閿熸枻鎷�
                 * ResultSet rs =stm.executeQuery("select value3 from "+tablename+" where value2="+i);
                 */
                if(rs.next())
                {
                    bean = new Bean();
                    System.out.println("select the bean from mysql");
                    bean.setName(rs.getString("name"));
                    bean.setSex(rs.getString("sex"));
                    bean.setMianmu(rs.getString("mianmu"));
                    bean.setMinzu(rs.getString("minzu"));
                    bean.setTime(rs.getString("time"));
                    bean.setAge(rs.getString("age"));
                    bean.setFuwu(rs.getString("fuwu"));
                    //bean.setValue2(Integer.parseInt(rs.getString("teacher")));
                    //bean.setValue3(Boolean.parseBoolean(rs.getString("address")));
                    System.out.println("sex of the bean is "+rs.getString("sex"));
                }
                db.close(rs,stm, con);
            }catch(Exception e) {
                e.printStackTrace();
            }
            return bean;
        }
        
    
    
    
    //删除
    @SuppressWarnings("static-access")
    public static boolean delete(String name)
    {
        //String tablename ="test";
        DB db=new DB();
        Connection con = db.getCon();
        //Connection con=null;
        PreparedStatement stm=null;
        try {
            con=DB.getCon();
            String sql="delete from test where name='"+name+"'";
            //String sql="delete from test where name='"+bean.getName()+"'";
            System.out.println(sql);
            stm=con.prepareStatement(sql);
            stm.executeUpdate();
            return true;
        }
        catch(SQLException e)
        {
            e.printStackTrace();
        }
        finally {
            db.close(stm, con);
        }
        return false;
        
    }
   //修改
    @SuppressWarnings("static-access")
    public boolean update(Bean bean) {
        Connection con=null;
        PreparedStatement stm=null;
        String tablename="test";
        DB db=new DB();
        try {
            con=DB.getCon();
            String sql="update "+tablename+" set mianmu=?,sex=? ,minzu=?,time=?,age=?,fuwu=? where name=?";
            //String sql="update "+tablename+"set teacher=?,classroom=? where name=?";
            stm=con.prepareStatement(sql);
            stm.setString(7,bean.getName());
            stm.setString(2,bean.getSex());
            stm.setString(1,bean.getMianmu());
            stm.setString(3,bean.getMinzu());
            stm.setString(4,bean.getTime());
            stm.setString(5,bean.getAge());
            stm.setString(6,bean.getFuwu());
            stm.executeUpdate();
        }
        catch(SQLException e)
        {
            e.printStackTrace();
            return false;
        }
        finally {
            db.close(stm, con);
            return true;
        }
    }
  //根据名字进行查找
     public  boolean findName(String name){
            boolean flag=false;//鎵句笉鍒�
            Connection con=null;
            PreparedStatement psts=null;
            ResultSet rs=null;
            String tablename="test";
            DB db=new DB();
            try {
                con=db.getCon();
                String sql="select * from"+tablename+" where name=?";
                psts=con.prepareStatement(sql);
                psts.setString(1, name);
                rs=psts.executeQuery();
                while(rs.next()){
                    flag=true;
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
            
            return flag;
     }
    
    //
    @SuppressWarnings("static-access")
     public ArrayList<Bean> selectList(){
        Connection con=null;
        PreparedStatement stm=null;
        ResultSet rs=null;
        ArrayList<Bean> listbean=new ArrayList<Bean>();
        String tablename="test";
        DB db=new DB();
        try {
            con=db.getCon();
            String sql="select * from "+tablename;
            stm=con.prepareStatement(sql);
            rs=stm.executeQuery();
            while(rs.next()){
            
                String name=rs.getString("name");
                String sex=rs.getString("sex");
                String mianmu=rs.getString("mianmu");
                String minzu=rs.getString("minzu");
                String time=rs.getString("time");
                String age=rs.getString("age");
                String fuwu=rs.getString("fuwu");
                Bean bean=new Bean(name,sex,mianmu,minzu,time,age,fuwu);
                listbean.add(bean);
                
            }
        } 
        catch(SQLException e)
        {
            e.printStackTrace();
        }
        finally
        {
            db.close(stm, con);
        }
        return listbean;
    }


    public static List<Bean> loadview(String sql) {
        System.out.println("loadview??sql:"+sql);
        String sql1="select * from test "+ sql;
        System.out.println("loadview??sql1:"+sql1);
        List<Bean> list =new ArrayList<Bean>();
        Connection conn = DB.getCon();
        Statement state = null;
        ResultSet rs = null;
        Bean yi=null;
            try 
            {
                state = conn.createStatement();
                rs = state.executeQuery(sql1);
                while(rs.next()) 
                {
                    
                    String name=rs.getString("name");
                    String sex=rs.getString("sex");
                    String mianmu=rs.getString("mianmu");
                    String minzu=rs.getString("minzu");
                    String time=rs.getString("time");
                    String age=rs.getString("age");
                    String fuwu=rs.getString("fuwu");
                    
                    System.out.println("name"+name);
                 
                    yi=new Bean(name,sex,mianmu,minzu,time,age,fuwu);
                    list.add(yi);
                    System.out.println("name1"+yi.getName());
                }
            
                DB.close(rs, state, conn);
            } catch (SQLException e) {
                // TODO �Զ����ɵ� catch ��
                e.printStackTrace();
            } 

        return list;
    }
    }



    
    //
//    public Bean login(String name,String password) {
//        String tablename = null;
//        DB db=new DB();
//        Connection con = db.getCon();
//        Bean bean = null;
//        try {
//            Statement stm = con.createStatement();
//            ResultSet rs = stm.executeQuery("select * from "+tablename+" where value1='" + name + "'");
//            if(rs.next()) {
//                if (rs.getString("password").equals(password)) {
//                    
//                }
//            }
//        }catch(Exception e) {
//            
//        }
//    }
    

package com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class addServlet
 */
@WebServlet("/addServlet")
public class addServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    private static final String String = null;

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("UTF-8");
        
        Bean bean = new Bean();
        bean.setName(request.getParameter("name"));
        bean.setSex(request.getParameter("sex"));
        bean.setMianmu(request.getParameter("mianmu"));
        bean.setMinzu(request.getParameter("minzu"));
        bean.setTime(request.getParameter("time"));
        bean.setAge(request.getParameter("age"));
        

        String []comments=request.getParameterValues("fuwu");
        String coment = String.join(",",comments);
        bean.setFuwu(coment);
        System.out.println(coment);
        
        Dao dao = new Dao();
        if(dao.add(bean)) {
            request.setAttribute("message", "添加成功");
            request.getRequestDispatcher("add.jsp").forward(request,response);
            //response.sendRedirect("index.jsp");
        }
        else {
            request.setAttribute("message","添加失败");
            request.getRequestDispatcher("add.jsp").forward(request,response);
            //response.sendRedirect("add.jsp");
        }
    }

    
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        doGet(request, response);
    }

}



package com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class delete1servlet
 */
@WebServlet("/delete1servlet")
public class delete1servlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    
        request.setCharacterEncoding("UTF-8");
        Bean bean=new Bean();
        Bean beanform=new Bean();
        Dao dao=new Dao();
        bean = dao.selectName(request.getParameter("delete"));
         System.out.println(request.getParameter("delete"));
        if(bean!=null)
        {
            request.setAttribute("Bean",bean);
            request.getRequestDispatcher("delete_show.jsp").forward(request,response);
        }
        else {
            
            request.setAttribute("message", "该志愿者信息不存在");
            request.getRequestDispatcher("delete.jsp").forward(request,response);
            //response.sendRedirect("index.jsp");
        }
    }


    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        doGet(request, response);
    }

}


package com.servlet;

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

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class deleteServlet
 */
@WebServlet("/deleteServlet")
public class deleteServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        Dao dao=new Dao();
        if(dao.delete(request.getParameter("deletename")) ) {
           request.setAttribute("message","删除成功");
            request.getRequestDispatcher("delete.jsp").forward(request,response);//转发到jsp里面
        }
        else {
            
            request.setAttribute("message", "删除失败,请重新进行删除");
            request.getRequestDispatcher("delete.jsp").forward(request,response);
        }
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}


package com.servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class MoHuServlet
 */
@WebServlet("/MoHuServlet")
public class MoHuServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public MoHuServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8"); 
        Dao yidao=new Dao();
        List<Bean>list = new ArrayList<Bean>();
        String p[] = new String[10];//获得条件
        String s[] = new String[10];//获得内容
        String g[] = new String[10];//获得关系
        String f[] = new String[10];//获得精确或者模糊
        String number = null;

        //String number1 = null;
        number=request.getParameter("number1");
        //number1=request.getParameter("number2");
        int n = Integer.parseInt(number);//接收条件的个数
        System.out.println("条件数"+n);
        //int n1 = Integer.parseInt(number1);//���յĹ�ϵ�ĸ���
        for(int i=1;i<=n;i++)
        {
            p[i]= (String) request.getParameter("s"+i);
            s[i]=(String)request.getParameter("shuru"+i);
            f[i]=(String)request.getParameter("c"+i);
            System.out.println("精确还是模糊"+f[i]);
            System.out.println("条件"+p[i]);
            System.out.println("输入"+s[i]);
            if(p[i].equals("名字")){
                p[i] = "name";
            }else if(p[i].equals("性别")){
                p[i] = "sex";
            }else if(p[i].equals("民族")){
                p[i] = "minzu";
            }else if(p[i].equals("注册日期")){
                p[i] = "time";
            }else if(p[i].equals("年龄")){
                p[i] = "age";
            }
            else if(p[i].equals("面目"))
            {
                p[i]="mianmu";
            }
            else if(p[i].equals("服务"))
            {
                p[i]="fuwu";
            }
        }
        
        for(int i=1;i<n;i++)
        {
            g[i]=(String) request.getParameter("g"+i);
            if(g[i].equals("且")) {
                g[i]="and";
            }else if(g[i].equals("或")) {
                g[i]="or";
            }
            System.out.println("且或"+g[i]);
        }
        
        String sql="where ";
        for(int i=1;i<n;i++)
        {
            if(s[i].equals(""))
            {
                continue;
            }
            if(f[i].equals("精确"))
            {
                sql=sql+p[i]+"='"+s[i]+"'"+" "+g[i]+" ";
            }else if(f[i].equals("模糊"))
            {
                sql=sql+p[i]+" "+"LIKE"+" "+"'%"+s[i]+"%'"+" "+g[i]+" ";
            }
            
        }
        if(f[n].equals("精确")) {
            sql = sql + p[n]+"="+"'"+s[n]+"'";    
        }else {
            sql = sql + p[n]+" "+"LIKE"+" "+"'%"+s[n]+"%'";    
        }
//    }
        if(n==1&&s[1].equals(""))
        {
            System.out.println("什么也没传！");
            sql="";
        }
        list = yidao.loadview(sql);
            
            if(list.size()!=0) {
            request.setAttribute("course11",list); 
            request.setAttribute("message", "查询成功");
            System.out.print("查询 成功");
            request.getRequestDispatcher("show.jsp").forward(request,response);
            }
            else {
                request.setAttribute("message", "查询失败");
                request.getRequestDispatcher("jingquemohuchaxun.jsp").forward(request,response);
            }
//        HttpSession session = request.getSession();
//        session.setAttribute("tiaojian", list);
////            int servletid=1;
////            request.setAttribute("list", list);
////            request.setAttribute("servletid", servletid);
//        try {
////            request.getRequestDispatcher("/admin/123.jsp").forward(request, response);
//            response.sendRedirect(request.getContextPath()+"/show.jsp");
//        } catch (IOException e) {
//            // TODO �Զ����ɵ� catch ��
//            e.printStackTrace();
//        } 
        
        
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}


package com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class selectNameServlet
 */
@WebServlet("/selectNameServlet")
public class selectNameServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
  
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        Bean bean=new Bean();
        bean.setName(request.getParameter("selectname"));
        Dao dao=new Dao();
        bean = dao.selectName(bean.getName());
        if(bean!=null)
        {
            request.setAttribute("Bean",bean);
            request.getRequestDispatcher("select_show.jsp").forward(request,response);
        }
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}


package com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

@WebServlet("/selectsexServlet")
public class selectsexServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        request.setCharacterEncoding("UTF-8");
        Bean bean=new Bean();
        bean.setSex(request.getParameter("selectsex"));
        Dao dao=new Dao();
        bean = dao.selectSex(bean.getSex());
        if(bean!=null)
        {
            request.setAttribute("Bean",bean);
            request.getRequestDispatcher("select_show.jsp").forward(request,response);
        }
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

}




package com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class selectNameServlet
 */
@WebServlet("/Servlet")
public class Servlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    Dao dao=new Dao();
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        Bean bean=new Bean();
        String name = request.getParameter("name");
        System.out.println(name+"哈哈哈哈哈哈哈哈哈哈哈哈dgywegdyuwedyugwedye");
        bean = dao.selectName(name); 
//          System.out.println(bean.getMinzu());
          if(bean!=null) { request.setAttribute("Bean",bean);
          request.getRequestDispatcher("select_show.jsp").forward(request,response); }
         
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

}


package com.servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class showAll
 */
@WebServlet("/showAllServlet")
public class showAllServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    
  
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        request.setCharacterEncoding("UTF-8");
        Dao dao=new Dao();
        ArrayList<Bean> listbean=dao.selectList();
        
        //request.getRequestDispatcher();
        request.setAttribute("listbean", listbean);
        request.getRequestDispatcher("showall.jsp").forward(request,response);
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}


package com.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class updatenewServlet
 */
@WebServlet("/updatenewServlet")
public class updatenewServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        //response.getWriter().append("Served at: ").append(request.getContextPath());
        request.setCharacterEncoding("UTF-8");
        Bean beannew=new Bean();
        Dao dao=new Dao();
        beannew.setName(request.getParameter("updatename"));
        beannew.setSex(request.getParameter("updatesex"));
        beannew.setMianmu(request.getParameter("updatemianmu"));
        beannew.setMinzu(request.getParameter("updateminzu"));
        beannew.setTime(request.getParameter("updatetime"));
        beannew.setAge(request.getParameter("updateage"));
        beannew.setFuwu(request.getParameter("updatefuwu"));
        //System.out.println("���ܳɹ�");
        //System.out.println(request.getParameter("updatename"));
        //bean.setValue2(Integer.parseInt(request.getParameter("value2")));
        //bean.setValue3(Boolean.parseBoolean(request.getParameter("value3")));
          if(dao.update(beannew)) {
            //request.setAttribute("message", "添加成功");
             response.sendRedirect("index.jsp");
        }
        else {
            //request.setAttribute("message","添加失败");
            response.sendRedirect("update_show.jsp");
        }
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}


package com.servlet;

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

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.Bean;
import com.dao.Dao;

/**
 * Servlet implementation class updateServlet
 */
@WebServlet("/updateServlet")
public class updateServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    
        request.setCharacterEncoding("UTF-8");
        Bean bean=new Bean();
        Bean beanform=new Bean();
        Dao dao=new Dao();
        bean = dao.selectName(request.getParameter("selectname"));
         System.out.println(request.getParameter("selectname"));
        if(bean!=null)
        {
            request.setAttribute("Bean",bean);
            request.getRequestDispatcher("update_show.jsp").forward(request,response);
        }
        else {
            
            request.setAttribute("message", "该志愿者信息不存在");
            request.getRequestDispatcher("update.jsp").forward(request,response);
            //response.sendRedirect("index.jsp");
        }
        
//        else if(bean==null) {
//            request.setAttribute("Bean",bean);
//            request.getRequestDispatcher("delete.jsp").forward(request,response);
//            return ;
//        }
            
        
    
//        beanform.setName(request.getParameter("updatename"));
//        beanform.setTeacher(request.getParameter("updateteacher"));
//        beanform.setClassroom(request.getParameter("updateclassroom"));
//         //bean.setValue2(Integer.parseInt(request.getParameter("value2")));
//         //bean.setValue3(Boolean.parseBoolean(request.getParameter("value3")));
//          if(dao.update(beanform)) {
//            //request.setAttribute("message", "添加成功");
//             response.sendRedirect("index.jsp");
//        }
//        else {
//            //request.setAttribute("message","添加失败");
//            response.sendRedirect("update.jsp");
//        }
    }

}

package com.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;



public class DB {
    private static String mysqlname = "test";//����
    private static Connection con;
    private static Statement stm;
    private static ResultSet rs;
    private static String coursename = "com.mysql.jdbc.Driver";
    private static String url = "jdbc:mysql://127.0.0.1:3306/"+mysqlname+"?useUnicode=true&characterEncoding=GB18030&useSSL=false&serverTimezone=GMT&allowPublicKeyRetrieval=true";
    
    public static Connection getCon() {
        try {
            Class.forName(coursename);
            System.out.println("ע�������ɹ�");
        }catch(ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            con = DriverManager.getConnection(url,"root","123456");
            System.out.println("�������ӳɹ�");
        }catch(Exception e){
            e.printStackTrace();
            con = null;
        }
        return con;
    }
    
    public static void close(Statement stm,Connection connection) {
        if(stm!=null) {
            try {
                stm.close();
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }
        if(connection!=null) {
            try {
                connection.close();
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }
    }
        
    //关闭
    public static void close(ResultSet rs,Statement stm,Connection connection) {
        if(rs!=null) {
            try {
                rs.close();
            }catch(SQLException e) {
            e.printStackTrace();
            }
        }
        if(stm!=null) {
            try {
                stm.close();
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }
        if(connection!=null) {
            try {
                connection.close();
            }catch(SQLException e) {
                e.printStackTrace();
            }
        }
    }
    public static void main(String[] args)
    {
        getCon();
    }
}

 

 还有web的代码主要是界面这次的考试让我学会了很多考试的时候没有把全部的都实现但是，课下的时候吧所有的功能自己补全实现