我表单提交插入数据库只能插入数字,到底怎么回事?急huodongshuru.html:
<html>
<head>
<title> 活动计划管理</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<script>
function check()
{ if(document.ffff.huodong.value=="")
{ alert("活动不能为空,请输入!!");
document.ffff.huodong.focus();
}
else if(document.ffff.timu.value=="")
{ alert("题目不能为空,请输入!!");
document.ffff.timu.focus();
}
else if(document.ffff.didian.value=="")
{ alert("地点不能为空,请输入!!");
document.ffff.didian.focus();
}
else if(document.ffff.riqi.value=="")
{ alert("日期不能为空,请输入!!");
document.ffff.riqi.focus();
}
else if(document.ffff.jianjie.value=="")
{ alert("简介不能为空,请输入!!");
document.ffff.jianjie.focus();
}
else
{document.ffff.submit();
}
}
</script>
</head>
<body leftmargin="0" topmargin="0">
<table width="760" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#eeeeee">
<tr>
<td>
<h3 align=center>活动计划输入</h3>
<form method="post" action="addhuodong.jsp" name="ffff" target=_top>
<p align="center">
活动:<input type="text" name="huodong">
题目:<input type="text" name="timu">
</p>
<p align="center">
地点:<input type="text" name="didian">
日期:<input type="text" name="riqi">
</p>
<p align="center">简介:</p>
<p align="center">
<textarea name="jianjie" cols="50" rows="10">
</textarea></p>
<p align="center">
<input type="reset" name="Reset" value="重新填写">
<input type="button" name="Submit1" value=" 提交 " onclick="check()">
</p>
</form>
</td>
</tr>
</table>
</body>
</html>addhuodong.jsp:
<%@page import="huodongrili.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="dbQuery" class="huodongrili.DBQuery" scope="page"/>
<%
String huodong,timu,didian,riqi,jianjie;
huodong=(String)request.getParameter("huodong");
timu=(String)request.getParameter("timu");
jianjie=(String)request.getParameter("jianjie");
didian=(String)request.getParameter("didian");
riqi=(String)request.getParameter("riqi");
String huodong1=new String(huodong.getBytes("ISO-8859-1"));
String timu1=new String(huodong.getBytes("ISO-8859-1"));
String jianjie1=new String(huodong.getBytes("ISO-8859-1"));
String didian1=new String(huodong.getBytes("ISO-8859-1"));
String riqi1=new String(huodong.getBytes("ISO-8859-1"));
out.print(huodong);
out.print(timu);
out.print(jianjie);
out.print(didian);
out.print(riqi);
try{
dbQuery.insertRecord(huodong1,timu1,jianjie1,didian1,riqi1);
}
catch(Exception e)
{ e.getMessage();
}out.println("<script>javascript:parent.frames.item(0).reload;</script>");
response.sendRedirect("huodongguanli.html");
%>
huodongrili.DBQuery:
package huodongrili;import java.sql.*;
import java.io.*;public class DBQuery {
private ResultSet rs=null;
private Connection conn=null;
private DBConn dbConn=null;
private int concurType=ResultSet.CONCUR_READ_ONLY;
private int scrollType=ResultSet.TYPE_FORWARD_ONLY;public DBQuery(){
}public DBQuery(DBConn dbConn){
this.dbConn=dbConn;
}
private void createConnection(){
if(conn==null){
if(dbConn==null){
dbConn=new DBConn();
dbConn.connect();
}
conn=dbConn.getConnection();
}
}
public ResultSet executeQuery(String strSql) throws SQLException{
if(strSql==null){
return null;
}
if(conn==null){
createConnection();
}
if(conn==null)
{rs=null;}
else{
Statement s=conn.createStatement(scrollType,concurType);
rs=s.executeQuery(strSql);
}
return rs;
}
public void executeUpdate(String strSql) throws SQLException{
if(conn==null){
createConnection();
}
if(conn==null)
{ }
else{
Statement s=conn.createStatement(scrollType,concurType);
s.executeUpdate(strSql);
}
}
public void insertRecord(String huodong,String timu,String jianjie,String didian,String riqi){
String sql;
byte[] temp={1};
sql="INSERT INTO huodong";
sql+="(huodong,timu,jianjie,didian,riqi)";
sql+="VALUES('";
sql+=huodong;
sql+="','";
sql+=timu;
sql+="','";
sql+=jianjie;
sql+="','";
sql+=didian;
sql+="','";
sql+=riqi;
sql+="')";
try{
temp=sql.getBytes("iso-8859-1");
}catch(UnsupportedEncodingException e){
}
String sqlCStr=new String(temp);
try{
if(conn==null){
createConnection();
}
if(conn==null)
return;
else{
Statement s=conn.createStatement(scrollType,concurType);
s.executeUpdate(sqlCStr);
}
}catch(SQLException e){
}
}}
<html>
<head>
<title> 活动计划管理</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<script>
function check()
{ if(document.ffff.huodong.value=="")
{ alert("活动不能为空,请输入!!");
document.ffff.huodong.focus();
}
else if(document.ffff.timu.value=="")
{ alert("题目不能为空,请输入!!");
document.ffff.timu.focus();
}
else if(document.ffff.didian.value=="")
{ alert("地点不能为空,请输入!!");
document.ffff.didian.focus();
}
else if(document.ffff.riqi.value=="")
{ alert("日期不能为空,请输入!!");
document.ffff.riqi.focus();
}
else if(document.ffff.jianjie.value=="")
{ alert("简介不能为空,请输入!!");
document.ffff.jianjie.focus();
}
else
{document.ffff.submit();
}
}
</script>
</head>
<body leftmargin="0" topmargin="0">
<table width="760" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#eeeeee">
<tr>
<td>
<h3 align=center>活动计划输入</h3>
<form method="post" action="addhuodong.jsp" name="ffff" target=_top>
<p align="center">
活动:<input type="text" name="huodong">
题目:<input type="text" name="timu">
</p>
<p align="center">
地点:<input type="text" name="didian">
日期:<input type="text" name="riqi">
</p>
<p align="center">简介:</p>
<p align="center">
<textarea name="jianjie" cols="50" rows="10">
</textarea></p>
<p align="center">
<input type="reset" name="Reset" value="重新填写">
<input type="button" name="Submit1" value=" 提交 " onclick="check()">
</p>
</form>
</td>
</tr>
</table>
</body>
</html>addhuodong.jsp:
<%@page import="huodongrili.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="dbQuery" class="huodongrili.DBQuery" scope="page"/>
<%
String huodong,timu,didian,riqi,jianjie;
huodong=(String)request.getParameter("huodong");
timu=(String)request.getParameter("timu");
jianjie=(String)request.getParameter("jianjie");
didian=(String)request.getParameter("didian");
riqi=(String)request.getParameter("riqi");
String huodong1=new String(huodong.getBytes("ISO-8859-1"));
String timu1=new String(huodong.getBytes("ISO-8859-1"));
String jianjie1=new String(huodong.getBytes("ISO-8859-1"));
String didian1=new String(huodong.getBytes("ISO-8859-1"));
String riqi1=new String(huodong.getBytes("ISO-8859-1"));
out.print(huodong);
out.print(timu);
out.print(jianjie);
out.print(didian);
out.print(riqi);
try{
dbQuery.insertRecord(huodong1,timu1,jianjie1,didian1,riqi1);
}
catch(Exception e)
{ e.getMessage();
}out.println("<script>javascript:parent.frames.item(0).reload;</script>");
response.sendRedirect("huodongguanli.html");
%>
huodongrili.DBQuery:
package huodongrili;import java.sql.*;
import java.io.*;public class DBQuery {
private ResultSet rs=null;
private Connection conn=null;
private DBConn dbConn=null;
private int concurType=ResultSet.CONCUR_READ_ONLY;
private int scrollType=ResultSet.TYPE_FORWARD_ONLY;public DBQuery(){
}public DBQuery(DBConn dbConn){
this.dbConn=dbConn;
}
private void createConnection(){
if(conn==null){
if(dbConn==null){
dbConn=new DBConn();
dbConn.connect();
}
conn=dbConn.getConnection();
}
}
public ResultSet executeQuery(String strSql) throws SQLException{
if(strSql==null){
return null;
}
if(conn==null){
createConnection();
}
if(conn==null)
{rs=null;}
else{
Statement s=conn.createStatement(scrollType,concurType);
rs=s.executeQuery(strSql);
}
return rs;
}
public void executeUpdate(String strSql) throws SQLException{
if(conn==null){
createConnection();
}
if(conn==null)
{ }
else{
Statement s=conn.createStatement(scrollType,concurType);
s.executeUpdate(strSql);
}
}
public void insertRecord(String huodong,String timu,String jianjie,String didian,String riqi){
String sql;
byte[] temp={1};
sql="INSERT INTO huodong";
sql+="(huodong,timu,jianjie,didian,riqi)";
sql+="VALUES('";
sql+=huodong;
sql+="','";
sql+=timu;
sql+="','";
sql+=jianjie;
sql+="','";
sql+=didian;
sql+="','";
sql+=riqi;
sql+="')";
try{
temp=sql.getBytes("iso-8859-1");
}catch(UnsupportedEncodingException e){
}
String sqlCStr=new String(temp);
try{
if(conn==null){
createConnection();
}
if(conn==null)
return;
else{
Statement s=conn.createStatement(scrollType,concurType);
s.executeUpdate(sqlCStr);
}
}catch(SQLException e){
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货