UC知道jsp 插入记录的问题
来源：百度知道 编辑：UC知道 时间：2024/05/28 09:34:46
%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
String xingming=request.getParameter("xingming");
String xingbie=request.getParameter("xingbie");
String zhiwei=request.getParameter("zhiwei");
String tongxun=request.getParameter("tongxun");
String haoma=request.getParameter("haoma");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jzq";
String user="sa";
String password="sa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="insert into uuu(xingming,xingbie,zhiwei,lianxi,haoma)values(&#
<%@ page import="java.sql.*"%>
<html>
<body>
<%
String xingming=request.getParameter("xingming");
String xingbie=request.getParameter("xingbie");
String zhiwei=request.getParameter("zhiwei");
String tongxun=request.getParameter("tongxun");
String haoma=request.getParameter("haoma");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jzq";
String user="sa";
String password="sa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="insert into uuu(xingming,xingbie,zhiwei,lianxi,haoma)values(&#
没有结果集。
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="insert into uuu(xingming,xingbie,zhiwei,lianxi,haoma)values(\'"+xingming+"\',\'"+xingbie+"\',\'"+zhiwei+"\',\'"+tongxun+"\',\'"+haoma+"\')";
ResultSet rs=stmt.executeQuery(sql);
这一块 错了
问题在stmt.executeQuery只能作为查看
不能修改
当做修改、删除、插入的时候都得换成stmt.executeUpdate
ResultSet rs=stmt.executeQuery(sql);
没有返回结果集，因为你上句的参数错了！
举个例子：
ResultSet rs=stmt.executeQuery("select * from uuu;");
就OK了。