userservice.java

jsf 框架 得 一个实现代码 实现增删改查功能

package com.softeem.jsf.bean;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.softeem.datasource.DataSourceFactory;

import com.softeem.jsf.model.UserDAO;
import com.softeem.jsf.model.UserDTO;

public class UserService {

	public List<UserDTO> findAll(){
		List<UserDTO> list= new ArrayList<UserDTO>();
		try {
			Connection con = DataSourceFactory.getDataSource().getConnection();
			UserDAO dao = new UserDAO(con);
			list = dao.findAll();
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public UserDTO getByid(int id) {
		UserDTO dto = new UserDTO();
		try {
			Connection con = DataSourceFactory.getDataSource().getConnection();
			UserDAO dao = new UserDAO(con);
			dto = dao.getById(id);
			
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return dto;
	}
	
	public void insert(UserDTO dto )
	{
		try {
			Connection con = DataSourceFactory.getDataSource().getConnection();
			UserDAO dao =  new UserDAO(con);
			dao.insert(dto);
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public void update(UserDTO dto )
	{
		try {
			Connection con = DataSourceFactory.getDataSource().getConnection();
			UserDAO dao = new UserDAO(con);
			dao.update(dto);
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public void delete(int id)
	{
		try {
			Connection con = DataSourceFactory.getDataSource().getConnection();
			UserDAO dao = new UserDAO(con);
			dao.delete(id);
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}