【Java开源代码栏目提醒】:网学会员鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“advance_jsp.java”一文,供大家参考学习
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.io.*;
import java.sql.*;
public final class advance_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
String typeData(int i)
{
String ret="";
switch(i)
{
case(1):ret="CHAR";break;
case(2):ret="NUMERIC";break;
case(3):ret="DECIMAL";break;
case(4):ret="INTEGER";break;
case(5):ret="SMALLINT";break;
case(6):ret="FLOAT";break;
case(8):ret="DOUBLE";break;
case(12):ret="VARCHAR";break;
case(91):ret="DATE";break;
default:ret="other";
}
return ret;
}
String getCol(ResultSet rst,int type,int colNum)throws Exception
{
String ret="";
switch(type)
{
case(1):ret=rst.getString(colNum);break;
case(4):ret=String.valueOf(rst.getInt(colNum));break;
case(5):ret=String.valueOf(rst.getInt(colNum));break;
case(6):ret=String.valueOf(rst.getFloat(colNum));break;
case(8):ret=String.valueOf(rst.getDouble(colNum));break;
case(12):ret=rst.getString(colNum);break;
default:ret="not know";
}
return trans(ret);
}
String trans(String chi)
{
String result = null;
byte temp [];
try
{
temp=chi.getBytes("iso-8859-1");
result = new String(temp);
}
catch(UnsupportedEncodingException e)
{
System.out.println (e.toString());
}
return result;
}
private static java.util.Vector _jspx_dependants;
public java.util.List getDependants() {
return _jspx_dependants;
}
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;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=gb2312");
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;
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write('\r');
out.write('\n');
out.write(' ');
out.write('\r');
out.write('\n');
out.write(' ');
out.write("\r\n");
out.write(" <html>\r\n");
out.write("<body>\r\n");
out.write("<center>\r\n");
out.write("<strong>鑷姩鑾峰彇鏁版嵁搴撲俊鎭?</strong> \r\n");
out.write("<hr size=\"2\">\r\n");
out.write("<form action=\"advance.jsp\" method=get>\r\n");
out.write("<table><tr>\r\n");
out.write(" <td>鏁版嵁搴撳悕锛?\r\n");
out.write(" <input type=text name=database></td>\r\n");
out.write(" <td>琛ㄥ悕锛?\r\n");
out.write(" <input type=text name=table></td></tr>\r\n");
out.write("<tr> \r\n");
out.write(" <td colspan=2> <div align=\"right\">\r\n");
out.write(" <input type=submit value=鎻愪氦>\r\n");
out.write(" </div></td></tr>\r\n");
out.write("</table>\r\n");
out.write("</form>\r\n");
String database=(String)request.getParameter("database");
String table=(String)request.getParameter("table");
out.write("\r\n");
out.write("<table border=\"1\" cellpadding=\"1\" bordercolor=\"#000000\">\r\n");
try
{
String url="jdbc:my
sql://localhost:3306/?useUnicode=true&characterEncoding=utf8";
String user="root";
String psw="111";
Class.forName("com.
mysql.jdbc.Driver").newInstance();//瑁呰浇椹卞姩绋嬪簭
java.sql.Connection conn=DriverManager.getConnection(url,user,psw);//鍒涘缓杩炴帴
Statement stmt=conn.createStatement();
ResultSet rst=stmt.executeQuery("select * from "+database+"."+table);
ResultSetMetaData meta=rst.getMetaData() ;
int col=meta.getColumnCount();
out.println("琛?+table+"鍏辨湁锛?+col+"涓瓧娈碉紝杩欎簺瀛楁鏄細<br>");
out.println("<tr>");
for(int i=1;i<col+1;i++)
{
out.println("<td>瀛楁鍚嶏細");
out.println(meta.getColumnName(i));
out.println("绫诲瀷锛?nbsp;");
out.println(typeData(meta.getColumnType(i)));
out.println("</td>");
}
out.println("</tr>");
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("goods_id")+"</td>");
out.println("<td>"+rst.getString("goods_name")+"</td>");
out.println("<td>"+r