81,094
社区成员
发帖
与我相关
我的任务
分享insert into问题！在线等！
add.jsp
<html>
<head>
<title>
add product
</title>
</head>
<body>
<h1>
add product
</h1>
<form action="insertproduct.jsp" method="post">
product name
<input name="prod_name" type="text" size="10">
<br>
<br>
price
<input name="prod_price" type="text" size="10">
<br>
<br>
<input type="submit" value="submit">
</form>
<br>
<br>
</body>
</html>
insertproduct.jsp
<%@ page contentType="text/html;charset=gb2312" language="java"
import="java.sql.*"%>
<html>
<head>
<title>
insert product!
</title>
</head>
<body>
<h1>
insert product!
</h1>
<%
java.sql.Connection cn;
if ((request.getParameter("prod_name")!=null) && (request.getParameter("prod_price")!=null))
{out.println(request.getParameter("prod_name"));
out.println(request.getParameter("prod_price"));
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
cn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=master","sa","sa");
java.sql.Statement stm=cn.createStatement();
String msql="insert into accounts(a_id,a_name) values('"+request.getParameter("prod_name")+"','"+request.getParameter("prod_price")+"')";
java.sql.ResultSet rs=stm.executeQuery(msql);
out.println("ok!");
stm.close();
cn.close();
}
else
{out.println("back");
}
%>
</body>
</html>
要求在add.htm中的text添加值在insertproduct.jsp中显示出来！
出现了以下错误！请指教。。。
org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
<html>
<head>
<title>
add product
</title>
</head>
<body>
<h1>
add product
</h1>
<form action="insertproduct.jsp" method="post">
product name
<input name="prod_name" type="text" size="10">
<br>
<br>
price
<input name="prod_price" type="text" size="10">
<br>
<br>
<input type="submit" value="submit">
</form>
<br>
<br>
</body>
</html>
insertproduct.jsp
<%@ page contentType="text/html;charset=gb2312" language="java"
import="java.sql.*"%>
<html>
<head>
<title>
insert product!
</title>
</head>
<body>
<h1>
insert product!
</h1>
<%
java.sql.Connection cn;
if ((request.getParameter("prod_name")!=null) && (request.getParameter("prod_price")!=null))
{out.println(request.getParameter("prod_name"));
out.println(request.getParameter("prod_price"));
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
cn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=master","sa","sa");
java.sql.Statement stm=cn.createStatement();
String msql="insert into accounts(a_id,a_name) values('"+request.getParameter("prod_name")+"','"+request.getParameter("prod_price")+"')";
java.sql.ResultSet rs=stm.executeQuery(msql);
out.println("ok!");
stm.close();
cn.close();
}
else
{out.println("back");
}
%>
</body>
</html>
要求在add.htm中的text添加值在insertproduct.jsp中显示出来！
出现了以下错误！请指教。。。
org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
...全文
请发表友善的回复…
发表回复
