准备工作:
开发IDE:eclipse霓虹灯
JDK版本:8u66
TOMCAT版本:8.54
package com.svgteam.dao;
import java.util.List;
import com.svgteam.entity.User;
public interface IUserDao {
public List<User> query(String sql,Object... args);
}
package com.svgteam.dao.impl;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.svgteam.dao.IUserDao;
import com.svgteam.entity.User;
import com.svgteam.util.BaseDao;
public class UserDao extends BaseDao implements IUserDao{
@Override
public List<User> query(String sql, Object... args) {
List<User> users = new ArrayList<User>();
try {
super.getConnection();
ps = super.conn.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
ps.setObject(i+1, args[i]);
}
rs = ps.executeQuery();
while(rs.next())
{
users.add(new User(rs.getInt("id"),
rs.getString("name"),
rs.getString("pwd")));
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
super.close();
}
return users;
}
}