?? oracle82.jsp
字號:
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,java.io.*"%>
<html><style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style>
<%
//清楚瀏覽器緩存--------------------------------------------------------------------------------------------
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragrma","no-cache");
response.setDateHeader("Expires",0);
java.lang.System.gc();//清除垃圾
%>
<%!
int line=100;
ResultSet rst=null;
Statement stmt=null;
Connection con =null;
String sql=null;
ResultSetMetaData rsmd;
%>
<body>
以下是從Oracle數據庫讀取的數據：
<hr>
<%
request.setCharacterEncoding("GBK");
String zd=request.getParameter("zd");
String tb=request.getParameter("tb");
String where=request.getParameter("where");
String tj=request.getParameter("tj");
String ll=request.getParameter("line");
sql=request.getParameter("sql");
if(ll!=null && !ll.equals("")){
line=Integer.parseInt(ll);
}
if(sql==null || sql.equals("")){
//sql=sql.trim();
if(tb!=null && !tb.equals("")){
if(zd!=null && !zd.equals("")) {
sql="select "+zd+" from "+tb;
if(where!=null && !where.equals("")){
sql=sql+" where "+where;
}
if(tj!=null && !tj.equals("")){
sql=sql+tj;
}
}else{
sql="select * from "+tb;
if(where!=null && !where.equals("")){
sql=sql+" where "+where;
}
if(tj!=null && !tj.equals("")){
sql=sql+tj;
}
}
}
}
out.print("你輸入的sql為：");
out.println(sql);
out.println("<br/>");
%>
<table border="1" cellpadding="0" cellspacing="0" style="width:auto">
<%
String cn;
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.0.1:1521:oracle"; ////其中oracle9為SID
String uid="oracle";
String pwd="oracle";
con = DriverManager.getConnection(url,uid,pwd);
stmt=con.createStatement();
try{
rst=stmt.executeQuery(sql);
rsmd=rst.getMetaData();
out.print("<tr align=\"center\" bgcolor=\"#336699\" height=\"25\" style=\"color:#FFFFFF\">");
for(int i=1;i<=rsmd.getColumnCount();i++){
out.print("<td > ");
out.print(rsmd.getColumnName(i));
out.println(" </td>");
}
out.print("</tr>");
int h=0;
while(rst.next()){
out.println("<tr align=\"center\">");
for(int j=1;j<=rsmd.getColumnCount();j++){
cn=rst.getString(j);
if(cn!=null && cn.length()>=11){
cn=cn.substring(0,10);
}
out.println("<td>"+cn+"</td>");
}
out.println("</tr>");
h++;
if(h==line){
break;
}
}
//關閉連接、釋放資源
rst.close();
}
catch(SQLException ex) {
out.println("數據庫查詢錯誤: " + ex.getMessage());
out.println("數據庫無此表！");
}
//關閉連接、釋放資源
con.close();
//}else{
//out.print("請輸入真確的sql,你輸入的sql為：");
//out.println(sql);
// }
%>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -