?? index_0002ejsp_jsp.java
字號:
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class index_0002ejsp_jsp extends HttpJspBase {
// begin [file="/index.jsp";from=(8,0);to=(8,66)]
// end
// begin [file="/index.jsp";from=(9,3);to=(21,0)]
//處理表單輸入漢字的亂碼問題
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;}
}
// end
// begin [file="/index.jsp";from=(23,3);to=(23,36)]
String name,email,url,body,sql;
// end
static {
}
public index_0002ejsp_jsp( ) {
}
private static boolean _jspx_inited = false;
public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
String _value = null;
try {
if (_jspx_inited == false) {
synchronized (this) {
if (_jspx_inited == false) {
_jspx_init();
_jspx_inited = true;
}
}
}
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=GB2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/index.jsp";from=(0,70);to=(1,0)]
out.write("\r\n");
// end
// begin [file="/index.jsp";from=(1,2);to=(1,41)]
request.setCharacterEncoding("gb2312");
// end
// HTML // begin [file="/index.jsp";from=(1,43);to=(8,0)]
out.write("\r\n<html>\r\n<head>\r\n<title>\r\nindex\r\n</title>\r\n</head>\r\n");
// end
// begin [file="/index.jsp";from=(8,0);to=(8,66)]
bean.sql_data sqlbean = null;
boolean _jspx_specialsqlbean = false;
synchronized (session) {
sqlbean= (bean.sql_data)
pageContext.getAttribute("sqlbean",PageContext.SESSION_SCOPE);
if ( sqlbean == null ) {
_jspx_specialsqlbean = true;
try {
sqlbean = (bean.sql_data) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "bean.sql_data");
} catch (ClassNotFoundException exc) {
throw new InstantiationException(exc.getMessage());
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"bean.sql_data", exc);
}
pageContext.setAttribute("sqlbean", sqlbean, PageContext.SESSION_SCOPE);
}
}
if(_jspx_specialsqlbean == true) {
// end
// begin [file="/index.jsp";from=(8,0);to=(8,66)]
}
// end
// HTML // begin [file="/index.jsp";from=(8,66);to=(9,0)]
out.write("\r\n");
// end
// HTML // begin [file="/index.jsp";from=(21,2);to=(23,0)]
out.write("\r\n<body bgcolor=\"#ffffff\">\r\n");
// end
// HTML // begin [file="/index.jsp";from=(23,38);to=(24,0)]
out.write("\r\n");
// end
// begin [file="/index.jsp";from=(24,2);to=(48,0)]
//接收表單傳遞來的信息
name = request.getParameter("name");
email = request.getParameter("email");
url = request.getParameter("url");
body = request.getParameter("body");
if (name.length()==0 ||email.length()==0||body.length()==0)
{
out.println("<b><font color=red>Sorry,Please enter your name,email and body!!!</font></b>");
}
else
{
//調用sqlbean中的方法將表單數據插入數據庫作為一條記錄
sql="insert into guestbook (name,email,url,body) values('"+name+"','"+email+"','"+url+"','"+body+"')";
//sql="insert into guestbook (name,email,url,body) values('"+getStr(name)+"','"+email+"','"+url+"','"+getStr(body)+"')";
sqlbean.executeInsert(sql);//調用sqlbean中的方法將表單數據插入數據庫作為一條記錄
//調用sqlbena中的方法查詢數據庫，將查詢結果保存到結果集RScount中
ResultSet RScount = sqlbean.executeQuery("SELECT * FROM guestbook");
int i=0;
while (RScount.next())//統計記數據庫中的記錄個數
{
i++;
}
// end
// HTML // begin [file="/index.jsp";from=(48,2);to=(50,9)]
out.write("\r\n\r\n<p><B>現在有");
// end
// begin [file="/index.jsp";from=(50,12);to=(50,15)]
out.print( i );
// end
// HTML // begin [file="/index.jsp";from=(50,17);to=(51,0)]
out.write(" 條紀錄</B></p>\r\n");
// end
// begin [file="/index.jsp";from=(51,2);to=(54,0)]
RScount.close();//關閉結果集
i=0;
// end
// HTML // begin [file="/index.jsp";from=(54,2);to=(56,0)]
out.write("\r\n<p> </p>\r\n");
// end
// begin [file="/index.jsp";from=(56,2);to=(64,0)]
ResultSet RS=sqlbean.executeQuery("SELECT * FROM guestbook");//再次查詢數據庫
while (RS.next())// 逐條輸出數據庫中的記錄
{
name=RS.getString("name");//獲得記錄的每一個字段
email=RS.getString("email");
url=RS.getString("url");
body=RS.getString("body");
// end
// HTML // begin [file="/index.jsp";from=(64,2);to=(67,36)]
out.write("\r\n<table border=1 width=80%>\r\n<tr>\r\n<td width=30%>昵稱:</td><td width=70%>");
// end
// begin [file="/index.jsp";from=(67,39);to=(67,43)]
out.print(name);
// end
// HTML // begin [file="/index.jsp";from=(67,45);to=(70,54)]
out.write("\r\n</tr>\r\n<tr>\r\n<td width=30%>電子郵件:</td><td width=70%><a href=\"mailto:");
// end
// begin [file="/index.jsp";from=(70,57);to=(70,62)]
out.print(email);
// end
// HTML // begin [file="/index.jsp";from=(70,64);to=(70,66)]
out.write("\">");
// end
// begin [file="/index.jsp";from=(70,69);to=(70,74)]
out.print(email);
// end
// HTML // begin [file="/index.jsp";from=(70,76);to=(73,49)]
out.write("</a></td>\r\n</tr>\r\n<tr>\r\n<td width=30%>個人主頁地址:</td><td width=70%><a href=\"");
// end
// begin [file="/index.jsp";from=(73,52);to=(73,55)]
out.print(url);
// end
// HTML // begin [file="/index.jsp";from=(73,57);to=(73,59)]
out.write("\">");
// end
// begin [file="/index.jsp";from=(73,62);to=(73,65)]
out.print(url);
// end
// HTML // begin [file="/index.jsp";from=(73,67);to=(76,36)]
out.write("</a></td>\r\n</tr>\r\n<tr>\r\n<td width=30%>內容:</td><td width=70%>");
// end
// begin [file="/index.jsp";from=(76,39);to=(76,43)]
out.print(body);
// end
// HTML // begin [file="/index.jsp";from=(76,45);to=(80,0)]
out.write("</td>\r\n</tr>\r\n</table>\r\n<hr>\r\n");
// end
// begin [file="/index.jsp";from=(80,2);to=(85,0)]
}
RS.close();
}
// end
// HTML // begin [file="/index.jsp";from=(85,2);to=(87,7)]
out.write("\r\n</body>\r\n</html>");
// end
} catch (Throwable t) {
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -