📄 post.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@ page language="java" import="java.sql.*,java.text.*,java.util.Date" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'post.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
  <jsp:useBean id="book" scope="session" class="beans.Book"/>
  <jsp:useBean id="mgr" scope="session" class="beans.bookMgr"/>
    <%  
          String url="jdbc:mysql://localhost:3306/bookstore";
	      Class.forName("com.mysql.jdbc.Driver");
	      String username="root";
	      String password="ptnest";
	      Connection con=DriverManager.getConnection(url,username,password);
	      Statement stmt = null;
	      
	        
      String name,author,content,category,publish_name,publish_address;
	  String language,commend,price,storenum ;
	  String cdrom,discount;
	  
	  
	  
	    name=request.getParameter("bookname");
	    author=request.getParameter("bookauthor");
		content=request.getParameter("bookcontent");
		category=request.getParameter("bookcategory");
		publish_name=request.getParameter("bookpublish_name");
		publish_address=request.getParameter("bookpublish_address");
		language=request.getParameter("booklanguage");
		commend=request.getParameter("bookcommend");
		price=request.getParameter("bookprice1")+"."+request.getParameter("bookprice2");
		storenum =request.getParameter("bookbook_number");
		cdrom=request.getParameter("bookcdrom");
		discount=request.getParameter("bookgood_price");
		
		book.setName(name);
		book.setAuthor(author);
		book.setCategory(Integer.parseInt(category));
		book.setCdrom(Integer.parseInt(cdrom));
		book.setCommend(Integer.parseInt(commend));
		book.setContent(content);
		book.setDiscount(Integer.parseInt(discount));
		book.setLanguage(language);
		SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
		java.util.Date today=new java.util.Date();
		book.setStr_on_desk_time(formatter.format(today));
		book.setPrice(Double.parseDouble(price));
		book.setPublish_address(publish_address);
		book.setPublish_name(publish_name);
		book.setStorenum(Integer.parseInt(storenum));
		
		try
		{		
		String sqlsearch="select * from book where name='"+name+"'";
		stmt=con.createStatement();
		ResultSet r=stmt.executeQuery(sqlsearch);
		int  searchnum=0;
		while(r.next()) 
		{
		 searchnum++;
		}
		  
        if (searchnum ==0)
        {	int i = mgr.add(book);
			if (i == 1) {
			out.println("<table width='770' border='0' align='center'>");
			   out.println("<tr>");
			   out.println("<td>");
			   out.println("<div align='center'><font color='red'>添加成功</font></div>");
			   out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/post.html>继续添加</a></font></div>");
			   out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/index.jsp>点击此处返回</a></font></div>");
			   out.println("</td>");
			   out.println("</tr>");
			   out.println("</table>");
				
			}
			else
			{
			out.println("<table width='770' border='0' align='center'>");
			   out.println("<tr>");
			   out.println("<td>");
			   out.println("<div align='center'><font color='red'>添加失败，数据库出错！！！</font></div>");
			   out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/post.html>点击此处返回</a></font></div>");
			   out.println("</td>");
			   out.println("</tr>");
			   out.println("</table>");
				
			}
		}
		else
		{ 	out.println("<table width='770' border='0' align='center'>");
			   out.println("<tr>");
			   out.println("<td>");
			   out.println("<div align='center'><font color='red'>该书已经存在</font></div>");
			   out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/index.jsp>点击此处返回</a></font></div>");
			   out.println("</td>");
			   out.println("</tr>");
			   out.println("</table>");
		}
		}catch(SQLException ex){
	  			System.err.println("SQLException: "+ ex.getMessage());
	  } 
		try
			  {
			       stmt.close();
		    	   con.close();
		      }catch(SQLException ex){
		  		System.err.println("SQLException: "+ ex.getMessage());
		  		}
	  %>
  </body>
</html>
⌨️ 快捷键说明

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