增删改查。

项目要求:

 项目的所有类:

 所有方法:

package com.dao;

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

import com.entity.Clazz;
import com.entity.Student;
import com.entity.Teacher;
import com.util.DBhelper;


public class StudentDao {
    Connection con=null;
    PreparedStatement ps=null;
    ResultSet rs=null;
    /**
     * 查看所有学生
     * @return
     */
    public List<Student> getAll(){
        List<Student> list=new ArrayList<Student>();
        try {
            con=DBhelper.getCon();
            String sql="select * from tb_student";
            ps=con.prepareStatement(sql);
            rs=ps.executeQuery();
            while(rs.next()) {
                int sid=rs.getInt(1);
                String sname=rs.getString(2);
                String tname=rs.getString(3);
                String sclass=rs.getString(4);
                String shobby=rs.getString(5);
                Student s=new Student(sid, sname, tname, sclass, shobby);
                list.add(s);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBhelper.myClose(con, ps, rs);
        }
        return list;
    }
    /**
     * 得到所有老师
     * @return
     */
    public List<Teacher> getTeacher(){
        List<Teacher> list=new ArrayList<Teacher>();
        try {
            con=DBhelper.getCon();
            String sql="select * from tb_teacher";
            ps=con.prepareStatement(sql);
            rs=ps.executeQuery();
            while(rs.next()) {
            	int tid=rs.getInt(1);
                String tname=rs.getString(2);
                Teacher s=new Teacher(tid, tname);
                list.add(s);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBhelper.myClose(con, ps, rs);
        }
        return list;
    }
    
    /**
     * 得到所有班级
     * @return
     */
    public List<Clazz> getclass(){
        List<Clazz> list=new ArrayList<Clazz>();
        try {
            con=DBhelper.getCon();
            String sql="select * from tb_clazz";
            ps=con.prepareStatement(sql);
            rs=ps.executeQuery();
            while(rs.next()) {
            	int cid=rs.getInt(1);
                String sclass=rs.getString(2);
                Clazz s=new Clazz(cid, sclass);
                list.add(s);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBhelper.myClose(con, ps, rs);
        }
        return list;
    }
    
    /**
     * 增加
     * @param s
     * @return
     */
    public int add(Student s) {
        try {
            con=DBhelper.getCon();
            String sql="insert into tb_student values(?,?,?,?)";
            ps=con.prepareStatement(sql);
            ps.setString(1, s.getSname());
            ps.setString(2, s.getTname());
            ps.setString(3, s.getSclass());
            ps.setString(4, s.getShobby());
            return ps.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBhelper.myClose(con, ps, rs);
        }
        return 0;
    }
    /**
     * 删除
     * @param sid
     * @return
     */
    public int delStu(int sid) {
        try {
            con=DBhelper.getCon();
            String sql="delete tb_student where sid=?";
                    ps=con.prepareStatement(sql);
                    ps.setInt(1, sid);
                    return ps.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBhelper.myClose(con, ps, rs);
        }
        return 0;
    }
    
    /**
     * 查看单个学生
     * @param sid
     * @return
     */
    public Student see(int sid) {
        try {
            con=DBhelper.getCon();
            String sql="select * from tb_student where sid=?";
            ps=con.prepareStatement(sql);
            ps.setInt(1, sid);
            rs=ps.executeQuery();
            while(rs.next()) {
                int id=rs.getInt(1);
                String sname=rs.getString(2);
                String tname=rs.getString(3);
                String sclass=rs.getString(4);
                String shobby=rs.getString(5);
                Student s=new Student(id, sname,tname, sclass,shobby);
                return s;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBhelper.myClose(con, ps, rs);
        }
        return null;
    }
    
    /**
     * 修改
     * @param s
     * @return
     */
    public int upd(Student s) {
        try {
            con=DBhelper.getCon();
            String sql="update tb_student set sname=?,tname=?,sclass=?,shobby=? where sid=?";
            ps=con.prepareStatement(sql);
            ps.setString(1, s.getSname());
            ps.setString(2, s.getTname());
            ps.setString(3, s.getSclass());
            ps.setString(4, s.getShobby());
            ps.setInt(5, s.getSid());
            return ps.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBhelper.myClose(con, ps, rs);
        }
        return 0;
    }
    
    /**
     * 模糊查询
     * @param key1教员名字关键字
     * @param key2班级关键字
     * @param key3爱好关键字
     * @return
     */
    public List<Student> getkey(String teacher,String sclass,String shobby){
        List<Student> list = new ArrayList<Student>();        
        try {
            con=DBhelper.getCon();
            ps = con.prepareStatement("select * from tb_student where tname like ? and sclass like ? and shobby like ?");            
            ps.setString(1, "%"+teacher+"%");            
            ps.setString(2, "%"+sclass+"%");            
            ps.setString(3, "%"+shobby+"%");            
            rs = ps.executeQuery();            
            while (rs.next()) {                
                Student s=new Student();                
                s.setSid(rs.getInt(1));                
                s.setSname(rs.getString(2));    
                s.setTname(rs.getString(3));            
                s.setSclass(rs.getString(4));                
                s.setShobby(rs.getString(5));                
                list.add(s);            
                }        
            } catch (Exception e) {            
                e.printStackTrace();        
                } finally {            
                    DBhelper.myClose(con, ps, rs);        
                    }        
        return list;    
        }            
    
    
    

}

 index.jsp代码:

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
    <table border="1">
    <tr >
    <td colspan="6">
    <form action="Key.do">
    教员:<select class="select" name="teacher">
                    <option value="null">--选择教员--</option>
                    
                    <c:forEach  var="y" items="${ teacher }">

    <option value="${ y.teacher }" ${ y.teacher==teacher?"selected":"" }>${y.teacher }</option>

        </c:forEach>
        </select>
    班级:<select class="select" name="sclass">
                    <option value="null">--选择班级--</option>
                    <c:forEach  var="b" items="${ sclass }">

<option value="${ b.sclass }" ${ b.sclass==sclass?"selected":"" }>${b.sclass }</option>

                </c:forEach>
                </select>
    学生爱好:<input type="checkbox" value="篮球" name="shobby" <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='篮球' }">checked</c:if>
    </c:forEach>
    >篮球
        <input type="checkbox" value="足球" name="shobby"  <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='足球' }">checked</c:if>
    </c:forEach>
        >足球
        <input type="checkbox" value="唱歌" name="shobby"  <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='唱歌' }">checked</c:if>
    </c:forEach>
        >唱歌
        <input type="checkbox" value="跳舞" name="shobby"  <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='跳舞' }">checked</c:if>
    </c:forEach>
        >跳舞
    <button>查询</button>
    </form>
    <button οnclick="location.href='Add.jsp'">增加学生</button>
    </td>
    </tr>
    
    <tr>
    <td>学生id</td>
    <td>学生姓名</td>
    <td>学生教员</td>
    <td>所在班级</td>
    <td>学生爱好</td>
    <td>操作</td>
    </tr>
    <c:forEach var="i" items="${list }">
    <tr>
    <td>${i.sid }</td>
    <td>${i.sname }</td>
    <td>${i.tname }</td>
    <td>${i.sclass }</td>
    <td>${i.shobby }</td>
    <td>
    <a href="see.do?sid=${i.sid }">修改</a>
    <a οnclick="return confirm('确定要删除吗?')" href="del.do?sid=${i.sid }">删除</a>
    </td>
    </tr>
    </c:forEach>
    </table>
    
</body>
</html>

 Indexservelet代码

package com.servelet;

import java.io.IOException;
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.dao.StudentDao;
import com.entity.Clazz;
import com.entity.Student;
import com.entity.Teacher;

/**
 * Servlet implementation class IndexServlet
 */
@WebServlet("/index.do")
public class IndexServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        StudentDao sd=new StudentDao();
        List<Student> list=sd.getAll();
        request.setAttribute("list", list);
        List<Teacher> teacher=sd.getTeacher();
        request.setAttribute("teacher", teacher);
        List<Clazz> sclass=sd.getclass();
        request.setAttribute("sclass", sclass);
        request.getRequestDispatcher("Index.jsp").forward(request, response);
              }
}

效果: 

 

 KeyServlet的代码:

package com.servelet;

import java.io.IOException;
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.dao.StudentDao;
import com.entity.Clazz;
import com.entity.Student;
import com.entity.Teacher;

@WebServlet("/Key.do")
public class KeyServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");    
        response.setContentType("text/html;charset=utf-8");    
        StudentDao sd=new StudentDao();
        String steacher= request.getParameter("teacher");    
        String ah = request.getParameter("shobby");    
        String ssclass = request.getParameter("sclass");        
        if(steacher==null&&ssclass==null) {
            List<Student> list=sd.getAll();
            request.setAttribute("list", list);
            List<Teacher> teacher=sd.getTeacher();
            request.setAttribute("teacher", teacher);
            List<Clazz> sclass=sd.getclass();
            request.setAttribute("sclass", sclass);
            request.getRequestDispatcher("Index.jsp").forward(request, response);
         }else {
             List<Student> list=sd.getkey(steacher,ssclass,ah);
             request.setAttribute("list", list);
             List<Clazz> sclass=sd.getclass();
                List<Teacher> teacher=sd.getTeacher();
                request.setAttribute("teacher", teacher);
                request.setAttribute("sclass", sclass);
                request.getRequestDispatcher("Index.jsp").forward(request, response);
         }
                            }

}

 效果:

 Add.jsp的代码

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
    <form action="add.do" method="post">
    姓名:<input name="sname"><br>
    教员:<select class="select" name="steacher">
                    <option value="小哥">小哥</option>
                    <option value="晓哥">晓哥</option>
                    <option value="小葛">小葛</option>
                    <option value="胡哥">胡哥</option>
                </select>
                <br>
    班级:<select class="select" name="sclass">
                    <option value="一班">一班</option>
                    <option value="二班">二班</option>
                    <option value="三班">三班</option>
                    <option value="四班">四班</option>
                </select>
                <br>
    爱好:<input type="checkbox" value="篮球" name="shobby">篮球
        <input type="checkbox" value="足球" name="shobby">足球
        <input type="checkbox" value="唱歌" name="shobby">唱歌
        <input type="checkbox" value="跳舞" name="shobby">跳舞
        <br>
    <button>增加</button>
    <button type="reset">重置</button>
    </form>
</body>
</html>

 AddServlet的代码:

package com.servelet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Arrays;

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.dao.StudentDao;
import com.entity.Student;

/**
 * Servlet implementation class AddServlet
 */
@WebServlet("/add.do")
public class AddServlet extends HttpServlet {
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        
        String sname=request.getParameter("sname");
        String steacher=request.getParameter("steacher");
        String sclass=request.getParameter("sclass");
        String[] shobby=request.getParameterValues("shobby");
        String sh="";
        for (String s : shobby) {
            sh=sh+s+",";
        }
        StudentDao sd=new StudentDao();
        int d=sd.add(new Student(0, sname, steacher, sclass, sh));
        if(d>0) {
            out.print("<script>alert('增加成功');location.href='index.do'</script>");
        }else {
            out.print("<script>alert('增加失败');location.href='index.do'</script>");
        }
    }
}

效果: 

 

 DelServlet的代码:

package com.servelet;

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.dao.StudentDao;

/**
 * Servlet implementation class DelServlet
 */
@WebServlet("/del.do")
public class DelServlet extends HttpServlet {
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        String sid=request.getParameter("sid");
        StudentDao sd=new StudentDao();
        int n=sd.delStu(Integer.parseInt(sid));
        if(n>0) {
            out.print("<script>alert('删除成功');location.href='index.do'</script>");
        }else {
            out.print("<script>alert('删除失败');location.href='index.do'</script>");
        }
    }
}

效果:

 Upd.jsp的代码:

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
    <form action="upd.do" method="post">
    <input name="sid" type="hidden" value="${s.sid}" >
    姓名:<input name="sname" value="${s.sname }"><br>
    教员:<select class="select" name="steacher"">
                    <option value="${s.tname }" ${ s.tname==steacher?"selected":"" }>${ s.tname}</option>
                </select>
                <br>
    班级:<select class="select" name="sclass" >
                    <option value="${s.sclass }" ${ s.sclass==sclass?"selected":"" }>${s.sclass }</option>
                </select>
                <br>
    爱好:<input type="checkbox" value="篮球" name="shobby" <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='篮球' }">checked</c:if>
    </c:forEach>
    >篮球
        <input type="checkbox" value="足球" name="shobby"  <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='足球' }">checked</c:if>
    </c:forEach>
        >足球
        <input type="checkbox" value="唱歌" name="shobby"  <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='唱歌' }">checked</c:if>
    </c:forEach>
        >唱歌
        <input type="checkbox" value="跳舞" name="shobby"  <c:forEach var="i" items="${sah }"> 
    <c:if test="${i=='跳舞' }">checked</c:if>
    </c:forEach>
        >跳舞
        <br>
    <button>修改</button>
    <button type="reset">重置</button>
    </form>
</body>
</html>

Updservelet的代码:

package com.servelet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Arrays;

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.dao.StudentDao;
import com.entity.Student;

/**
 * Servlet implementation class UpdServlet
 */
@WebServlet("/upd.do")
public class UpdServlet extends HttpServlet {
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        
        String sid=request.getParameter("sid");
        String sname=request.getParameter("sname");
        String steacher=request.getParameter("steacher");
        String sclass=request.getParameter("sclass");
        String[] shobby=request.getParameterValues("shobby");
        String sh="";
        for (String s : shobby) {
            sh+=s+",";
        }
        StudentDao sd=new StudentDao();
        int n=sd.upd(new Student(Integer.parseInt(sid), sname, steacher, sclass, sh));
        if(n>0) {
            out.print("<script>alert('修改成功');location.href='index.do'</script>");
        }else {
            out.print("<script>alert('修改成功');location.href='index.do'</script>");
        }
        
    }

}

 Seeservelet的代码:

package com.servelet;

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.dao.StudentDao;
import com.entity.Student;

/**
 * Servlet implementation class SeeServlet
 */
@WebServlet("/see.do")
public class SeeServlet extends HttpServlet {
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id=request.getParameter("sid");
        
        StudentDao sd=new StudentDao();
        Student s=sd.see(Integer.parseInt(id));
        String shobby=s.getShobby();
        String [] sh=shobby.split(",");
        request.setAttribute("s", s);
        request.setAttribute("sah", sh);
        request.getRequestDispatcher("Upd.jsp").forward(request, response);
    }
}

效果: 

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值