Javaweb

package com.yzr.web.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.yzr.pojo.User;
import com.yzr.service.impl.Userserviceimpl;

/**
 * @author yangzengru
 *
 * 
 */
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");
		
		
//		get请求    调用service业务层 查询所有学生信息
		Userserviceimpl userserviceimpl = new Userserviceimpl();
		List<User> list=userserviceimpl.queryAllUser();
//		将list集合数据显示到页面上
		PrintWriter writer=resp.getWriter();
//		通过表格table选择数据
		String data="<table align='center' border='1px'cellspacing='0px'cellpadding='0px' width='80%'><tr><th>学生编号</th><th>学生姓名</th><th>学生密码</th>";
//		表的内容遍历
		for (int i = 0; i <list.size(); i++) {
//			获取学生信息
		User user=list.get(i);
		data+="<tr><td>"+user.getSid()+"</tr>"+"<td>"+user.getName()+"</td>"+"<td>"+user.getPassword()+"</td>"+"<td><a href='#'>删除</a></td><td><a href='#'>修改</a></td></tr>";
		}
		
		data+="</table>";
		writer.write(data);
	}
	
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		doGet(req, resp);
	}

	
}

 User类

package com.yzr.pojo;

/**
 * @author yangzengru
 *
 * 
 */
public class User {
	private int sid;
	private String name;
	private String password;
	
	public User(int sid, String name, String password) {
		super();
		this.sid = sid;
		this.name = name;
		this.password = password;
	}

	
	public User() {
		super();
	}

	public int getSid() {
		return sid;
	}


	public void setSid(int sid) {
		this.sid = sid;
	}


	public String getName() {
		return name;
	}


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

	public String getPassword() {
		return password;
	}


	public void setPassword(String password) {
		this.password = password;
	}
	

}

package com.yzr.web.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.yzr.dao.UserDao;
import com.yzr.dao.impl.UserDaoimpl;
import com.yzr.service.Userservice;
import com.yzr.service.impl.Userserviceimpl;

/**
 * @author yangzengru
 *
 * 
 */
public class DelServlet extends HttpServlet{
/* (non-Javadoc)
 * @see javax.servlet.http.HttpServlet#doGet(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
 */
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//	获取用户请求的编号
	String sid=req.getParameter("sid");
//	调用ser
	Userservice Userserviceimpl = new Userserviceimpl();
	PrintWriter writer=resp.getWriter();
	boolean del=Userserviceimpl.deleteCustomerBySid(sid);
	if (del) {
		writer.write("删除成功");
	}
  }
/* (non-Javadoc)
	 * @see javax.servlet.http.HttpServlet#doPost(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		doPost(req, resp);
	}
}