resultset= conn.executeQuery("select username,password from user_table where username='"
+ username+"'");
out.println("select username,password from user_table where username='"+ username+"'");
while (resultset.next()) {
}我发现在user_table表中如果personal个人资料字段为空的话,字段类型为text的话就出错,,其它字段为varchar类型,为空时就不出错,怪事了,请高手帮忙解释一下。。MSSQL数据库,不知道怎么回事,,,,----------------------------------------------------------------------
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.load_jsp._jspService(load_jsp.java:98)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)----------------------------------------------
+ username+"'");
out.println("select username,password from user_table where username='"+ username+"'");
while (resultset.next()) {
}我发现在user_table表中如果personal个人资料字段为空的话,字段类型为text的话就出错,,其它字段为varchar类型,为空时就不出错,怪事了,请高手帮忙解释一下。。MSSQL数据库,不知道怎么回事,,,,----------------------------------------------------------------------
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.load_jsp._jspService(load_jsp.java:98)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)----------------------------------------------
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<jsp:useBean id="conn" scope="page" class="db.ConnMsSQL" /><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<% ResultSet login_resultset=null;
login_resultset= conn.executeQuery("select username from test where id=1");
login_resultset.last();
out.println("<br>"+String.valueOf(login_resultset.getRow()));
while (login_resultset.next()) {
//if ((MD5(password)).equals((String) resultset.getObject(2))) {
// session.setAttribute("username", username);
// response.sendRedirect("left.jsp");
// else {
// response.sendRedirect("left.jsp");
}
// } else {
// response.sendRedirect("left.jsp");
// }
%>
</body>
</html>----------------------------------
test三个字段id 自增 整型
username char
text textmssql数据库,,,---------------------------------我刚才刚测出来,,发现只要text中的数据为""就出错,而text中的内容为null或有数据时就不出错,,怎么回事》
你说varchar没有这个问题,倒真的奇怪了