javaweb

最新推荐文章于 2024-09-08 12:41:07 发布

cxyylsf

最新推荐文章于 2024-09-08 12:41:07 发布

阅读量105

点赞数

文章标签： Java Servlet CRUD操作 CustomerService HTTP请求数据库交互

本文链接：https://blog.csdn.net/cxyylsf/article/details/126882250

版权

package com.cxy.servlet;

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

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

import com.cxy.bean.Student;
import com.cxy.service.CustomerServiceImpl;

public class QueryServlet extends HttpServlet{
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		req.setCharacterEncoding("UTF-8");
		resp.setCharacterEncoding("UTF-8");
		resp.setContentType("text/html;charset=utf-8");
		
		CustomerServiceImpl impl=new CustomerServiceImpl();
		//获取表格数据
		List<Student> list=impl.querAllCustomer();
		PrintWriter writer=resp.getWriter();
		//将数据放入表
		String data="<table align='center' border='1px' cellspacing='0px' cellpadding='0px' width='80%'><tr><td>学生编号</td><td>学生姓名</td><td>学生性别</td><td>学生年龄</td><td>学生班级</td><td colspan='2'>操作</td></tr>";
		for(int i=0;i<list.size();i++){
			Student student=list.get(i);
			data+="<tr><td>"+student.getId()+"</td><td>"+student.getName()+"</td><td>"+student.getSex()+"</td><td>"+student.getAge()+"</td><td>"+student.getClassname()+"</td><td><a href='del?id="+student.getId()+"'>删除</a></td><td><a href='revise?id="+student.getId()+"'>修改</a></td></tr>";
		}
		data+="</table>";
		writer.write(data);
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

		
		
	}
}

package com.cxy.servlet;

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

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

import com.cxy.service.CustomerServiceImpl;

public class Delservlet extends HttpServlet{
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		resp.setContentType("text/html;charset=UTF-8");
		resp.setCharacterEncoding("UTF-8");
		String id=req.getParameter("id");
		CustomerServiceImpl impl=new CustomerServiceImpl();
		int cid=Integer.parseInt(id);
		boolean a=impl.delstudent(cid);
		if(a){
			PrintWriter writer=resp.getWriter();
			writer.write("删除成功<br><a href='look'>查询信息</a>");
		}
		
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

		
		
	}
}

package com.cxy.servlet;

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

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

import com.cxy.bean.Student;
import com.cxy.service.CustomerServiceImpl;

public class CustomerServlet extends HttpServlet{
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		System.out.println("get");
		resp.setContentType("text/html;charset=UTF-8");
		resp.setCharacterEncoding("UTF-8");
		String username=req.getParameter("username");
		String usersex=req.getParameter("usersex");
		String userage=req.getParameter("userage");
		String userclass=req.getParameter("userclass");
		Student student=new Student(username, usersex, userage, userclass);
		CustomerServiceImpl impl=new CustomerServiceImpl();
		boolean a=impl.addstudent(student);
		if(a){
			PrintWriter writer=resp.getWriter();
			writer.write("录入成功");
		}else{
			PrintWriter writer=resp.getWriter();
			writer.write("录入失败");
		}
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		System.out.println("post");
	}
}