📄 sql_manager.jsp
字号:
<base target="result">
<%@ page language="java" import="java.util.*" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<body bgcolor="#C0C0C0">
<jsp:include page=cksession.jsp />
<%
if(request.getParameter("sql")!=null){
String strUser=(String)session.getValue("user");
String strSql=(String)request.getParameter("sql");
String strComd=(String)request.getParameter("d1");
String strDo="",strAll="";
if(strSql.length()>0&&strComd.length()>0){
if(strUser.equals("admin")){
if(strComd.equals("SELECT")){
strDo="SELECT "+strSql;
%>
<table border="1" cellpadding="1" cellspacing="0" width="100%">
<%
ResultSet sqlRst=DB.executeQuery(strDo);
ResultSetMetaData rsmd = sqlRst.getMetaData();
String strColumnName="";
int intColumnNumb = rsmd.getColumnCount();
String strHead="<tr><td>";
for (int i = 1; i <= intColumnNumb; i++) {
strColumnName= rsmd.getColumnName(i);
if(i==intColumnNumb){
strHead=strHead+ strColumnName+"</td></tr>";
}else{
strHead=strHead+ strColumnName+"</td><td>";
}
}
out.print(strHead+"\n");
String ss="";
while(sqlRst.next()){
strAll="<tr><td>";
for(int i=1;i<=intColumnNumb;i++){
ss=sqlRst.getString(i);
if(i==intColumnNumb){
strAll=strAll+ss+"</td></tr>";
}else{
strAll=strAll+ss+"</td><td>";
}
}
out.print(strAll+"\n");
}
%>
</table>
<% sqlRst.close();
}else{
strDo=strComd+" "+strSql;
DB.executeUpdate(strDo);
out.print(strComd+" SUCCESSFULLY EXCUTED!!");
}
}else{
out.print("YOU HAVE NO RIGHT!!");
}
}else{
out.print("Please Input Command!!");
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -