java中数据库连接得到NULL_java 从数据库中取出的值为什么都是null

com.db.CommonBeanmyBean=newcom.db.CommonBean();com.util.DealStringds=newcom.util.DealString();Stringid=ds.toString(request.getParameter("id"));Stringsql="selectother_aqkh...

com.db.CommonBean myBean = new com.db.CommonBean();

com.util.DealString ds = new com.util.DealString();

String id=ds.toString(request.getParameter("id")) ;

String sql = " select other_aqkh_gen_id,name,checkdate,checker,kf1,kf2,kf3,kf4,kf5,kf6,kf7,kf8,kf9,kf10,kf11,kf12,sum from other_aqkh_gen where other_aqkh_gen_id='"+id+"'";

Vector vect=myBean.getDataBySql(sql);

System.out.println(sql);

if(vect.size()>0) {

Hashtable hs=(Hashtable)vect.get(0);

String gen_id=(String)hs.get("other_aqkh_gen_id");

String gen_name=(String)hs.get("name");

String gen_checkdate=(String)hs.get("checkdate");

String gen_checker=(String)hs.get("checke");

String gen_kf1=(String)hs.get("kf1");

String gen_kf2=(String)hs.get("6");

String gen_kf3=(String)hs.get("7");

String gen_kf4=(String)hs.get("8");

String gen_kf5=(String)hs.get("9");

String gen_kf6=(String)hs.get("10");

String gen_kf7=(String)hs.get("11");

String gen_kf8=(String)hs.get("12");

String gen_kf9=(String)hs.get("13");

String gen_kf10=(String)hs.get("14");

String gen_kf11=(String)hs.get("15");

String gen_kf12=(String)hs.get("16");

String gen_sum=(String)hs.get("17");

System.out.println("结果"+gen_id+gen_name+gen_checkdate+gen_checker+gen_kf1);

16:57:39 连接累计> 0 当前连接> 0 池中连接> 0 池空未连接> 0 DB未响应> 0 JVM垃圾回收> 198 id1=81

select other_aqkh_gen_id,name,checkdate,checker,kf1,kf2,kf3,kf4,kf5,kf6,kf7,kf8,kf9,kf10,kf11,kf12,sum from other_aqkh_gen where other_aqkh_gen_id='81'

结果nullnullnullnullnull

other_aqkh_gen_id=81在表中是有的，而且直接把那SQL语句放到sql PLUS中执行也是可以查到数据的

展开