📄 index8.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Exception.*"%>
<%
//数据库连接
String url="jdbc:odbc:xuesheng";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
//ResultSet result=stmt.executeQuery("update xinxi_book set");
//ResultSetMetaData resultmd=result.getMetaData();
%>
<html>
<body>
<%
if(request.getParameter("condition1")!=null)
{
String condition1=request.getParameter("condition1");
String condition2=request.getParameter("condition2");
String condition3=request.getParameter("condition3");
condition2 = new String(condition2.getBytes("ISO-8859-1"), "GBK");
//condition3 = new String(condition3.getBytes("ISO-8859-1"), "GBK");
String sql= "delete from xinxi_book where book_id =" + "'"+condition1+"'";
//ResultSet result1
//stmt.executeQuery(sql);
//out.println(sql);
out.println("<br>");
out.println("<p>");
out.println("<center>");
int n=stmt.executeUpdate(sql);
if(n>0)
{
out.println("成功删除图书");
out.println("<p>");
out.println("书号:"+condition1+"<p>");
out.println("书名:"+condition2+"<p>");
out.println("数量:"+condition3+"<p>");
}
else
{
out.println("操作未完成");
}
stmt.close();
con.close();
}
%>
<form method="POST" action="index7.jsp">
<center>
<input type="submit" value="返回">
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -