[求助]??数据库添加不进去
我在做留言板碰到问题:
opendb.class:(部分代码)
public void insert()//添加记录
{
String strSql = null;
try{
conn = DriverManager.getConnection(strDBUrl);
stmt = conn.createStatement();
strSql = "INSERT INTO book(username,tx,email,sex,url,qq,content,ip) VALUES ('"
+this.UserName+"','"+this.Tx+"','"+this.Email+"','"+this.Sex+"','"+this.Url+"','"
+this.QQ+"','"+this.Content+"','"+this.IP+"')";
stmt.executeUpdate(strSql);
System.out.println("ok");
}
catch(Exception e)
{
System.out.println(e.getMessage()+e.getStackTrace());
}
finally //保存一定要关闭conn
{
try{
if(stmt != null)
stmt.close();
if(conn != null)
conn.close();
}catch(Exception e)
{}
}
}
还有set,get方法(得到,取数据方法)
///////////////////////////////////////////
有JSP文件中:
<%! String UserName,Sex,Email,Url,QQ,Tx,Content,IP; %>
<%
request.setCharacterEncoding("gb2312");
UserName =request.getParameter("username");
Sex = request.getParameter("sex");
Email = request.getParameter("email");
Url = request.getParameter("url"); //网址
QQ = request.getParameter("qq"); //QQ号
Tx = request.getParameter("tx");//图片路径
Content = request.getParameter("content"); //内容
IP = request.getRemoteAddr(); //IP地址
db.setUsername("99999");
// db.setUsername(UserName);
db.setTx(Tx);
db.setEmail(Email);
db.setSex(Sex);
db.setUrl(Url);
db.setQQ(QQ);
db.setContent(Content);
db.setIP(IP);
db.insert();//添加记录
out.println(UserName);
out.println(Tx);
out.println(QQ);
out.println(Content);
%>
为什么在opendb.java中调试可以添加记录,在JSP中则不行,为什么???
谢谢