serverlet 连接mysql_restlet2.1 学习笔记(二) 分别处理Get Post Put请求

servlet只支持GET与POST两种请求。 但是restlet除了支持GET与POST请求外还支持Delete Put OPTIONS 等多种请求 。 第一步,编写资源类 (可以将资源类想象成Struts2的Action ,每个加上注解的方法都是一个ActionMethod) MovieResource.java package com.zf.r

servlet只支持GET与POST两种请求。

但是restlet除了支持GET与POST请求外还支持Delete Put OPTIONS 等多种请求 。

第一步,编写资源类

(可以将资源类想象成Struts2的Action ,每个加上注解的方法都是一个ActionMethod)

MovieResource.java

package com.zf.restlet.demo02.server;

import org.restlet.resource.Delete;

import org.restlet.resource.Get;

import org.restlet.resource.Post;

import org.restlet.resource.Put;

import org.restlet.resource.ServerResource;

/**

* 以3中Method为例

* @author zhoufeng

*

*/

public class MovieResource extends ServerResource{

@Get

public String play(){

return "电影正在播放...";

}

@Post

public String pause(){

return "电影暂停...";

}

@Put

public String upload(){

return "电影正在上传...";

}

@Delete

public String deleteMovie(){

return "删除电影...";

}

}

第二步,使用html客户端访问(html默认只支持get与post访问。所以下面演示着两种)

demo02.html

demo02

访问该html通过两个按钮可以发送不同的请求,并会有不同的返回值

第三步:使用Restlet编写客户端调用

MovieClient.java

package com.zf.restlet.demo02.client;

import java.io.IOException;

import org.junit.Test;

import org.restlet.representation.Representation;

import org.restlet.resource.ClientResource;

public class MovieClient {

@Test

public void test01() throws IOException{

ClientResource client = new ClientResource("http://localhost:8888/");

Representation result = client.get() ;//调用get方法

System.out.println(result.getText());

}

@Test

public void test02() throws IOException{

ClientResource client = new ClientResource("http://localhost:8888/");

Representation result = client.post(null) ;//调用post方法

System.out.println(result.getText());

}

@Test

public void test03() throws IOException{

ClientResource client = new ClientResource("http://localhost:8888/");

Representation result = client.put(null) ;//调用put方法

System.out.println(result.getText());

}

@Test

public void test04() throws IOException{

ClientResource client = new ClientResource("http://localhost:8888/");

Representation result = client.delete() ;//调用delete方法

System.out.println(result.getText());

}

}

f68f2add0b68e4f9810432fce46917b7.png

本文原创发布php中文网,转载请注明出处,感谢您的尊重!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
首先,需要创建一个数据库和对应的表。假设我们创建了一个名为“student”的数据库,其中有一个名为“student_info”的表,包含id、name、age和gender四个字段。 接下来,需要创建一个Java Web项目,将mysql-connector-java包添加到项目中。 在项目中创建一个servlet,并在web.xml中进行配置。 在servlet中,使用JDBC连接数据库,并实现增删改查操作。下面是一个示例代码: ``` import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class StudentServlet extends HttpServlet { private static final long serialVersionUID = 1L; private Connection conn = null; private PreparedStatement pstmt = null; private ResultSet rs = null; // 连接数据库 private void getConnection() { String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/student"; String user = "root"; String password = "123456"; try { Class.forName(driver); conn = DriverManager.getConnection(url, user, password); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } // 关闭资源 private void close() { try { if (rs != null) { rs.close(); } if (pstmt != null) { pstmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } // 查询 private void query(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); String sql = "SELECT * FROM student_info"; try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { out.println(rs.getInt("id") + " " + rs.getString("name") + " " + rs.getInt("age") + " " + rs.getString("gender")); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } // 插入 private void insert(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); int id = Integer.parseInt(request.getParameter("id")); String name = request.getParameter("name"); int age = Integer.parseInt(request.getParameter("age")); String gender = request.getParameter("gender"); String sql = "INSERT INTO student_info(id, name, age, gender) VALUES(?, ?, ?, ?)"; try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); pstmt.setString(2, name); pstmt.setInt(3, age); pstmt.setString(4, gender); int count = pstmt.executeUpdate(); if (count > 0) { out.println("插入成功!"); } else { out.println("插入失败!"); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } // 更新 private void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); int id = Integer.parseInt(request.getParameter("id")); String name = request.getParameter("name"); int age = Integer.parseInt(request.getParameter("age")); String gender = request.getParameter("gender"); String sql = "UPDATE student_info SET name=?, age=?, gender=? WHERE id=?"; try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, name); pstmt.setInt(2, age); pstmt.setString(3, gender); pstmt.setInt(4, id); int count = pstmt.executeUpdate(); if (count > 0) { out.println("更新成功!"); } else { out.println("更新失败!"); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } // 删除 private void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); getConnection(); int id = Integer.parseInt(request.getParameter("id")); String sql = "DELETE FROM student_info WHERE id=?"; try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); int count = pstmt.executeUpdate(); if (count > 0) { out.println("删除成功!"); } else { out.println("删除失败!"); } } catch (SQLException e) { e.printStackTrace(); } finally { close(); } } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); String op = request.getParameter("op"); if ("query".equals(op)) { query(request, response); } else if ("insert".equals(op)) { insert(request, response); } else if ("update".equals(op)) { update(request, response); } else if ("delete".equals(op)) { delete(request, response); } } } ``` 在jsp页面中,可以通过表单提交数据,并调用对应的servlet实现增删改查操作。例如: ``` <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="insert"> ID:<input type="text" name="id"><br> 姓名:<input type="text" name="name"><br> 年龄:<input type="text" name="age"><br> 性别:<input type="text" name="gender"><br> <input type="submit" value="插入"> </form> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="query"> <input type="submit" value="查询"> </form> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="update"> ID:<input type="text" name="id"><br> 姓名:<input type="text" name="name"><br> 年龄:<input type="text" name="age"><br> 性别:<input type="text" name="gender"><br> <input type="submit" value="更新"> </form> <form action="StudentServlet" method="post"> <input type="hidden" name="op" value="delete"> ID:<input type="text" name="id"><br> <input type="submit" value="删除"> </form> </body> </html> ``` 以上代码实现了一个简单的增删改查功能。需要注意的是,这只是一个示例,实际应用中需要根据具体情况进行修改。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值