post_ok.jsp

来自「jsp的技术教程」· JSP 代码 · 共 155 行

 <%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="test.faq" />
  
<%!
public String getStr(String str)
{
	try
	{
		String temp_p=str;
		byte[] temp_t=temp_p.getBytes("ISO8859-1");
		String temp=new String(temp_t);
		return temp;
	}
	catch(Exception e)
	{
	 
	}
	return "null";
}
%>
<%!
public static String returnToBr(String sStr) { 
if (sStr == null || sStr.equals("")) { 
return sStr; 
} 

StringBuffer sTmp = new StringBuffer(); 
int i = 0; 

while (i <= sStr.length()-1) { 
if (sStr.charAt(i) == '\n'||sStr.charAt(i)=='\r') { 
sTmp = sTmp.append("<br>"); 
} else if (sStr.charAt(i) == ' ') { 
sTmp = sTmp.append("&nbsp;"); 
}else { 
sTmp = sTmp.append(sStr.substring(i,i+1)); 
} 

i++; 
} 
String S1;
S1=sTmp.toString();
return S1; 
} 

%>
<%!
public static String returnToHTML(String sStr) { 
if (sStr == null || sStr.equals("")) { 
return sStr; 
} 

StringBuffer sTmp1 = new StringBuffer(); 
int i = 0; 

while (i <= sStr.length()-1) { 

if (sStr.charAt(i) == '<') { 
sTmp1 = sTmp1.append("&lt;"); 
} else if (sStr.charAt(i) == '>') { 
sTmp1 = sTmp1.append("&gt;"); 
}else
 { 
sTmp1 = sTmp1.append(sStr.substring(i,i+1)); 
} 

i++; 
} 
String S2;
S2=sTmp1.toString();
return S2; 
} 

%>
<%!
String name,author,content,category,publish_name,publish_address;
String language,commend,price,book_number;
String cdrom,good_price;
%>
<%
name=returnToBr(returnToHTML(request.getParameter("name")));
author=returnToBr(returnToHTML(request.getParameter("author")));
content=returnToBr(returnToHTML(request.getParameter("content")));
category=returnToBr(returnToHTML(request.getParameter("category")));
publish_name=returnToBr(returnToHTML(request.getParameter("publish_name")));
publish_address=returnToBr(returnToHTML(request.getParameter("publish_address")));
language=returnToBr(returnToHTML(request.getParameter("language")));
commend=returnToBr(returnToHTML(request.getParameter("commend")));
price=returnToBr(returnToHTML(request.getParameter("price1")+"."+request.getParameter("price2")));
book_number=returnToBr(returnToHTML(request.getParameter("book_number")));
cdrom=returnToBr(returnToHTML(request.getParameter("cdrom")));
good_price=returnToBr(returnToHTML(request.getParameter("good_price")));

//转换成中文
name=getStr(name);
author=getStr(author);
content=getStr(content);
category=getStr(category);
publish_name=getStr(publish_name);
publish_address=getStr(publish_address);
%>

<%@ include file="head.inc"%>

<jsp:useBean id='clock' scope='page' class='dates.JspCalendar' type="dates.JspCalendar" />      
             
<TABLE border=0 cellPadding=0 cellSpacing=0 width=760 align="center">
  <TBODY>
  <tr><td align="left" height=25><%if(session.getAttribute("username")!=null){out.println(session.getAttribute("username"));}%>  当前位置：<a href="../index.jsp">首页</a> -&gt; <a href="index.jsp">教程文章</a> -&gt; 张贴教程文章  </td>
 <%@ include file="../member/date.inc"%>
  </tr>
  <TR bgColor=#3399ff>
    <TD height=1 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></TD></TR>
  <tr><td height=10 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></td></tr>
  </TBODY></TABLE>

  <table align="center" border="0" width="760" cellspacing="0" cellpadding="0" height="355">                  
	<tr>                  
		<td width="150" height="355" valign="top">                  
	
		</td>                  
		<td width="10" height="100%"></td>
		<td width="1" height="100%" bgcolor="#3399ff"></td>
		<td width="10" height="100%"></td>
		<td width="589" height="331" valign="top" background="images/bg1.gif">                       
        <table border="0" width="100%" cellspacing="0" cellpadding="0" height="307">                  
          <tr>                  
            <td width="100%" height="20" bgcolor="#3399ff">&nbsp;<font color="#ffffff">书库</font>
			</td>
		  </tr>

		  <tr>
			<td>
<%out.println("发布成功！！！");%>
			</td>
		  </tr>
        </table>                  

		

        </td>
    </tr>

  </table>
 <%
 String sqlinsert="insert into  book(name,author,language,content,category,commend,publish_name, publish_address,cdrom,price,good_price,book_number)  Values('"+name+"','"+author+"','"+language+"','"+content+"','"+category+"','"+commend+"','"+publish_name +"','"+publish_address+"','"+cdrom+"','"+price+"','"+good_price+"','"+book_number+"')";
workM.executeQuery(sqlinsert);
 %>
<%@ include file="footer.inc"%>