📄 action.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<HTML>
<HEAD>
<TITLE>查询数据</TITLE>
</HEAD>
<BODY>
<% String action,sql;
action = request.getParameter("actionAction");
sql=action;
%>
<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>");
//创建结果集
try
{
stmt.executeUpdate(sql);
} catch(Exception ex){out.println(ex.toString()+"<br>");}
out.println("<Font size=4 color=red><b>执行语句创建结果集....<br></b></Font><Font size=4 color=blue><b>stmt.executeUpdate(\""+sql+"\")</br></b></Font><Font size=4 color=red><b>执行完成!<br></b></Font>");
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 + -