暑期作业之增删改查

最新推荐文章于 2024-07-15 22:27:18 发布

酱苓的码农之路

最新推荐文章于 2024-07-15 22:27:18 发布

阅读量86

点赞数 1

分类专栏： java 文章标签： java

本文链接：https://blog.csdn.net/m0_52681702/article/details/119677803

版权

一.本期内容导图：

1.使用sqlservlet数据库建表：我们需要分别建班级表，教员表，学生表

2.导包

3.总共需要建立的类

二.展示代码:

1.建立ServletIndex：数据展现出来

<%@ 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 name="jy">
<option value="null">--请选择教员--</option>
<c:forEach  var="y" items="${ list2 }">
<option value="${ y.yname }" ${ y.yname==jy?"selected":"" }>${y.yname }</option>
</c:forEach>
</select>

 班级:
<select name="bj">
<option value="null">--请选择班级--</option>
<c:forEach  var="b" items="${ list1 }">
<option value="${ b.bname }" ${ b.bname==bj?"selected":"" }>${b.bname }</option>
</c:forEach>
</select>

    学生爱好：<input type="checkbox" value="篮球" name="sah" <c:forEach var="i" items="${ah }"> 
    <c:if test="${i=='篮球' }">checked</c:if>
    </c:forEach>
    >篮球
        <input type="checkbox" value="足球" name="sah"  <c:forEach var="i" items="${ah }"> 
    <c:if test="${i=='足球' }">checked</c:if>
    </c:forEach>
        >足球
        <input type="checkbox" value="唱歌" name="sah"  <c:forEach var="i" items="${ah }"> 
    <c:if test="${i=='唱歌' }">checked</c:if>
    </c:forEach>
        >唱歌
        <input type="checkbox" value="跳舞" name="sah"  <c:forEach var="i" items="${ah }"> 
    <c:if test="${i=='跳舞' }">checked</c:if>
    </c:forEach>
        >跳舞
    <button>查询</button>
    </form>
  
    <a href="Add.jsp">增加学生</a>
    </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.yname }</td>
    <td>${i.bname }</td>
    <td>${i.sah }</td>
    <td>
    <a href="get.do?sid=${i.sid }">修改</a>
    <a οnclick="return confirm('确定要删除吗？')" href="del.do?sid=${i.sid }">删除</a>
    </td>
    </tr>
    </c:forEach>
    </table>
    
</body>
</html>

主界面：Index.jsp

package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
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.biz.IXsBiz;
import com.biz.XsBiz;
import com.entity.Bj;
import com.entity.Jy;
import com.entity.Xs;

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

	
	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();
		
		IXsBiz isb=new XsBiz();
		List<Xs> list=isb.getAll();
		List<Bj> list1=

最低0.47元/天解锁文章

酱苓的码农之路

关注

1
点赞
踩
2

收藏

觉得还不错? 一键收藏
2
评论
暑期作业之增删改查

一.本期内容导图：1.使用sqlservlet数据库建表：我们需要分别建班级表，教员表，学生表2.导包3.总共需要建立的类二.展示代码:1.建立ServletIndex：数据展现出来<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://j...
复制链接

扫一扫