基于servlet&jsp&mysql的表格增删改查操作

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了基于servlet&jsp&mysql的表格增删改查操作，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含21273字，纯文字阅读大概需要31分钟。

内容图文

代码量对于初学者略高，如果看博客不能大致感觉出思路，建议前往下在链接：本项目的源码分享。

https://download.csdn.net/download/qq_41946557/11639971

当然也可以留言。

如果感觉可以接受，建议先思考思考！其中一些小细节，我会在下一篇博客中，一一举出，并指出整个项目的流程问题，以及我对项目的思考。希望多多指正，共同进步。

数据库：

所需jar包：

主页：

添加球员：

条件查询页面：即可根据不同的属性查询。

进行一次添加：

效果图：

条件查询比如查名字里带有乔治且29岁的：

效果演示：

整个代码结构：

大致内容骨架：

主要代码：

PlayDaoImpl：

package com.henu.dao.impl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapHandler;
import org.apache.commons.dbutils.handlers.MapListHandler;

import com.henu.bean.Player;
import com.henu.dao.PlayerDao;
import com.henu.utils.DateUtil;
import com.henu.utils.JdbcUtil;

public class PlayerDaoImpl implements PlayerDao{

	/**
	 * 查询全部
	 */
	public List<Player> findAllPlayer() {
		
		QueryRunner qRunner = new QueryRunner(JdbcUtil.getDataSource());
		String sql = "select * from player order by id desc";
		List<Player> result = new ArrayList<Player>();
		
		try {
			//	MapListHandler获取所有的值以key-value的形式存入Map<String,Object>
			List<Map<String,Object>> list = qRunner.query(sql, new MapListHandler());
			//遍历list取map的值做判断，并赋给player
			for(Map<String,Object> map:list){
				Player player = new Player();
				for(Map.Entry<String,Object> entry:map.entrySet()){
					if("id".equals(entry.getKey())){
						player.setId((Integer)entry.getValue());
					}else if("name".equals(entry.getKey())){
						player.setName((String)entry.getValue());
					}else if("age".equals(entry.getKey())){
						player.setAge((Integer)entry.getValue());
					}else if("birthday".endsWith(entry.getKey())){
						player.setBirthday((Date)entry.getValue());
					}else if("hobby".equals(entry.getKey())){
						String str = (String)entry.getValue();
						if(str!="" && str!=null){
							str = str.substring(0,str.length()-1);
							String[] ss = str.split("#");
							player.setHobby(ss);
						}
					}
				}
				result.add(player);
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return result;
	}
	/**
	 * 添加球员
	 */
	public int insertPlayer(Player player) {
		QueryRunner qRunner = new QueryRunner(JdbcUtil.getDataSource());
		String sql = "insert into player values(null,?,?,?,?)";
		String hobby = "";
		/**
		 * 将得到的player.getHobby()进行组装成字符串 
		 */
		if (player.getHobby()!=null) {
			for (String str : player.getHobby()) {
				hobby = hobby+str+"#";
			}
		}
		int res = 0;
		try {
			res = qRunner.update(sql,new Object[]{player.getName(),player.getAge(),player.getBirthday(),hobby});
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return res;
	}
	/**
	 * 删除球员
	 */
	public int deletePlayer(int id) {
		
		QueryRunner qRunner = new QueryRunner(JdbcUtil.getDataSource());
		
		String sql = "delete from player where id=?";
		int res = 0;
		
		try {
			res = qRunner.update(sql,id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return res;
	}
	/**
	 * 更新球员
	 */
	public int updatePlayer(Player player) {
		int result = 0;
		QueryRunner qr = new QueryRunner(JdbcUtil.getDataSource());
		String sql = "update player set name=?,age=?,birthday=?,hobby=? where id=?";
		String hobby = "";
		if(player.getHobby()!=null){
			for(String str:player.getHobby()){
				hobby=hobby+str+"#";
			}
		}
		try {
			result = qr.update(sql, new Object[]{player.getName(),player.getAge(),player.getBirthday(),hobby,player.getId()});
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
	/**
	 * 根据id查询Player
	 */
	public Player findPlayerById(int id) {
		
		Player player = new Player();
		
		QueryRunner qr = new QueryRunner(JdbcUtil.getDataSource());
		String sql = "select * from player where id=?";
		
	    try {
	    	//因为根据id查询，数据库中id为主键，所以只会有一条数据，因此使用new MapHandler
			Map<String,Object> map = qr.query(sql, new MapHandler(),id);
			
			for(Map.Entry<String,Object> entry:map.entrySet()){
				
				if("id".equals(entry.getKey())){
					player.setId((Integer)entry.getValue());
				}else if("name".equals(entry.getKey())){
					player.setName((String)entry.getValue());
				}else if("age".equals(entry.getKey())){
					player.setAge((Integer)entry.getValue());
				}else if("birthday".endsWith(entry.getKey())){
					player.setBirthday((Date)entry.getValue());
				}else if("hobby".equals(entry.getKey())){
					String str = (String)entry.getValue();
					if(str!="" && str!=null){
						str = str.substring(0,str.length()-1);
						String[] ss = str.split("#");
						player.setHobby(ss);
					}
				}
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return player;
	}
	/**
	 * 根据不同条件进行查询数据中的数据
	 */
	public List<Player> findPlayerByCondition(Player player) {
		//首先定义一个集合进行查询结果的收集
		List<Player> result = new ArrayList<Player>();
        QueryRunner qr = new QueryRunner(JdbcUtil.getDataSource());
		//String sql = "select * from player where name like ? and age = ? and birthday=? and hobby=?";
        //因为我们的需求是ByCondition（）所以进行拼接字符串
		String sql = this.getSQL(player);
		//输出sql语句进行验证，做这一段时建议使用test测试
		System.out.println(sql+"<<<<");
         try {
			List<Map<String,Object>> list = qr.query(sql, new MapListHandler());
			for(Map<String,Object> map:list){
				Player p = new Player();
				for(Map.Entry<String,Object> entry:map.entrySet()){
					if("id".equals(entry.getKey())){
						p.setId((Integer)entry.getValue());
					}else if("name".equals(entry.getKey())){
						p.setName((String)entry.getValue());
					}else if("age".equals(entry.getKey())){
						p.setAge((Integer)entry.getValue());
					}else if("birthday".endsWith(entry.getKey())){
						p.setBirthday((Date)entry.getValue());
					}else if("hobby".equals(entry.getKey())){
						String str = (String)entry.getValue();
						if(str!="" && str!=null){
							str = str.substring(0,str.length()-1);
							String[] ss = str.split("#");
							p.setHobby(ss);
						}
					}
				}
				result.add(p);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
	/**
	 * 
	 * @param player
	 * @return
	 */
	public String getSQL(Player player){
		//where 1=1加上这句话为了下面的拼接
		StringBuilder sb = new StringBuilder("select * from player where 1=1");
		
		if(player.getName()!=null && !"".equals(player.getName())){
			
			sb.append(" and name like '%").append(player.getName()).append("%'");
		}
		
		if(player.getAge()!=0){
			sb.append(" and age=").append(player.getAge());
		}
		/*
		if(player.getBirthday()!=null && !"".equals(player.getBirthday())){
			sb.append(" and birthday='").append(DateUtil.dateToString(player.getBirthday())).append("'");
		}*/
		if(player.getBirthday()!=null && !"".equals(player.getBirthday())){
			sb.append(" and birthday='").append(DateUtil.dateToString(player.getBirthday())).append("'");
		}
		
		if(player.getHobby()!=null && player.getHobby().length>0){
			
			String hobby = "";
			for(String str:player.getHobby()){
				hobby=hobby+str+"#";
			}
			sb.append(" and hobby='").append(hobby).append("'");
		}
		
		return sb.toString();
	}
	
}

PlayerServiceImpl：

package com.henu.service.impl;

import java.util.List;

import com.henu.bean.Player;
import com.henu.dao.PlayerDao;
import com.henu.dao.impl.PlayerDaoImpl;
import com.henu.service.PlayerService;

public class PlayerServiceImpl implements PlayerService{

	PlayerDao playerDao = new PlayerDaoImpl();
	
	/**
	 * 全部球员
	 */
	public List<Player> allPlayer() {
		return playerDao.findAllPlayer();
	}

	/**
	 * 添加球员
	 */
	public int addPlayer(Player player) {
		return playerDao.insertPlayer(player);
	}
	/**
	 * 删除球员
	 */
	public int delPlayer(int id) {
		return playerDao.deletePlayer(id);
	}
	/**
	 * 更新球员
	 */
	public int updPlayer(Player player) {
		return playerDao.updatePlayer(player);
	}
	/**
	 * 根据id查询player
	 */
	public Player fPlayerByid(int id) {
		return playerDao.findPlayerById(id);
	}
	/**
	 * 根据不同条件查询player
	 */
	public List<Player> fPlayerByCondition(Player player) {
		return playerDao.findPlayerByCondition(player);
	}

}

PlayerServlet：

package com.henu.servlet;

import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Date;
import java.util.List;
import java.util.Map;

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

import org.apache.commons.beanutils.BeanUtils;
import org.apache.commons.beanutils.ConvertUtils;
import org.apache.commons.beanutils.Converter;
import org.apache.commons.beanutils.converters.DateConverter;

import com.henu.bean.Player;
import com.henu.service.PlayerService;
import com.henu.service.impl.PlayerServiceImpl;
import com.henu.utils.MyDateConverter;
import com.mchange.v2.c3p0.test.FreezableDriverManagerDataSource;
/**
 * @author George
 * @description 考虑到以后项目的问题，大致同类的方法我们可以放在同一个Servlet中
 * 当然一个Servlet对应一个方法，不是不可以，但是过于繁琐。因此
 */
public class PlayerServlet 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 {
		
		//解决post乱码问题
		request.setCharacterEncoding("UTF-8");
		
		String fun = request.getParameter("fun");
		
		if ("findAll".equals(fun)) {
			//findAll效果网址http://localhost:8081/tomcat05/PlayerServlet?fun=findAll
			findAll(request,response);
		}else if ("add".equals(fun)) {
			add(request,response);
		}else if ("del".equals(fun)) {
			del(request,response);
		}else if ("preUpd".equals(fun)) {
			preUpd(request,response);
		}else if ("upd".equals(fun)) {
			upd(request,response);
		}else if ("fpbc".equals(fun)) {
			fpbc(request,response);
		}
			
	}
	/**
	 * @param request
	 * @param response
	 * 根据不同条件查询player
	 */
	protected void fpbc(HttpServletRequest request, HttpServletResponse response) {
		
		//1 获取数据（客户端提交的数据） BeanUtils
		Map<String,String[]> map =request.getParameterMap();
		
		//2 对象
		Player player = new Player();
		
		
		//3 先处理日期类型
		/*	
		DateConverter dc = new DateConverter();
		dc.setPatterns(new String[]{"yyyy-MM-dd","yyyy-MM-dd HH:mm:ss"});
		ConvertUtils.register(dc,Date.class);
		*/
		// 如果使用BeanUtils中自带的日期类型转换器DateConverter 对于 null 或 "" 拷贝时会出现异常
		// 解决方式：自定义日期类型转换器
		ConvertUtils.register(new MyDateConverter(),Date.class);
		
		
		// 4 拷贝
		try {
			BeanUtils.populate(player,map);
		} catch (Exception e) {
			e.printStackTrace();
		} 
		
		// 5 调用service
		PlayerService service = new PlayerServiceImpl();
		
		List<Player> list = service.fPlayerByCondition(player);
		if (list != null) {
			request.setAttribute("list",list);
			
			try {
				request.getRequestDispatcher("index.jsp").forward(request, response);
			} catch (ServletException e) {
				e.printStackTrace();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}else{
			try {
				request.getRequestDispatcher("fpbc.jsp").forward(request, response);
			} catch (ServletException e) {
				e.printStackTrace();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		
		
	}

	/**
	 * @param request
	 * @param response
	 * 更新操作前的准备根据所取id查出整个player的信息，然后通过request.setAttribute("p",p);
	 * 将player传到updatePlayer.jsp上，使其获取player的各个属性，并在updatePlayer.jsp
	 * 上对属性进行更改，提交后跳转PlayerServlet?fun=upd进行更新
	 */
	protected void preUpd(HttpServletRequest request, HttpServletResponse response) {
		
		//获取"PlayerServlet?fun=preUpd&id=<%=s.getId() %>>的id
		String id = request.getParameter("id");
		
		PlayerService service = new PlayerServiceImpl();
		//进行查询
		Player p = service.fPlayerByid(Integer.parseInt(id));
		
		request.setAttribute("p",p);
		
		//跳转到更改页面
		try {
			request.getRequestDispatcher("updatePlayer.jsp").forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}

	/**
	 * @param request
	 * @param response
	 * 更新球员
	 */
	protected void upd(HttpServletRequest request, HttpServletResponse response) {
		//获取数据
		Map<String, String[]> map = request.getParameterMap();
		
		Player player = new Player();
		
		DateConverter dc = new DateConverter();
		dc.setPatterns(new String[]{"yyyy-MM-dd","yyyy-MM-dd HH:mm:ss"});
		ConvertUtils.register(dc, Date.class);
		
		//拷贝
		try {
			BeanUtils.populate(player, map);
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (InvocationTargetException e) {
			e.printStackTrace();
		}
		
		// 5 调用service
		PlayerService service = new PlayerServiceImpl();
		
		int res = service.updPlayer(player);
		
		if(res==1){  // 更新成功
			try {
				response.sendRedirect("PlayerServlet?fun=findAll&msg=success");
			} catch (IOException e) {
				e.printStackTrace();
			}
			
		}else{  //更新失败
			try {
				response.sendRedirect("updatePlayer.jsp?msg=fail");
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	
		
	}

	/**
	 * @param request
	 * @param response
	 * 删除球员
	 */
	protected void del(HttpServletRequest request, HttpServletResponse response) {

		int id = Integer.parseInt(request.getParameter("id"));
		
		PlayerService service = new PlayerServiceImpl();
		int res = service.delPlayer(id);
		
		if (res == 1) {//添加成功后跳转到显示页面
			try {
				response.sendRedirect("PlayerServlet?fun=findAll&msg=success");
			} catch (IOException e) {
				e.printStackTrace();
			}
		}else {
			try {
				response.sendRedirect("PlayerServlet?fun=findAll&msg=fail");
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}

	/**
	 * @param request
	 * @param response
	 * 添加球员
	 */
	protected void add(HttpServletRequest request, HttpServletResponse response) {
		
		//获取数据BeanUtils
		Map<String, String[]> map = request.getParameterMap();
		
		Player player = new Player();
		
		//处理日期对象
		DateConverter dConverter = new DateConverter();
		dConverter.setPatterns(new String[]{"yyyy-MM-dd","yyyy-MM-dd HH:mm:ss"});
		ConvertUtils.register(dConverter, Date.class);
		
		//拷贝数据
		try {
			BeanUtils.populate(player, map);
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (InvocationTargetException e) {
			e.printStackTrace();
		}
		
		PlayerService service = new PlayerServiceImpl();
		int res = service.addPlayer(player);
		
		if (res == 1) {//添加成功后跳转到显示页面
			try {
				response.sendRedirect("PlayerServlet?fun=findAll&msg=success");
			} catch (IOException e) {
				e.printStackTrace();
			}
		}else {
			try {
				response.sendRedirect("PlayerServlet?fun=findAll&msg=fail");
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		
	}
	/**
	 * @param request
	 * @param response
	 * 查询全部
	 */
	protected void findAll(HttpServletRequest request, HttpServletResponse response) {

		String msg = request.getParameter("msg");
		
		request.setAttribute("msg", msg);
		
		PlayerService service = new PlayerServiceImpl();
		List<Player> list = service.allPlayer();
		request.setAttribute("list", list);
		try {
			request.getRequestDispatcher("index.jsp").forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		};
		
	}

}

三个工具类：

public class DateUtil {
	public static Date stringToDate(String str){
		
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		Date d = null;
		try {
			d = sdf.parse(str);
		} catch (ParseException e) {
			e.printStackTrace();
		}
		return d;
	}
	
	public static String dateToString(Date date){
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		String str = sdf.format(date);
		return str;
	}
}
******************************************************************
public class JdbcUtil {
	
	private static DataSource ds;
	static{
		ds = new ComboPooledDataSource();
	}
	public static DataSource getDataSource(){
		return ds;
	}
	public static Connection getConnection(){
		Connection conn = null;
		try{
			conn = ds.getConnection();
			
		}catch(Exception e){
			e.printStackTrace();
		}
		return conn;
	}

}
******************************************************************
public class MyDateConverter implements Converter {

	public Object convert(Class arg0, Object arg1) {
		
		String str = (String)arg1;
		
		if(str==null || "".equals(str)){
			return null;
		}else{	
			return DateUtil.stringToDate(str);
		}
	}
}

addPlayer.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>add player view</title>
</head>
<body>
 
	<!-- 注意点：由于这里使用了PlayerServlet?fun=add&msg=success所以请求方式必须为post。如果使用get会导致到不了PlayerServlet?fun=add -->
	
	<form action="PlayerServlet?fun=add" method="post">
			<div style="width: 500px;height: 340px; border: 1px solid brown;text-align: center; margin: 150px auto;">
				<h1>球员添加页面</h1>
				<hr />
			<table style="margin: auto; text-align: center;"cellspacing="10px">
			
				
				<tr>
					<td>NAME:</td>
					<td><input type="text" name="name"/></td>
				</tr>
				<tr>
					<td>AGE:</td>
					<td><input type="text" name="age"/></td>
				</tr>
				<tr>
					<td>BIRTHDAY:</td>
					<td><input type="text" name="birthday"/></td>
				</tr>
				<tr>
					<td>HOBBY:</td>
					<td>
						<input type="checkbox" value="炸鸡"  name="hobby" />炸鸡
						<input type="checkbox" value="热狗" name="hobby" />热狗
						<input type="checkbox" value="方便面" name="hobby" />方便面
						<!--<input type="radio" value="炸鸡" name="hobby"/>炸鸡
						<input type="radio" value="热狗" name="hobby"/>热狗
						<input type="radio" value="方便面" name="hobby"/>方便面-->
					</td>
				</tr>
			</table>
			<input type="reset" value="重置" style="margin-top: 30px;margin-right: 100px;border: 0px; width: 70px;height: 30px;"/>
			<input type="submit" value="提交" style="border: 0px; width: 70px;height: 30px;"/>
			</div>
		</form>
</body>
</html>

fpbc.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>JPBC VIEW</title>
</head>
<body>
<form action="PlayerServlet?fun=fpbc" method="post">
			<div style="width: 500px;height: 340px; border: 1px solid brown;text-align: center; margin: 150px auto;">
				<h1>条件查询页面</h1>
				<hr />
			<table style="margin: auto; text-align: center;"cellspacing="10px">
			
				
				<tr>
					<td>NAME:</td>
					<td><input type="text" name="name"/></td>
				</tr>
				<tr>
					<td>AGE:</td>
					<td><input type="text" name="age"/></td>
				</tr>
				<tr>
					<td>BIRTHDAY:</td>
					<td><input type="text" name="birthday"/></td>
				</tr>
				<tr>
					<td>HOBBY:</td>
					<td>
						<input type="checkbox" value="炸鸡"  name="hobby" />炸鸡
						<input type="checkbox" value="热狗" name="hobby" />热狗
						<input type="checkbox" value="方便面" name="hobby" />方便面
					</td>
				</tr>
			</table>
			<input type="reset" value="重置" style="margin-top: 30px;margin-right: 100px;border: 0px; width: 70px;height: 30px;"/>
			<input type="submit" value="提交" style="border: 0px; width: 70px;height: 30px;"/>
			</div>
		</form>
</body>
</html>

index.jsp:

<%@page import="java.util.Arrays"%>
<%@page import="java.util.List"%>
<%@page import="com.henu.bean.Player"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
</head>
<body>


<h2 style="margin-left: 80px;margin-top: 80px;"><a href="addPlayer.jsp" >添加球员</a>
<a href="fpbc.jsp" style="margin-left: 10px;">条件查询球员</a>
<a href="PlayerServlet?fun=findAll" style="margin-left: 10px;">查询全部</a></h2>
<table style="margin:50px auto;" align="center" border="1px" width="70%">
       <tr>
          <th>序号</th>
          <th>NAME</th>
          <th>AGE</th>
          <th>BIRTHDAY</th>
          <th>HOBBY</th>
          <th>OPTION</th>
       </tr>
  <%
  
     List<Player> list = (List<Player>)request.getAttribute("list");
  
      int num=1;
      for(Player s:list){
  %>
      <tr>
         <td><%=num++ %></td>
         <td><%=s.getName() %></td>
         <td><%=s.getAge() %></td>
         <td><%=s.getBirthday() %></td>
         <td><%=Arrays.toString(s.getHobby())%></td>
         <td>
            <a href="PlayerServlet?fun=preUpd&id=<%=s.getId() %>">修改</a>
            <a href="PlayerServlet?fun=del&id=<%=s.getId()%>">删除</a>
         </td>
      </tr>
  
  <%} %>
  <h3>友情提示:</h3>
  <%
  
  
   String msg = (String)request.getAttribute("msg");
   
      if(msg!=null && !"".equals(msg)){
    	  if("fail".equals(msg)){
    %>
    
          <h1>操作失败</h1>
    
    <% 		  
    	  }else if("success".equals(msg)){
    		  
    %>		 
         <h1>操作成功</h1> 
   <%  		  
    	  }
      }
   %>
  
  </table>
</body>
</html>

updatePlayer.jsp

<%@page import="com.henu.bean.Player"%>
<%@page import="com.henu.service.impl.PlayerServiceImpl"%>
<%@page import="com.henu.service.PlayerService"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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 src="js/jquery.js"></script>
</head>
<body>
 <%
    String msg = request.getParameter("msg");
    if("fail".equals(msg)){
 %>
 <h1>更新失败!!!</h1>
 
 <% } %>
<%
Player p = (Player)request.getAttribute("p");
%>
	<!-- 提交后跳转到upd -->
	<form action="PlayerServlet?fun=upd" method="post">
			<div style="width: 500px;height: 340px; border: 1px solid brown;text-align: center; margin: 150px auto;">
				<h1>球员更改页面</h1>
				<hr />
			<table style="margin: auto; text-align: center;"cellspacing="10px">
				<input type="hidden" name="id" value="<%=p.getId() %>"/>
				<tr>
					<td>NAME:</td>
					<td><input type="text" name="name" value="<%=p.getName()%>"/></td>
				</tr>
				<tr>
					<td>AGE:</td>
					<td><input type="text" name="age" value="<%=p.getAge()%>"/></td>
				</tr>
				<tr>
					<td>BIRTHDAY:</td>
					<td><input type="text" name="birthday" value="<%=p.getBirthday()%>"/></td>
				</tr>
				<tr>
					<td>HOBBY:</td>
					<td>
						<input type="checkbox" value="炸鸡"  name="hobby" />炸鸡
						<input type="checkbox" value="热狗" name="hobby"/>热狗
						<input type="checkbox" value="方便面" name="hobby"/>方便面
						<!--<input type="radio" value="炸鸡" name="hobby"/>炸鸡
						<input type="radio" value="热狗" name="hobby"/>热狗
						<input type="radio" value="方便面" name="hobby"/>方便面-->
					</td>
				</tr>
			</table>
			<input type="reset" value="重置" style="margin-top: 30px;margin-right: 100px;border: 0px; width: 70px;height: 30px;"/>
			<input type="submit" value="提交" style="border: 0px; width: 70px;height: 30px;"/>
			</div>
		</form>
</body>
<script type="text/javascript">
      var cbs = $(':checkbox');
      <%
      String[] hobby = p.getHobby();
      %>
      cbs.each(function(){
    	  <%
    	     for(String str:hobby){
    	  %>
    	      if($(this).val()=='<%=str%>'){
    	    	  $(this).prop('checked',true);
    	      }
    	  <%}%>
      });
</script>
</html>

 

内容总结

以上是互联网集市为您收集整理的基于servlet&jsp&mysql的表格增删改查操作全部内容，希望文章能够帮你解决基于servlet&jsp&mysql的表格增删改查操作所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---