📄 id.jsp
字号:
<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>
<%
//变量声明
java.sql.Connection sqlConn; //数据库连接对象
java.sql.Statement sqlStmt; //SQL语句对象
java.lang.String NameField;//来自客户端的数据：姓名
long ValueField;//来自客户端数据：年龄
java.sql.ResultSet sqlRst; //结果集对象
//登记jdbc驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//连接数据库
sqlConn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=nuer;SelectMethod=cursor","nuer","nuer");
//创建语句对象
sqlStmt = sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
%>
<%
String strName = "",lngAge = "";
if(request.getParameter("AddValue")!=null)
{
strName = (String)request.getParameter("NameField");
lngAge = (String)request.getParameter("ValueField");
//执行sql语句
sqlStmt.executeUpdate("insert into test(name,age)values('"+strName+"','"+lngAge+"')");
}
else if(request.getParameter("DeleteValue")!=null)
{
strName = (String)request.getParameter("NameField");
lngAge = (String)request.getParameter("ValueField");
//执行sql语句
sqlStmt.executeUpdate("delete test where name='"+strName+"' and age='"+lngAge+"'");
}
%>
<%
sqlRst = sqlStmt.executeQuery("select name,age from test");
%>
<html>
<head>
<title>添加，删除实例</title>
</head>
<body>
<table width="379" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<th width="186" height="23">姓名</th>
<th width="187">年龄</th>
</tr>
<%while(sqlRst.next()){%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getString(2)%></td>
</tr>
<%
}
//关闭结果集对象
sqlRst.close();
//关闭SQL语句对象
sqlStmt.close();
//关闭数据库
sqlConn.close();
%>
</table>
<%------------------------------------------------------------------------------------------%>
<p>
<form method="post" name="Sessionservlet" action="id.jsp">
<center>
<table border=1 cellspacing=2 cellpadding=5 width=400>
<th>Name to add/delete</th>
<th>Value</th>
<tr>
<td><input type="text" name="NameField"></td>
<td><input type="text" name="ValueField"></td>
</tr>
<tr>
<td colspan=5 align=center><input type="submit" value="Add" name="AddValue"></td>
</tr>
<tr>
<td colspan=5 align=center><input type="submit" value="Delete" name="DeleteValue"></td>
</tr>
</table>
</center>
</form>
<p>
<font size=-1>Copyright.................
</font>
</font>
<%------------------------------------------------------------------------------------------%>
</body>
<html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -