📄 del_1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"
errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
…
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=my_db";
//my_db为你的数据库的名称
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
//建立Statement对象
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
%>
<center> <h2 class="style3">删除学生信息</h2>
<br>
<form name="form1" method="post" action="del_2.jsp">
<p><span class="style4">请选择要删除的学生的学号:</span>
<select name="id">
<% ResultSet rs = stmt.executeQuery("SELECT * FROM stu_info");
/*显示所有学生的学号*/
while(rs.next())
{
String id=rs.getString("id");
%>
<option value="<%=id%>"><%=id%></option>
<%}%>
}
</select>
</p>
<p>
<input type="submit" name="queding" value="确定">
<input name="back" type="button" id="back" value="返回"
onClick="javascript:history.go(-1)">
</p>
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -