有大佬能来看看这个报错怎么解决吗

weixin_42180046 2018-05-10 02:58:29

功能是这样，从数据库读取生产日期并和现在时间做运算，算出从生产到现在已经过了多久，然后取出保质期的数据与其作比较，将快过期的商品数据显示到JTable里，代码如下，该怎么修改呢

报错：
Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Vector
at javax.swing.table.DefaultTableModel.justifyRows(Unknown Source)
at javax.swing.table.DefaultTableModel.setDataVector(Unknown Source)
at csg.ExpiryDate.expirydate(ExpiryDate.java:95)
at csg.List$listener.actionPerformed(List.java:101)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)



	 try{

                Vector<String> expDate=new Vector<String>(); 

		//SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

  	        Calendar c = Calendar.getInstance();

  	        Date currently = c.getTime();

	        Connection conn;

	    	Class.forName(dbdriver);

	    	conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=超市管理系统","aa","000");

	    	PreparedStatement ED=conn.prepareStatement("select 保质期  from 商品");

	    	PreparedStatement PD=conn.prepareStatement("select 生产日期  from 商品");

	    	PreparedStatement all=conn.prepareStatement("select *  from 商品");

	    	ResultSet allrs=all.executeQuery();

	    	ResultSetMetaData allrm=allrs.getMetaData();

	    	ResultSet EDRS=ED.executeQuery();

	    	ResultSet PDRS=PD.executeQuery();

  		    ResultSetMetaData EDRM=EDRS.getMetaData();

  		    ResultSetMetaData PDRM=PDRS.getMetaData();

  		    long days,eDate;

  		    Vector<Long> v1=new Vector<Long>();

  		    Vector<Long> v2=new Vector<Long>();

  		    Vector<String> v3=new Vector<String>();



  		    while(EDRS.next()&&PDRS.next()&&allrs.next()) {

	  		    for(int i = 1; i <= EDRM.getColumnCount(); i++){  

  		        	int edate=EDRS.getInt(i);

  		        	eDate=edate;    	

  		    	    Date prDate=new Date();

  		        for(int j = 1; j <= PDRM.getColumnCount(); j++){  

  		        	prDate=PDRS.getDate(j);

  		            days=(currently.getTime()-prDate.getTime())/(24*3600*1000);

                     long l1=eDate-days;

                     String s1=String.valueOf(l1);

                   //  v3.add(s1);

				  		i++;

			        	j++;

			        	

			        	if((eDate-days)>15) {

			        			        		

			        		for(int k=1;k<=allrm.getColumnCount();k++) {

					        	expDate.addElement(allrs.getString(k));

					        	        	

			        	}

			        		//expDate.addElement(s1);

			        	}

			        	

	  		    }

	 }

}

  		     System.out.println(expDate);

             tableModel.setDataVector(expDate, getHead.getHead());

//catch什么的就不写了