喜悦国际村 - JAVA/C/C++ - 问java查询mysql数据库的问题(页 1)

喜悦国际村 » JAVA/C/C++ » 问java查询mysql数据库的问题

页: [1]

Kliff

2004-11-1 02:46 PM

问java查询mysql数据库的问题

系统是winxp，apache,resin,jdk1.4x

请教一下

要求从employer表中查找出employer.sp=employee.sp1 或 employer.sp=employee.sp2的记录，显示它们的cna1,cna2项

55555，编译的时候一直出错，空指针....

我写的String query = "select `emplyer.cname`,`employer.address`,`employer.ctele` from `employer`,`employee` WHERE `employer.sp`=`employee.sp1` or `employer.sp` = `employee.sp2` ORDER BY `employer.cname` desc";

然后是
ResultSet res = null;
PreparedStatement ps = null;
try
{
ps = this.conn.prepareStatement(query);
res = ps.executeQuery();
return res;
}

以上是javabean部分
对象调用是

<%
ResultSet res = td_pjm.getJobsSimply();

String cname = "abcd"; //null也一样
String caddress = "abcd";
String ctele = "abcd";
cname = res.getString("employer.cname");
caddress = res.getString("employer.address");
ctele = res.getString("employer.ctele");

%>

我觉得是查询语句有问题
望高人指教
万分感谢

雨伞	2004-11-2 04:36 AM

ResultSet res = td_pjm.getJobsSimply();
res.next();//加上这一行

查看完整版本: 问java查询mysql数据库的问题