jsp的访问中间套用数据库访问 请问有什么好的解决方法吗?谢谢 急
<%
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
Calendar cal=Calendar.getInstance();
String datet2=sdf.format(cal.getTime());
cal.add(Calendar.DAY_OF_YEAR,-7);
String datet=sdf.format(cal.getTime());
int iniid=0;
String addinfo="select * from userd order by ID desc";
ResultSet rsa=user.executeQuery(addinfo);
if(rsa.next())
{
iniid=rsa.getInt(1);
}
else
{iniid=0;}
iniid=iniid+1;
rsa.close();
String bw= "select * from beiwang where flag=0 and bw_time between to_date('"+datet+"','yyyy-mm-dd') and to_date('"+datet2+"','yyyy-mm-dd') ";
ResultSet bwRs=user.executeQuery(bw);
String usname,zj_tel2,dateT,ye_name,dailishang_name;
String fuwu_name,content,service_fangshi,kefu_name;
while (bwRs.next()){
out.print("caozuo");
usname=bwRs.getString("username");
zj_tel2=bwRs.getString("zj_tel");
java.sql.Date datetw=bwRs.getDate("bw_time");
dateT=datetw.toString();
ye_name=bwRs.getString("yewu_name");
dailishang_name=bwRs.getString("dailishang_name");
fuwu_name=bwRs.getString("fuwu_name");
content=bwRs.getString("content");
service_fangshi=bwRs.getString("service_fangshi");
kefu_name=bwRs.getString("kefu_name");
String info="select * from userd where username='"+usname+"' and zj_tel="+zj_tel2+" order by ID desc";
ResultSet infRs=user.executeQuery(info);
java.util.Date datett = new java.util.Date();
java.text.SimpleDateFormat sf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String mDateTime = sf.format(datett);
String contact_man="";
String contact_phone="";
String starx="";
String address="";
String service_finish="1";
if(infRs.next())
{
contact_man=infRs.getString(5);
contact_phone=infRs.getString(6);
starx=infRs.getString(7);
address=infRs.getString(3);
}
String insertsql="insert into userd(ID,username,address,zj_tel,contact_man,contact_phone,star,yewu_name,dailishang_name,kefu_name,kehu_time,service_content,kehu_fangshi,service_finish,zhaiyao,luru_ren,luru_time) values("+iniid+",'"+usname+"','"+address+"','"+zj_tel2+"','"+contact_man+"','"+contact_phone+"','"+starx+"','"+ye_name+"','"+dailishang_name+"','"+kefu_name+"',to_date('"+dateT+"','yyyy-mm-dd'),'"+fuwu_name+"','"+service_fangshi+"','"+service_finish+"','"+content+"','"+username+"',to_date('"+mDateTime+"','yyyy-MM-dd hh24:mi:ss'))";
out.print(insertsql);
//out.print(bwl);
// user.executeUpdate(insertsql);
String up="update beiwang set flag=1 where username='"+usname+"' and zj_tel="+zj_tel2;
// user.executeUpdate(up);
}
%>
提示 :
java.lang.NullPointerException
at oracle.jdbc.driver.ScrollableResultSet.cacheRowAt(ScrollableResultSet.java)
at oracle.jdbc.driver.ScrollableResultSet.isValidRow(ScrollableResultSet.java)
at oracle.jdbc.driver.ScrollableResultSet.next(ScrollableResultSet.java)