📄 index3.jsp
字号:
<%@page contentType="text/html;charset=gbk"%>
<%@ 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("select * from xinxi_book");
ResultSetMetaData resultmd=result.getMetaData();
%>
<html>
<style type="text/css">
<!--
body {
background-image: url(33935932.jpg);
}
-->
</style>
<body>
<form method="POST" action="index3.jsp">
<p align="center">
</p>
<p align="center">
</p>
<p align="center">
<p align="center">
<tr>
下架书号：
</tr>
<tr>
<input type="text" name="condition1">
</tr>
<tr>
下架数量：
</tr>
<tr>
<input type="text" name="condition2">
</tr>
</p>
<p align="center">
<input type="submit" value="确定">
<input type="reset" name="Submit" value="清空">
</p>
<%
if(request.getParameter("condition2")!=null)
{
String condition1=request.getParameter("condition1");
String condition2=request.getParameter("condition2");
//out.println(resultmd.getColumnName(5));
//condition = new String(condition.getBytes("ISO-8859-1"), "GBK");
//ResultSet result1
//stmt.executeQuery(sql);
out.println("<br>");
//out.println(sql);
String sql1= "select book_amount from xinxi_book where book_id = "+"'"+condition1+"'";
ResultSet result1=stmt.executeQuery(sql1);
if(result1.next())
{
String a=result1.getString("book_amount");
int b=Integer.parseInt(a);
if(b>0){
String sql="update xinxi_book set book_amount = book_amount -" + condition2 + "where book_id = "+"'"+condition1+"'" ;
out.println("<br>");
int n=stmt.executeUpdate(sql);
if(n>0)
{
out.println("成功下架"+condition2+"本书!");
}
else
{
out.println("操作未完成");
}
}
else
{
out.println("藏书库存不足！无法执行！");
}
}
else{
out.println("无书目录~");
}
stmt.close();
con.close();
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -