大家来抢分啊~~~小弟写了一个jsp注册也面，但是执行的时候总是有异常~~~急死我了，一会就要交了大家帮忙啊~~在线等~~

Question

这是我里面的两个bean
package peigen;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;public class userregist {
  private userinfo userinfo1;
        private Connection con;        //获得数据库连接。
        public userregist()
        {
                 String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
            String SERVANDDB="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=E-bay";
            String USER="sa";
            String PWD="sasa";
            try
            {                    Class.forName(CLASSFORNAME);
                        con = DriverManager.getConnection(SERVANDDB,USER,PWD);
                }
                catch(Exception e)
                {
                        e.printStackTrace();
                }
        }
        //设置待注册的用户信息。
        public void setUserInfo(userinfo userinfo1)
        {
                this.userinfo1=userinfo1;
        }        //进行注册
        public void regist()throws Exception
        {
                String reg="insert into user_Info values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";                try
                {
                        PreparedStatement pstmt=con.prepareStatement(reg);
                        pstmt.setString(1,userinfo1.getuserid());
                        pstmt.setString(2,userinfo1.getusername());
                        pstmt.setString(3,userinfo1.getshengfen());
                        pstmt.setString(4,userinfo1.getaddress());
                        pstmt.setString(5,userinfo1.getzipcode());
                        pstmt.setString(7,userinfo1.getPhone());
                        pstmt.setString(6,userinfo1.getfax());
                        pstmt.setString(8,userinfo1.getemail());
                        pstmt.setString(9,userinfo1.getfaren());
                        pstmt.setString(10,userinfo1.getcontact());
                        pstmt.setInt(11,userinfo1.getregmoney());
                        pstmt.setString(12,userinfo1.getqyxz());
                        pstmt.setString(13,userinfo1.getqylx());
                        pstmt.setString(14,userinfo1.getintrodu());
                        pstmt.setString(15,userinfo1.getwebsite());
                        pstmt.setString(16,userinfo1.getproducts());
                        pstmt.setString(17,userinfo1.getppassword());
                        pstmt.setDate(18,new java.sql.Date(new java.util.Date().getTime()));                        pstmt.executeUpdate();
                }
                catch(Exception e)
                {
                        e.printStackTrace();
                        throw e;
                }
        }}

Answer 1

各位达人救命啊~~
package peigen;
import java.util.Date;public class userinfo {   private String userid;
   private String username;
   private String ppassword;
   private String confirmpassword;
   private String shengfen;   private String address;
   private String zipcode;
   private String fax;
   private String phone;
   private String email;   private String website;
   private String faren;
   private int regmoney;
   private String contact;
   private String qyxz;   private String qylx ;
   private Date regitime;
   private String introdu;
   private String products;   //getter方法
   public String getuserid()
   {
           return this.userid;
   }
      public String getconfirmpassword()
   {
           return this.confirmpassword;
   }
   public String getshengfen()
   {
           return this.shengfen;
   }
   public String getaddress()
   {
           return this.address;
   }   //setter方法
   public void setuserid(String c)
      {
             this.userid=c;
   }
   public void setusername(String c)
   {
             this.username=c;
   }   public void setshengfen(String c)
   {
             this.shengfen=c;
   }   public void setmail(String c)
   {
             this.email=c;
   }
  
}
省略部分代码~~

Answer 2

你的userinfo应该是个Bean吧，如果是Bean，应该是把setXxx或getXxx，也就是说你的set后面的第一个字母要大写，setmail应为setMail，不知说没说清楚

Answer 3

set后面的第一个字母要大写
不然总会出现空指令错误，因为找不到合乎要求的。

Answer 4

空指针阿~~
java.lang.NullPointerException

Answer 5

xiexie
谢谢   我试试

Answer 6

set后面的第一个字母要大写

Answer 7

还是有错啊
救命啊~~~
java.lang.NullPointerException at peigen.userregist.regist(userregist.java:42) at org.apache.jsp.userregi$jsp._jspService(userregi$jsp.java:131) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125) at java.lang.Thread.run(Thread.java:534)

Answer 8

应该检查你附值得过程。
 
java.lang.NullPointerException
 这种错误肯定是疏忽造成的

Answer 9

又出现新的问题了
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
An error occurred between lines: 14 and 19 in the jsp file: /userregi.jspGenerated servlet error:
F:\work\电子采购系统\project\E-bay\Tomcat\work\WebModule\userregi$jsp.java:130: Undefined variable: userinfo1
                  regist.setUserInfo(userinfo1);
                                     ^
1 error, 1 warning

Answer 10

倒，userinfo1变量没有定义啊。

Answer 11

userinfo没有初始化，更重要的是你在哪儿给userinfo的成员赋值了？
比如在使用userinfo.getusername()之前在哪个地方写了userinfo.setusername()语句？
你的数据库某个字段不允许为null.

Answer 12

赋值了啊
public class userregist {
  private userinfo userinfo1;
        private Connection con;        //获得数据库连接。
        public userregist()
        {
                 String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
            String SERVANDDB="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=E-bay";
            String USER="sa";
            String PWD="sasa";
            try
            {                    Class.forName(CLASSFORNAME);
                        con = DriverManager.getConnection(SERVANDDB,USER,PWD);
                }
                catch(Exception e)
                {
                        e.printStackTrace();
                }
        }
        //设置待注册的用户信息。
        public void setUserInfo(userinfo userinfo1)
        {
                this.userinfo1=userinfo1;
        }