📄 select.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<HTML>
<HEAD>
<TITLE>查询数据</TITLE>
</HEAD>
<BODY>
<% String action,columns,tables,conditions,sql;
action = request.getParameter("actionSelect");
columns = request.getParameter("columnsSelect");
tables = request.getParameter("tablesSelect");
conditions = request.getParameter("conditionsSelect");
sql=action+" "+columns+" from "+tables+" "+conditions;
%>
<center>
<%
try{
//连接数据库
//创建驱动
String url="jdbc:microsoft:sqlserver://Lover:1433;DatabaseName=Northwind";
String UID="sa";
String pwd="fushichang";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
out.println("<Font size=4 color=red><b>驱动已创建....</br></b></Font><Font size=4 color=blue><b>Class.forName(\"com.microsoft.jdbc.sqlserver.SQLServerDriver\").newInstance();</br></b></Font>");
//创建连接
Connection conn=DriverManager.getConnection(url,UID,pwd);
out.println("<Font size=4 color=red><b>数据库已连接....</br></b></Font><Font size=4 color=blue><b>Connection conn=DriverManager.getConnection(\""+url+"\","+UID+","+pwd+");<br></b></Font>");
//创建语句执行
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
out.println("<Font size=4 color=red><b>语句执行已创建....</br></b></Font><Font size=4 color=blue><b>Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);</br></b></Font>");
//创建结果集
ResultSet rs=stmt.executeQuery(sql);
out.println("<Font size=4 color=red><b>执行语句创建结果集....<br></b></Font><Font size=4 color=blue><b>ResultSet rs=stmt.executeQuery(\""+sql+"\")</br></b></Font><Font size=4 color=red><b>执行完成!输出查询:<br></b></Font>");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
boolean b = rsmd.isSearchable(1);
int w,i;
w = 250;
out.println("<CENTER>");
out.println("<H2>"+"数据查询NTLM试验"+"</H2>");
out.println("</CENTER>");
out.println("<Table Border width="+numberOfColumns*w+">");
out.println("<TR>");
for(i=1;i<=numberOfColumns;i++)
{
out.println("<TH width="+w+">"+rsmd.getColumnName(i));
}
out.println("</TR>");
for(rs.first();!rs.isAfterLast();rs.next())
{
out.println("<tr>");
for(i=1;i<=numberOfColumns;i++)
{
out.println("<td width="+w+">"+rs.getString(i)+" </td> ");
}
out.println("</tr>");
}
out.println("</Table>");
rs.close();
stmt.close();
conn.close();
out.println("<Font size=4 color=red><b>各个对象已全部关闭。<br></b></Font>");
}catch(Exception ex){out.println(ex.toString());}
%>
<FORM method="POST" action="./select.jsp" name="selectForm">
<P><Font size=5><b>请输入SQL查询语句</b></Font>
<P>语句 ：<INPUT type="text" name="actionSelect" value=Select size="35">
<P>查询列：<INPUT type="text" name="columnsSelect" value=* size="35">
<P>查询表：<INPUT type="text" name="tablesSelect" value=Customers size="35">
<P>条件 ：<INPUT type="text" name="conditionsSelect" value="Where CompanyName!='NULL'" size="35">
<P><INPUT type="submit" value="提交" name="btnSubmit">
<INPUT type="reset" value="重写" name="btnClear">
</FORM>
<FORM method="POST" action="./action.jsp" name="ActionForm">
<P><Font size=5><b>请输入SQL更新语句</b></Font>
<P > <textArea name="actionAction" cols="50" rows="8">Insert Into Customers(CustomerID,CompanyName) Values('FU','FUSHICHANG')</textArea>
<P><INPUT type="submit" value="提交" name="btnSubmitAction">
<INPUT type="reset" value="重写" name="btnClearAction">
</FORM>
</center>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -