datasourcedb.java

一个简单的基于struts基于人员的管理

package com.yourcompany;
import com.yourcompany.Role;
import java.sql.*;
import java.util.ArrayList;

import com.yourcompany.Department;

public class DatasourceDB 
{
	public static java.sql.Connection GetConnection()
	{
		//连接SqlServer 数据库
		java.sql.Connection conn = null;
		try
		{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		    conn=	DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=employees", "sa", "");
		}
		catch(Exception e)
		{
			System.out.println("connect to  databse  error"); 
		}
		return conn;
	}
	public static ArrayList getdepartmentcollection()
	{
		 ArrayList<Department> departments = new ArrayList<Department>();
		  java.sql.Connection conn = DatasourceDB.GetConnection();
		  java.sql.Statement st = null;
		  java.sql.ResultSet rs = null;
		  try
		  {
			   st = conn.createStatement();
			   rs = st.executeQuery("select  * from departments");
			   Department dept = null;
			  
			  while(rs.next())
			  {
				  dept = new Department();
				  dept.setDepid(rs.getInt("Depid"));
				  dept.setDepname(rs.getString("depname"));
				  departments.add(dept);
			  }
		  }
		  catch(Exception e)
		  {
			  try
			  {
				  rs.close();
				  st.close();
			  }
			  catch(Exception e1)
			  {
				  
			  }
		  }
		  return departments;
	}
	
	//返回角色集合
	public static ArrayList getRolecollection()
	{
		java.sql.Statement st = null;
		java.sql.ResultSet rs = null;
		java.sql.Connection conn = null;
		ArrayList<Role> roles = new ArrayList<Role>();
		Role role=null;
		try
		{
			conn = DatasourceDB.GetConnection();
			st = conn.createStatement();
			rs = st.executeQuery("select * from roles");
			while(rs.next())
			{
				role = new Role();
				role.setRoleid(rs.getInt("roleid"));
				role.setRolename(rs.getString("rolename"));
				roles.add(role);
			}
		}
		catch(Exception e)
		{
			
		}
		finally
		{
			try
			{
				rs.close();
				st.close();
			}
			catch(Exception e1)
			{
				
			}
		}
		return roles;
	}
}