分层实现JSP通过JDBC操作数据库

准备工作:

开发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;
	}

}