增删改查项目

周甘木

于 2022-06-19 22:43:01 发布

阅读量692

点赞数

文章标签： java webview linq

本文链接：https://blog.csdn.net/m0_67864917/article/details/125362430

版权

该博客详细介绍了如何在Java环境下实现一个完整的增删改查项目，包括四张表（学生、教师、爱好、班级）的设计，带条件的查询功能，新增、修改和删除操作，以及分页功能。博客通过代码截图展示了 Dao 层的操作和 Servlet 代码实现。

摘要由CSDN通过智能技术生成

package zhoujuan.entity;

import java.io.Serializable;
import java.util.List;


public class Student implements Serializable{
	
	
	private static final long serialVersionUID = 7154831938131519366L;
	private int sid;
	private String sname;
	private Teacher t;
	private Class c;
	private String ss;//用来增加 修改
	private List<Hobby> ls;//用来绑值
	//定义一个
	public int getSid() {
		return sid;
	}
	public String getSs() {
		return ss;
	}
	public void setSs(String ss) {
		this.ss = ss;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public Teacher getT() {
		return t;
	}
	public void setT(Teacher t) {
		this.t = t;
	}
	public Class getC() {
		return c;
	}
	public void setC(Class c) {
		this.c = c;
	}
	public List<Hobby> getLs() {
		return ls;
	}
	public void setLs(List<Hobby> ls) {
		this.ls = ls;
	}
	public Student() {
		// TODO Auto-generated constructor stub
	}
	public Student(int sid, String sname, Teacher t, Class c, List<Hobby> ls) {
		super();
		this.sid = sid;
		this.sname = sname;
		this.t = t;
		this.c = c;
		this.ls = ls;
	}
	
	public Student(String sname, Teacher t, Class c, String ss) {
		this.sname = sname;
		this.t = t;
		this.c = c;
		this.ss = ss;
	}
	@Override
	public String toString() {
		return "Student [sid=" + sid + ", sname=" + sname + ", t=" + t + ", c=" + c + ", ls=" + ls + "]";
	}
}

教员类：

package zhoujuan.entity;

import java.io.Serializable;

/**
 * 教师类
 * @author Administrator
 *
 */
public class Teacher implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = 4984197172186331612L;
	private int tid;
	private String tname;
	private Class c;
	public int getTid() {
		return tid;
	}
	public void setTid(int tid) {
		this.tid = tid;
	}
	public String getTname() {
		return tname;
	}
	public void setTname(String tname) {
		this.tname = tname;
	}
	public Class getC() {
		return c;
	}
	public void setC(Class c) {
		this.c = c;
	}
	public Teacher() {
		// TODO Auto-generated constructor stub
	}
	public Teacher(int tid, String tname, Class c) {
		this.tid = tid;
		this.tname = tname;
		this.c = c;
	}
	@Override
	public String toString() {
		return "Teacher [tid=" + tid + ", tname=" + tname + ", c=" + c + "]";
	}
}

班级类：

package zhoujuan.entity;

import java.io.Serializable;
/**
 * 班级类
 * @author Administrator
 *
 */
public class Class implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = -5145856861606131091L;
	private int cid;
	private String cname;
	public int getCid() {
		return cid;
	}
	public void setCid(int cid) {
		this.cid = cid;
	}
	public String getCname() {
		return cname;
	}
	public void setCname(String cname) {
		this.cname = cname;
	}
	public Class() {
		// TODO Auto-generated constructor stub
	}
	public Class(int cid, String cname) {
		super();
		this.cid = cid;
		this.cname = cname;
	}
	@Override
	public String toString() {
		return "Class [cid=" + cid + ", cname=" + cname + "]";
	}
}

爱好类：

package zhoujuan.entity;

import java.io.Serializable;
/**
 * 爱好类
 * @author Administrator
 *
 */
public class Hobby implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = -9120395110708701114L;
	private String hid;
	private String hname;
	public String getHid() {
		return hid;
	}

	public void setHid(String hid) {
		this.hid = hid;
	}

	public String getHname() {
		return hname;
	}

	public void setHname(String hname) {
		this.hname = hname;
	}
	public Hobby() {
		// TODO Auto-generated constructor stub
	}
	public Hobby(String hid, String hname) {
		super();
		this.hid = hid;
		this.hname = hname;
	}
	@Override
	public String toString() {
		return "Hobby [hid=" + hid + ", hname=" + hname + "]";
	}
}

一，增加原型的代码（界面图）：

<%@ 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 PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
	function myf(){
		location.href="index.jsp";
	}
</script>
</head>
<body>
	<center>
		<form action="AddServlet" method="post">
			<table border="1px">
				<tr>
					<td>学生姓名</td>
					<td><input type="text" name="sname"/></td>
				</tr>
				<tr>
					<td>教员</td>
					<td>
						<c:if test="${empty la}">
							<jsp:forward page="PreAddServlet"></jsp:forward>
						</c:if>
						<c:if test="${not empty la}">
							<select name="teacher">
								<c:forEach var="t" items="${la}">
									<option value="${t.tid}">${t.tname}</option>
								</c:forEach>
							</select>
						</c:if>
					</td>
				</tr>
				<tr>
					<td>班级</td>
					<td>
						<c:if test="${empty lc}">
							<jsp:forward page="PreAddServlet"></jsp:forward>
						</c:if>
						<c:if test="${not empty lc}">
							<select name="class">
								<c:forEach var="c" items="${lc}">
									<option value="${c.cid}">${c.cname}</option>
								</c:forEach>
							</select>
						</c:if>
					</td>
				</tr>
				<tr>
					<td>爱好</td>
					<td>
						<c:if test="${empty lh}">
							<jsp:forward page="PreAddServlet"></jsp:forward>
						</c:if>
						<c:if test="${not empty lh}">
							<c:forEach items="${lh}" var="h">
								<input type="checkbox" name="aa" value="${h.hid},"/>${h.hname}
							</c:forEach>
						</c:if>
					</td>