已经存进去了?那么不是数据库限制,应该不会了。
把取的过程贴出来吧

解决方案 »

  1.   

    我是用String username1=request.getParameter("username"); username是文本框的name属性,我username限制为4-20位字母、数字或下划线!,入库语句
        String strSql="insert into user (userlevel,username,sex,password,question,answer,email,face,birthyear,birthmonth,birthday,oicq,icq,msn,coolnr,setuserinfo,setusertrue,realname,telphone,country,address,province,city,shengxiao,blood,occupation,education,registerdate,previewlogin) values('"+lel+"','"+username1+"','"+sex1+"','"+password1+"','"+question1+"','"+answer1+"','"+email1+"','"+face1+"','"+birthyear1+"','"+birthmonth1+"','"+birthday1+"','"+oicq1+"','"+icq1+"','"+msn1+"','"+coolnr1+"','"+setuserinfo1+"','"+setusertrue1+"','"+realname1+"','"+telphone1+"','"+country1+"','"+address1+"','"+province1+"','"+city1+"','"+shengxiao1+"','"+blood1+"','"+occupation1+"','"+education1+"','"+time.toLocaleString()+"','"+time.toLocaleString()+"')";
    session.putValue("uid",username1);
    session.putValue("plogin",time.toLocaleString());
    rs=stmt.executeQuery(strSql);
    rs.close();
    conn.close();