package?com.homeofdog.dao;

import?java.sql.*;
import?java.util.*;

public?class?baseDAO?{
	private?final?String?DRIVER=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?final?String?URL=“jdbc:sqlserver://localhost:1433;DatabaseName=HomeOfDogDB“;
	private?final?String?USER=“sa“;
	private?final?String?PWD=“123@qwe“;
	//獲取數(shù)據(jù)庫連接
	public?Connection?getConn（）{
		Connection?conn=null;
		try?{
			Class.forName（DRIVER）;
			conn=DriverManager.getConnection（URL?USER?PWD）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
	//關(guān)閉連接
	public?void?closeAll（Connection?connStatement?stResultSet?rst）{
		try?{
			if（rst!=null）{
				rst.close（）;
			}
			if（st!=null）{
				st.close（）;
			}
			if（conn!=null）{
				conn.close（）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	//設(shè)置參數(shù)
	public?void?setParams（PreparedStatement?pstobject[]?params）{
		if（params==null）
			return;
		try?{
			for（int?i=0;i				pst.setobject（i+1?params[i]）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	//得到單行單列值
	public?object?getSingleVal（String?sqlobject[]?params）{
		Connection?conn=null;
		PreparedStatement?pst=null;
		ResultSet?rst=null;
		object?res=null;
		try?{
			conn=getConn（）;
			pst=conn.prepareStatement（sql）;
			setParams（pst?params）;
			rst=pst.executeQuery（）;
			while（rst.next（））{
				res=rst.getobject（1）;
			}
		}?catch?（SQLException?e）{
			e.printStackTrace（）;
		}finally{
			closeAll（conn?pst?rst）;
		}
		return?res;
	}
	//通用增刪改方法
	public?int?executeUpdate（String?sqlobject[]?params）{
		Connection?conn=null;
		PreparedStatement?pst=null;
		int?res=0;
		try?{
			conn=getConn（）;
			conn.setAutoCommit（false）;
			pst=conn.prepareStatement（sql）;
			setParams（pst?params）;
			res=pst.executeUpdate（）;
			conn.commit（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			try?{
				conn.rollback（）;
			}?catch?（SQLException?e1）?{
				e1.printStackTrace（）;
			}
		}finally{
			closeAll（conn?pst?null）;
		}
		return?res;
		
	}
	//通用查詢
	public?List>?executeQuery（String?sqlobject[]?params）{
		Connection?conn=null;
		PreparedStatement?pst=null;
		ResultSet?rst=null;
		List>?table=new?ArrayList>（）;
		
		try?{
			conn=getConn（）;
			pst=conn.prepareStatement（sql）;
			setParams（pst?params）;
			rst=pst.executeQuery（）;
			ResultSetmetaData?rsmd=rst.getmetaData（）;
			while（rst.next（））{
				Map?row=new?HashMap（）;
				for（int?i=1;i<=rsmd.getColumnCount（）;i++）{
					row.put（rsmd.getColumnName（i）?rst.getString（i））;
				}
				table.add（row）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			closeAll（conn?pst?rst）;
		}
		return?table;
	}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-26?20:06??新建文件夾\
?????目錄???????????0??2017-12-26?20:05??新建文件夾\HomeOfDog\
?????文件?????5242880??2017-12-26?09:54??新建文件夾\HomeOfDogDB.mdf
?????文件?????3145728??2017-12-26?09:54??新建文件夾\HomeOfDogDB_Log.ldf
?????文件????????1093??2017-11-16?14:08??新建文件夾\HomeOfDog\.classpath
?????文件????????1334??2017-11-17?13:45??新建文件夾\HomeOfDog\.project
?????目錄???????????0??2017-12-26?20:05??新建文件夾\HomeOfDog\.settings\
?????文件?????????522??2017-11-16?14:08??新建文件夾\HomeOfDog\.settings\.jsdtscope
?????文件??????????87??2017-11-18?09:30??新建文件夾\HomeOfDog\.settings\com.genuitec.eclipse.core.prefs
?????文件??????????57??2017-12-20?16:00??新建文件夾\HomeOfDog\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2017-11-18?09:26??新建文件夾\HomeOfDog\.settings\org.eclipse.jdt.core.prefs
?????文件?????????486??2017-11-16?14:08??新建文件夾\HomeOfDog\.settings\org.eclipse.wst.common.component
?????文件?????????414??2017-11-16?14:08??新建文件夾\HomeOfDog\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-11-16?14:08??新建文件夾\HomeOfDog\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-11-16?14:08??新建文件夾\HomeOfDog\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????36692??2017-12-14?12:25??新建文件夾\HomeOfDog\HomeOfDog.sql
?????文件????????9129??2017-12-20?19:04??新建文件夾\HomeOfDog\HomeOfDog_create.sql
?????目錄???????????0??2017-12-26?20:05??新建文件夾\HomeOfDog\src\
?????目錄???????????0??2017-12-26?20:05??新建文件夾\HomeOfDog\src\com\
?????目錄???????????0??2017-12-26?20:05??新建文件夾\HomeOfDog\src\com\homeofdog\
?????目錄???????????0??2017-12-26?20:05??新建文件夾\HomeOfDog\src\com\homeofdog\dao\
?????文件????????3025??2017-12-23?12:32??新建文件夾\HomeOfDog\src\com\homeofdog\dao\baseDAO.java
?????文件?????????239??2017-12-24?15:50??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IClaimDAO.java
?????文件?????????850??2017-12-24?15:50??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IClientInfoDAO.java
?????文件?????????420??2017-12-12?18:25??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IDepartmentsDAO.java
?????文件?????????660??2017-12-12?19:09??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IEmpInfoDAO.java
?????文件?????????414??2017-12-12?19:37??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IEmpTypeDAO.java
?????文件?????????263??2017-12-21?22:54??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IEmpType_moduleDAO.java
?????文件?????????436??2017-12-12?21:03??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IGoodBrandDAO.java
?????文件?????????637??2017-12-21?22:56??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IGoodCheckDAO.java
?????文件?????????200??2017-12-21?22:56??新建文件夾\HomeOfDog\src\com\homeofdog\dao\IGoodCheckDetailDAO.java
............此處省略930個(gè)文件信息