📄 book_up.jsp

📁 java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用

💻 JSP

字号:

<%@ page language="java"  pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBupbook" scope="page" class="ConnBean.conn"/>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head> 
    <title>My JSP 'book_up.jsp' starting page</title>
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  <body BGCOLOR="#FFCCCC">
   <%
   	try{
   		String cname=request.getParameter("class_name");
   		String bno=request.getParameter("book_no");
   		String bname=request.getParameter("book_name");
   		String cno=request.getParameter("class_no");
   		String auth=request.getParameter("book_aut");
   		String bpub=request.getParameter("book_pub");
   		String bpri=request.getParameter("book_pri");
   		String spri=request.getParameter("sale_pri");
   		String pic=request.getParameter("book_pic");
   		String cont=request.getParameter("book_con");
   		//ResultSet rs=null;
   		String SQLup="update bookinfo  set  ID='"+cno+"',BookName='"+bname+"',Author='"+auth+"',BookClass='"+cname+"',Publish='"+bpub+"',Pictrue='"+pic+"',Content='"+cont+"',Price='"+bpri+"',SalePrice='"+spri+"'  where BookNo='"+bno+"' " ;
   		DBupbook.executeUpdate(SQLup);
   		//out.print(SQLup);
   		//out.print(count);	
   	}catch(Exception e){
   		out.print(e);}
	   	out.println("<script language=javascript>");
		out.println("alert('恭喜你,修改成功!');");
		out.println("window.location.href='bookinfo.jsp';");
		out.println("</script>");	
   %>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -