Tomcat 404 error: The origin server did not find a current representation for the target resource or 添加映射即可解決,添加@webServlet與路徑檔案名
package com.cjky;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class UpdateServlet
*/
@WebServlet("/UpdateServlet_modify") //缺少此句話就會出現“Tomcat 404 error: The origin server did not find a current representation for the target resource or”
public class UpdateServlet_modify extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// int id = Integer.valueOf(request.getParameter("id"));
// int bookCount = Integer.valueOf(request.getParameter("bookCount"));
String mc_name=request.getParameter("mc_name");
String modify_content=request.getParameter("modify_content");
try {
// 加載資料庫驅動,注冊到驅動管理器
Class.forName("com.mysql.jdbc.Driver");
// 資料庫連接配接字元串
String url = "jdbc:mysql://localhost:3306/db_cjky_pm";
// 資料庫使用者名
String username = "sa";
// 資料庫密碼
String password = "123456";
// 建立Connection連接配接
Connection conn = DriverManager.getConnection(url,username,password);
// 更新SQL語句
String sql = "update tb_books set modify_content=? where mc_name=?";
// 擷取PreparedStatement
PreparedStatement ps = conn.prepareStatement(sql);
// 對SQL語句中的第一個參數指派
ps.setString(1, modify_content);
// 對SQL語句中的第二個參數指派
ps.setString(2, mc_name);
// 執行更新操作
ps.executeUpdate();
// 關閉PreparedStatement
ps.close();
// 關閉Connection
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
// 重定向到FindServlet
response.sendRedirect("data_query_servlet");
}
}