?? 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>條件?。?lt;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 + -