📄 create_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public final class create_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static final JspFactory _jspxFactory = JspFactory.getDefaultFactory();
private static java.util.Vector _jspx_dependants;
private org.apache.jasper.runtime.ResourceInjector _jspx_resourceInjector;
public Object getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
response.setContentType("text/html; charset=UTF-8");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
_jspx_resourceInjector = (org.apache.jasper.runtime.ResourceInjector) application.getAttribute("com.sun.appserv.jsp.resource.injector");
out.write("\r\n");
out.write("\r\n");
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
out.write("\r\n");
out.write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\r\n");
out.write("\"http://www.w3.org/TR/html4/loose.dtd\">\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<title>������</title>\r\n");
out.write("</head>\r\n");
out.write("<body bgcolor=\"#ffffff\">\r\n");
out.write("<h1></h1>\r\n");
out.write("<table border=\"1\">\r\n");
out.write("<caption>������</caption>\r\n");
out.write(" <tr><td>���</td>\r\n");
out.write(" <td>�û���</td>\r\n");
out.write(" </tr>\r\n");
long begin = (long)System.currentTimeMillis();
StringBuffer createTable = new StringBuffer()
.append("create table delete(")
.append(" USERID bigserial, ")
.append(" USERNAME varchar(32),")
.append(" PASSWORD varchar(32)")
.append(");");
StringBuffer insertData = new StringBuffer()
.append("insert into delete(USERNAME,PASSWORD) values(?,?)");
Connection con = null;
PreparedStatement ps = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url = "jdbc:odbc:news" ;
con = DriverManager.getConnection(url, "admin" , "admin" );
st = con.createStatement();
st.executeUpdate(createTable.toString());
ps = con.prepareStatement(insertData.toString());
ps.setString(1,"����");
ps.setString(2,"1234");
ps.executeUpdate();
String sql = "select * from delete" ;
rs = st.executeQuery(sql);
while (rs.next())
{
out.println("<tr><td>");
out.println(String.valueOf(rs.getLong("USERID"))+"</td><td>");
out.println(rs.getString("USERNAME")+"</td></tr>");
}
} catch (Exception e) {
try{
if (con != null){
con.rollback();
out.println("<br><font color=\"red\">数据库操作1类异常!</font><br>");
}
}catch(SQLException ex){
out.println("<br><font color=\"red\">�数据库操作2类异常!!</font><br>");
}
} finally {
try{
if(ps!=null) ps.close();
if(rs != null) rs.close();
if(st != null) st.close();
if(con != null) con.close();
}catch(SQLException e){
out.println("<br><font color=\"red\">�数据库操作3类异常!</font><br>");
}
}
out.write("\r\n");
out.write("</table>\r\n");
long end = (long)System.currentTimeMillis();
StringBuffer s = new StringBuffer()
.append("��ʱ:")
.append(end-begin)
.append("����");
out.println(s.toString());
out.println("<br/><a href=\"index.jsp\">����</a>");
out.write("\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
out.write("\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -