高手们帮我看下到底哪里出了错误 数据库信息: 搜寻a之后,显示匹配的数据: 点删除后,删除不了,进入空白页面: 搜寻结果代码:还有就是为什么我这里设置了一个delete键和一个update键只显示一个delete键而已... delete.jsp的代码:input1的参数测试了是可以接收到数据库里的ID的,而且也把input1换成死参数,也可以从数据库里删除数据,但为什么这样就不可以了呢? 如果帮我测试下就更好了,搜寻代码我就不放了processSearch.jsp的代码<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Step 2: Define Connection URL
String connURL = "jdbc:odbc:practicalODBC"; // Step 3: Establish connection to URL
Connection conn = DriverManager.getConnection(connURL); //Step4:Create Statement object
Statement stmt = conn.createStatement(); String result = request.getParameter("searchString");
// Step 5: Execute SQL Command
String sqlStr = "SELECT * FROM OnlineShop where Brand like '%" +result + "%'";
ResultSet rs = stmt.executeQuery(sqlStr);
// Step 6: Process Result
%>
<table border="2">
<tr><td>Brand</td>
<td>Model</td>
<td>Functions</td>
<td>Quantity</td>
<td>Actions</td>
</tr>
<%
while(rs.next()){
String id= rs.getString("ID");
out.println("<tr>");
out.println("<td>" +rs.getString("Brand")+ "</td>");
out.println("<td>" +rs.getString("Model") + "</td>");
out.println("<td>" +rs.getString("Funtions") + "</td>");
out.println("<td>" +rs.getString("Quantity") + "</td>");
%>
<td><form action ="delete.jsp" method="get">
<input type="Submit" value="Delete" name="deleteBtn" />
<input type="hidden" name="hiddenId" style="width:0px" value="<%=id%>" />
</form> <form action ="update.jsp" method="get">
<input type="Submit" value="Update" name="updateBtn"
<input type="hidden" name="hiddenid" style="width:0px" value="<%=id%>" />
</form> </td>
<%
out.println("</tr>");
}
%></table>
<%
conn.close();
} catch (Exception e) {
System.err.println("Error :" + e);
}
%>
</body>
</html> delete.jsp代码:<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Step 2: Define Connection URL
String connURL = "jdbc:odbc:practicalODBC"; // Step 3: Establish connection to URL
Connection conn = DriverManager.getConnection(connURL); //Step4:Create Statement object
Statement stmt = conn.createStatement(); String input1 = request.getParameter("hiddenId");
// Step 5: Execute SQL Command
String sqlStr = "DELETE FROM OnlineShop where ID='"+ input1 + "'";
int rs = stmt.executeUpdate(sqlStr);
// Step 6: Process Result
if (rs > 0) out.println (rs + " records deleted");
// Step 7: Close connection
conn.close();
} catch (Exception e) {
System.err.println("Error :" + e);
}
%>
</body>
</html>
<%@page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Step 2: Define Connection URL
String connURL = "jdbc:odbc:practicalODBC"; // Step 3: Establish connection to URL
Connection conn = DriverManager.getConnection(connURL); //Step4:Create Statement object
Statement stmt = conn.createStatement(); String result = request.getParameter("searchString");
// Step 5: Execute SQL Command
String sqlStr = "SELECT * FROM OnlineShop where Brand like '%" +result + "%'";
ResultSet rs = stmt.executeQuery(sqlStr);
// Step 6: Process Result
%>
<table border="2">
<tr><td>Brand</td>
<td>Model</td>
<td>Functions</td>
<td>Quantity</td>
<td>Actions</td>
</tr>
<%
while(rs.next()){
String id= rs.getString("ID");
out.println("<tr>");
out.println("<td>" +rs.getString("Brand")+ "</td>");
out.println("<td>" +rs.getString("Model") + "</td>");
out.println("<td>" +rs.getString("Funtions") + "</td>");
out.println("<td>" +rs.getString("Quantity") + "</td>");
%>
<td><form action ="delete.jsp" method="get">
<input type="Submit" value="Delete" name="deleteBtn" />
<input type="hidden" name="hiddenId" style="width:0px" value="<%=id%>" />
</form> <form action ="update.jsp" method="get">
<input type="Submit" value="Update" name="updateBtn"
<input type="hidden" name="hiddenid" style="width:0px" value="<%=id%>" />
</form> </td>
<%
out.println("</tr>");
}
%></table>
<%
conn.close();
} catch (Exception e) {
System.err.println("Error :" + e);
}
%>
</body>
</html> delete.jsp代码:<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Step 2: Define Connection URL
String connURL = "jdbc:odbc:practicalODBC"; // Step 3: Establish connection to URL
Connection conn = DriverManager.getConnection(connURL); //Step4:Create Statement object
Statement stmt = conn.createStatement(); String input1 = request.getParameter("hiddenId");
// Step 5: Execute SQL Command
String sqlStr = "DELETE FROM OnlineShop where ID='"+ input1 + "'";
int rs = stmt.executeUpdate(sqlStr);
// Step 6: Process Result
if (rs > 0) out.println (rs + " records deleted");
// Step 7: Close connection
conn.close();
} catch (Exception e) {
System.err.println("Error :" + e);
}
%>
</body>
</html>
解决方案 »
- SSH框架 多用户使用 出现的问题
- [牛逼]Java 使用if(false)竟然走进去了!,求解这是什么情况有图!
- struts2用超链接访问,提示一个警告
- 求jpedal的jar包
- 超过2G文件下载问题
- JSF 的 h:datatable用法问题。
- 关于基于http 的客端访问服务端,报java.io.IOException: Server returned HTTP response code: 500 for URL:
- Ibatis 与Spring集成时QueryForList的分页方法报错,其他的queryForList可用
- 菜鸟提问:关于jakarta-tomcat-5.5.7和j2sdk1.4.2_07,大虾快进来!100分呀!!顶者有分!!!
- spring cloud 服务被删除
- 这是神马情况??
- jsp 实例化javaBean 对象的问题
初学者先把基本的CRUD功能做出来然后再去深入考虑其它
不为空的情况下,再看看是否为乱码。