📄 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 + -