81,092
社区成员
发帖
与我相关
我的任务
分享[Microsoft][ODBC 驱动程序管理器] 无效的游标状态 在线等
在线等啊！！！！各位朋友帮帮忙~~~~~
源代码：
<%@ 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">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除学生信息 </title>
<style type="text/css">
<!--
.style1 {
color: #FF0000;
font-size: 16px;
}
-->
</style>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
String url = "jdbc:odbc:studentdata";
String user="";
String pwd="";
Connection con = DriverManager.getConnection(url,user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String name=request.getParameter("name");
String sql="select * from stu_info where name="+name+" ";
ResultSet rs = stmt.executeQuery(sql);
session.setAttribute("id",rs.getString("id"));
%>
<center class="style1">确定删除这个学生的记录吗?
<hr>
<p>学号: <%=rs.getString("id")%> </p>
<p>姓名: <%=rs.getString("name")%> </p>
<p>性别: <%=rs.getString("sex")%> </p>
<p>年龄: <%=rs.getString("age")%> </p>
<p>体重: <%=rs.getString("weight")%> </p>
<form name="form1" method="post" action="delete_2.jsp">
<input name="queding" type="submit" id="confirm" value="确定">
<input type="reset" name="back" id="back" value="返回">
</form>
<p> </p>
</center>
</body>
</html>
源代码：
<%@ 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">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除学生信息 </title>
<style type="text/css">
<!--
.style1 {
color: #FF0000;
font-size: 16px;
}
-->
</style>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
String url = "jdbc:odbc:studentdata";
String user="";
String pwd="";
Connection con = DriverManager.getConnection(url,user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String name=request.getParameter("name");
String sql="select * from stu_info where name="+name+" ";
ResultSet rs = stmt.executeQuery(sql);
session.setAttribute("id",rs.getString("id"));
%>
<center class="style1">确定删除这个学生的记录吗?
<hr>
<p>学号: <%=rs.getString("id")%> </p>
<p>姓名: <%=rs.getString("name")%> </p>
<p>性别: <%=rs.getString("sex")%> </p>
<p>年龄: <%=rs.getString("age")%> </p>
<p>体重: <%=rs.getString("weight")%> </p>
<form name="form1" method="post" action="delete_2.jsp">
<input name="queding" type="submit" id="confirm" value="确定">
<input type="reset" name="back" id="back" value="返回">
</form>
<p> </p>
</center>
</body>
</html>
...全文
请发表友善的回复…
发表回复
向大牛学习人工智能 2009-06-16
- 打赏
- 举报
字段顺序不一致引起的
jastby 2009-06-16
- 打赏
- 举报
<%@ 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">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除学生信息 </title>
<style type="text/css">
<!--
.style1 {
color: #FF0000;
font-size: 16px;
}
-->
</style>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
String url = "jdbc:odbc:studentdata";
String user="";
String pwd="";
Connection con = DriverManager.getConnection(url,user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String name=request.getParameter("name");
String sql="select * from stu_info where name="+name+" ";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
session.setAttribute("id",rs.getString("id"));
%>
<center class="style1">确定删除这个学生的记录吗?
<hr>
<p>学号: <%=rs.getString("id")%> </p>
<p>姓名: <%=rs.getString("name")%> </p>
<p>性别: <%=rs.getString("sex")%> </p>
<p>年龄: <%=rs.getString("age")%> </p>
<p>体重: <%=rs.getString("weight")%> </p>
<form name="form1" method="post" action="delete_2.jsp">
<input name="queding" type="submit" id="confirm" value="确定">
<input type="reset" name="back" id="back" value="返回">
</form>
<%}%>
<p> </p>
</center>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除学生信息 </title>
<style type="text/css">
<!--
.style1 {
color: #FF0000;
font-size: 16px;
}
-->
</style>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
String url = "jdbc:odbc:studentdata";
String user="";
String pwd="";
Connection con = DriverManager.getConnection(url,user, pwd); //建立数据库链接,studentdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String name=request.getParameter("name");
String sql="select * from stu_info where name="+name+" ";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
session.setAttribute("id",rs.getString("id"));
%>
<center class="style1">确定删除这个学生的记录吗?
<hr>
<p>学号: <%=rs.getString("id")%> </p>
<p>姓名: <%=rs.getString("name")%> </p>
<p>性别: <%=rs.getString("sex")%> </p>
<p>年龄: <%=rs.getString("age")%> </p>
<p>体重: <%=rs.getString("weight")%> </p>
<form name="form1" method="post" action="delete_2.jsp">
<input name="queding" type="submit" id="confirm" value="确定">
<input type="reset" name="back" id="back" value="返回">
</form>
<%}%>
<p> </p>
</center>
</body>
</html>
