- 论坛徽章:
- 0
|
我的在插入数据的时候出现错误!我是初学jsp的,还有好多都不懂还希望各位大哥大姐帮帮忙!
代码:
⒈表单部分文件:
<form method="post" action="" name="form">
<p align="center"><font size="2">产品类ID: </font>
<input name="pro_classid" type="text" id="pro_classid" size="20" ></p>
<p align="center"><font size="2">产品类名:</font>
<input name="pro_classname" type="text" id="pro_classid" size="20"></p>
<p align="center"><font size="2">产品名称:</font>
<input name="productname" type="text" id="productname" size="20"></p>
</form>
<form id="form1" name="form2" method="post" action="prosuccess.jsp">
<label></label>
<center><input type="submit" name="Submit" value="提交"
onclick="javascript:return(checkform());"/></center></form>
⒉插入数据库代码:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%
String pro_classid=request.getParameter("pro_classid");
String pro_classname=request.getParameter("pro_classname");
String productname=request.getParameter("productname");
String sql = "INSERT INTO pro_class1 (pro_classid,pro_classname,productname) Values ('"+pro_classid+"','"+pro_classname+"','"+productname+"')";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sys_man";
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
if (rs.next())
{
response.sendRedirect("insertsuccess.jsp");
}
else
{
response.sendRedirect("inserterror.jsp");
// out.println("用户名或密码错误请重新登陆!");
}
%>
还望各位能帮忙解决啊! |
|