|
下面是我写的一个从学生登录方法
可是log4j输入出myList是空的,什么都是空的
我看了好长时间没有看出是哪里错了
大家帮个忙啊我是新手
下面是代码,麻烦大家留个心看一下啊
public Student login(Student stu) {
Student student = null;
String stuNum = stu.getSNum();
String pwd = stu.getSPwd();
// 非空处理
if (stuNum == null || "".equals(stuNum) || pwd == null
|| "".equals(pwd)) {
return null;
}
// 设置参数
Object[] obj = new Object[] { stuNum, pwd };
List myList = null;
Iterator it = null;
try {
//就是这里怎么调试都不能过去,sql_login是这们写的select * from students where snum = ? and spwd =?
myList = jdbctemplate.query(sql_login, obj,
new RowMapperResultReader(new StudentRowMapper()));
//StudentRowMapper类在后面给出
mylog.info(myList);
it = myList.iterator();
if (it.hasNext()) {
student = (Student) it.next();
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return student;
}
StudentRowMapper类
package org.knight.springdb;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.knight.entity.Student;
import org.springframework.jdbc.core.RowMapper;
public class StudentRowMapper implements RowMapper {
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
Student stu = new Student();
stu.setSID(rs.getLong("SID"));
stu.setSNum(rs.getString("SNum"));
stu.setSPwd(rs.getString("SPwd"));
stu.setSName(rs.getString("SName"));
stu.setSSerice(rs.getString("SSerice"));
stu.setSSpecial(rs.getString("SSpecial"));
stu.setSYear(rs.getLong("SYear"));
return stu;
}
}
大虾帮忙看下是怎么回事啊
谢谢了啊
[ 本帖最后由 zhoule 于 2007-4-20 22:57 编辑 ] |
|