一个Servlet小练习

最新推荐文章于 2022-05-12 17:29:31 发布

Hai-Yang-code

最新推荐文章于 2022-05-12 17:29:31 发布

阅读量259

点赞数 1

文章标签： java ajax

本文链接：https://blog.csdn.net/weixin_45007916/article/details/105414767

版权

一个Servlet小练习

新建一个servlet类
在这里插入图片描述
一个简单的数据库

前端页面


```javascript
<form >
	<input type="text" name="username" placeholder="请输入用户名" id="username" required/>
	<input type="text" name="age" placeholder="请输入年龄" id="age" required/>
	<input type="button" id="btn" value="提交"/>
</form>
<h3>ajax请求返回的数据</h3>
<table border="1" style=" border-collapse:collapse ;width:300px;text-align:center">
	<tr>
		<th>id</th>	
		<th>姓名</th>
		<th>年龄</th>
		<th>信息</th>
	</tr>
	<tbody id="content">
		
	</tbody>
</table>

通过ajax在tbody动态添加表格

``后台

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
		{   
			request.setCharacterEncoding("utf-8");
			response.setCharacterEncoding("utf-8");
			
			String action=request.getParameter("action");
			
			String sql="select * from user where 1=1";
			String []col= {"id","username","age","userinfo"};
			
			if(action.equals("findAll")) {
			}
			
			if(action.equals("findById")) {
				String username=request.getParameter("username");
				String age=request.getParameter("age");
				if(!username.equals("")) {
					sql+=" and username like \"%"+username+"%\"";
				}
				if(!age.equals("")) {
					sql+=" and age ="+age;
				}
			}
			
			sql+=" order by id desc limit 0,5";
			String jsonStr= MysqlUtil.getJsonBySql(sql, col);//自己写的数据库工具类
			response.getWriter().append(jsonStr);
		}

```java
在这里插入代码片

![在这里插入图片描述](https://img-blog.csdnimg.cn/20200409171713175.png#pic_center)
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200409171732885.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTAwNzkxNg==,size_16,color_FFFFFF,t_70#pic_center)
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200409171746556.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTAwNzkxNg==,size_16,color_FFFFFF,t_70#pic_center)