index10.jsp

来自「WEB图书馆系统,jsp编写,适用用于JSP的初始者」· JSP 代码 · 共 65 行

JSP
65
字号
<%@ 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");
    String condition4=request.getParameter("condition4");
    String condition5=request.getParameter("condition5");

condition2 = new String(condition2.getBytes("ISO-8859-1"), "GBK");  
condition3 = new String(condition3.getBytes("ISO-8859-1"), "GBK");

String sql= "update xinxi_book set book_name=" +"'"+condition2+"',book_author='"+condition3+"',book_prices='"+condition4+"',book_amount='"+condition5+"'"+                         
"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("图书修改成功");

}
else
{
	out.println("操作未完成");
}




stmt.close();
con.close();
}
%>
<form method="POST" action="index9.jsp">
<center>
<input type="submit" value="返回">
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?