?? action.jsp
字號:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<HTML>
<HEAD>
<TITLE>查詢數(shù)據(jù)</TITLE>
</HEAD>
<BODY>
<% String action,sql;
action = request.getParameter("actionAction");
sql=action;
%>
<center>
<%
try{
//連接數(shù)據(jù)庫
//創(chuàng)建驅(qū)動
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>驅(qū)動已創(chuàng)建....</br></b></Font><Font size=4 color=blue><b>Class.forName(\"com.microsoft.jdbc.sqlserver.SQLServerDriver\").newInstance();</br></b></Font>");
//創(chuàng)建連接
Connection conn=DriverManager.getConnection(url,UID,pwd);
out.println("<Font size=4 color=red><b>數(shù)據(jù)庫已連接....</br></b></Font><Font size=4 color=blue><b>Connection conn=DriverManager.getConnection(\""+url+"\","+UID+","+pwd+");<br></b></Font>");
//創(chuàng)建語句執(zhí)行
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
out.println("<Font size=4 color=red><b>語句執(zhí)行已創(chuàng)建....</br></b></Font><Font size=4 color=blue><b>Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);</br></b></Font>");
//創(chuàng)建結(jié)果集
try
{
stmt.executeUpdate(sql);
} catch(Exception ex){out.println(ex.toString()+"<br>");}
out.println("<Font size=4 color=red><b>執(zhí)行語句創(chuàng)建結(jié)果集....<br></b></Font><Font size=4 color=blue><b>stmt.executeUpdate(\""+sql+"\")</br></b></Font><Font size=4 color=red><b>執(zhí)行完成!<br></b></Font>");
stmt.close();
conn.close();
out.println("<Font size=4 color=red><b>各個對象已全部關(guān)閉。<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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -