📄 book_add.jsp

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

💻 JSP

字号:

<%@ page language="java"  pageEncoding="GB2312"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="smart" scope="page" class="org.lxh.smart.SmartUpload"/>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBaddbook" 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{
	   	   
		// 1、上传初始化
		smart.initialize(pageContext) ;
		// 2、准备上传
		smart.upload() ;
		// 3、保存上传的文件
	    smart.save("/upload") ;
		String ext = smart.getFiles().getFile(0).getFileExt() ;
		int y,m,d,h,mm;
		Calendar c = Calendar.getInstance();
		y = c.get(Calendar.YEAR); //年
		m = c.get(Calendar.MONTH) + 1; //月
		d = c.get(Calendar.DAY_OF_MONTH); //日
		h = c.get(Calendar.HOUR); //时
		mm = c.get(Calendar.MINUTE); //分
		int ran=(int)(9000*Math.random()+1000);
		String name=Integer.toString(y)+Integer.toString(m)+Integer.toString(d)+Integer.toString(h)+Integer.toString(mm)+Integer.toString(ran);
		smart.getFiles().getFile(0).saveAs("/upload/"+name+"."+ext);
		String pic_path=name+"."+ext;
   		String cname=smart.getRequest().getParameter("class_name");
   		String bno=smart.getRequest().getParameter("book_no");
   		String bname=smart.getRequest().getParameter("book_name");
   		String cno=smart.getRequest().getParameter("class_no");
   		String auth=smart.getRequest().getParameter("book_aut");
   		String bpub=smart.getRequest().getParameter("book_pub");
   		String bpri=smart.getRequest().getParameter("book_pri");
   		String spri=smart.getRequest().getParameter("sale_pri");
   		String tota=smart.getRequest().getParameter("total_no");
   		String last=smart.getRequest().getParameter("last_no");
   		String time=smart.getRequest().getParameter("reg_time");
   		//String pic=smart.getRequest().getParameter("book_pic");
   		String cont=smart.getRequest().getParameter("book_con");
   		//ResultSet rs=null;
   		String SQLADD="insert into bookinfo(BookClass,BookNo,BookName,ID,Author,Publish,Price,SalePrice,Amount,Leav_number,RegTime,Pictrue,Content)" 
   		+"  values('"+cname+"','"+bno+"','"+bname+"','"+cno+"','"+auth+"','"+bpub+"','"+bpri+"','"+spri+"','"+tota+"','"+last+"','"+time+"','"+pic_path+"','"+cont+"')";
   			
   		DBaddbook.executeUpdate(SQLADD);
   		//out.print(SQLADD);	
   	}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 + -