Question

JavaWeb开发中遇到的问题！

这是我编的一个servlet，其中的参数是通过jsp页面传过来的，jsp页面代码没有任何错误，下面是servlet程序和运行是出现的错误报告！
代码如下：package com.guestbook.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.guestbook.tool.StringUtil;

public class AddMessage2 extends HttpServlet {

private static final long serialVersionUID = -7923713502943785310L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String sqlDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://219.247.139.62:1433;databaseName=guestbook";
String username = "admin";
String userpass = "123456";
String sql=null;
Connection conn = null;
int result=0;
request.setCharacterEncoding("utf-8");

String name=StringUtil.filterHtml(request.getParameter("name"));
String email=StringUtil.filterHtml(request.getParameter("email"));
String phone=StringUtil.filterHtml(request.getParameter("phone"));
String title=StringUtil.filterHtml(request.getParameter("title"));
String content=request.getParameter("content");
sql = "insert into notebook(name,email,phone,title,content) values ('"+name+"','"+email+"','"+phone+"','"+title+"','"+content+"')";
if(StringUtil.validateNull(name)||StringUtil.validateNull(title)){
request.getRequestDispatcher("adderror.jsp").forward(request,response);
}
else{

try {
Class.forName(sqlDriver).newInstance();
conn = DriverManager.getConnection(url, username, userpass);
Statement stmt = conn.createStatement();
result = stmt.executeUpdate(sql);
stmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
}
if(result==0){
request.getRequestDispatcher("addfail.jsp").forward(request,response);
}
else{
request.getRequestDispatcher("addsuccess.jsp").forward(request,response);
}

}
}
}

错误报告：
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]将截断字符串或二进制数据。（下面不能输入了）

请各位大哥帮帮忙！

Answer 1

config.getInitParameter(String
value)
这个方法是读取web.xml中的InitParam配置,如果打印的是空。
那么你可以去看看是不是initParma配置项没有配置,或者是写错了
name2
helloworld
最后说下,编程一定要细心,要不明明是些小问题,最后却要耽误很长时间。

Answer 2

String name=StringUtil.filterHtml(request.getParameter("name"));
String email=StringUtil.filterHtml(request.getParameter("email"));
String phone=StringUtil.filterHtml(request.getParameter("phone"));
String title=StringUtil.filterHtml(request.getParameter("title"));
String content=request.getParameter("content");
sql = "insert into notebook(name,email,phone,title,content) values ('"+name+"','"+email+"','"+phone+"','"+title+"','"+content+"')";

你数据库里的字段类型和这些相匹配吗?

Answer 3

应该是你库里面的类型和你实际输入的String不相符合的问题，你检查一下~

Answer 4

数据库执行时异常
SQLSERVER没用过，不知道

要分层啊，把操作数据库的语句另外写一个类

Answer 5

你在SQL语句里....加的字段...长度超过数据 库里的最大长度了...