jsp无法把数据插入到数据库
a.jsp代码：<%@pagecontentType="text/html;charset=gb2312"import="java.util.*,com.Bean.*"%...
a.jsp代码：
<%@page contentType="text/html;charset=gb2312" import="java.util.*,com.Bean.*"%>
<link rel="stylesheet" href="css/code43.css" type="text/css">
<HTML><HEAD>
<title>插入数据</title>
<script language="javascript">
function buy()
{
document.form1.submit();
}
function check()
{
if(document.form.namea.value=="")
{
alert("注册名不能为空");
document.form.namea.focus();
return false;
}
else
{
form.action="crecord";
form.target="_parent";
form.submit();
}
}
</script>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
</HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" >
<form name="form" method="post">
<div align="center">
<table width="551" height="482" border="1">
<tr>
<td height="37" align="right">*注册名:</td>
<td width="363"><input type="text" name="namea" />
(3到50个字符) </td>
</tr>
<tr>
<td height="43" align="right">真实姓名:</td>
<td>
<input type="text" name="nameb" />
(2到50个字符) </td>
</tr>
<tr>
<td height="82" colspan="2" align="center">
<input type="button" name="Submit" value="注册" onClick="check()">
<input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"> </td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table>
</BODY></HTML>
crecord.java代码:
package com.servlet;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import com.Bean.*;
public class crecord extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException
{
response.setContentType("text/html;charset=gb2312");
request.setCharacterEncoding("GBK");
PrintWriter out=response.getWriter();
String namea,nameb;
namea=request.getParameter("namea");
nameb=request.getParameter("nameb");
/*
out.println(namea);
out.println(nameb);
*/
dbconn dbcon=new dbconn();
String insertStr="insert into aaa(namea,nameb) values";
insertStr=insertStr+"('"+namea+"',";
insertStr=insertStr+"'"+nameb+"',";
//out.println(insertStr);
boolean flag=dbcon.executeUpdate(insertStr);
if(flag==true)
{
dbcon.destory();
out.print("<script language=\"javascript\">window.location.replace(\"usercenter.jsp\"); </script>");
}
else
{
dbcon.destory();
out.print("<script language=\"javascript\">window.history.go(-1);</script>");
}
}
}
数据可以连接，也可以查询表中的数据，但就不能插入数据 展开
<%@page contentType="text/html;charset=gb2312" import="java.util.*,com.Bean.*"%>
<link rel="stylesheet" href="css/code43.css" type="text/css">
<HTML><HEAD>
<title>插入数据</title>
<script language="javascript">
function buy()
{
document.form1.submit();
}
function check()
{
if(document.form.namea.value=="")
{
alert("注册名不能为空");
document.form.namea.focus();
return false;
}
else
{
form.action="crecord";
form.target="_parent";
form.submit();
}
}
</script>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
</HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" >
<form name="form" method="post">
<div align="center">
<table width="551" height="482" border="1">
<tr>
<td height="37" align="right">*注册名:</td>
<td width="363"><input type="text" name="namea" />
(3到50个字符) </td>
</tr>
<tr>
<td height="43" align="right">真实姓名:</td>
<td>
<input type="text" name="nameb" />
(2到50个字符) </td>
</tr>
<tr>
<td height="82" colspan="2" align="center">
<input type="button" name="Submit" value="注册" onClick="check()">
<input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"> </td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table>
</BODY></HTML>
crecord.java代码:
package com.servlet;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import com.Bean.*;
public class crecord extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException
{
response.setContentType("text/html;charset=gb2312");
request.setCharacterEncoding("GBK");
PrintWriter out=response.getWriter();
String namea,nameb;
namea=request.getParameter("namea");
nameb=request.getParameter("nameb");
/*
out.println(namea);
out.println(nameb);
*/
dbconn dbcon=new dbconn();
String insertStr="insert into aaa(namea,nameb) values";
insertStr=insertStr+"('"+namea+"',";
insertStr=insertStr+"'"+nameb+"',";
//out.println(insertStr);
boolean flag=dbcon.executeUpdate(insertStr);
if(flag==true)
{
dbcon.destory();
out.print("<script language=\"javascript\">window.location.replace(\"usercenter.jsp\"); </script>");
}
else
{
dbcon.destory();
out.print("<script language=\"javascript\">window.history.go(-1);</script>");
}
}
}
数据可以连接，也可以查询表中的数据，但就不能插入数据 展开
1个回答
展开全部
太长了。。。
insert into aaa(namea,nameb) values
就这句吧
看你下面拼语句，好像少了个）
又或者注意下输入法输入,号的问题，你不是自己把STRING的值打印了么，你放查询分析器执行下不就知道问题了~
insert into aaa(namea,nameb) values
就这句吧
看你下面拼语句，好像少了个）
又或者注意下输入法输入,号的问题，你不是自己把STRING的值打印了么，你放查询分析器执行下不就知道问题了~
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
