package?com.DB;
import?java.sql.*;
/**
?*?數據庫連接baseDao
?*?@author?趙均金
?*?業務邏輯層對數據庫進行操作
?*/
public?class?baseDao?{
	/**
	?*?獲取對數據庫的連接
	?*?@return?返回數據庫的連接conn
	?*/
	public?static?Connection?getConn（）?{
		Connection?conn?=?null;
		try?{
			//Class.forName（“加載數據庫的驅動類“）
			Class.forName（“com.mysql.jdbc.Driver“）;
			conn?=?DriverManager.getConnection（“jdbc:mysql://localhost/select_course?user=root&password=zjj950216“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
	/**
	?*?獲取sql語句
	?*?@param?conn?連接數據庫
	?*?@param?sql?要執行的sql語句
	?*?@return?返回一個sql語句的對象
	?*/
	public?static?PreparedStatement?prepare（Connection?conn??String?sql）?{
		PreparedStatement?pstmt?=?null;?
		try?{
			if（conn?!=?null）?{
				pstmt?=?conn.prepareStatement（sql）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?pstmt;
	}
	/**
	?*?
	?*?@param?conn
	?*?@return?執行sql語句
	?*/
	public?static?Statement?getStatement（Connection?conn）?{
		Statement?stmt?=?null;?
		try?{
			if（conn?!=?null）?{
				stmt?=?conn.createStatement（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?stmt;
	}
	/**
	?*?
	?*?@param?stmt?執行的靜態sql語句
	?*?@param?sql?將被執行的sql語句
	?*?@return?執行sql語句后的結果
	?*/
	public?static?ResultSet?getResultSet（Statement?stmt?String?sql）?{
		ResultSet?rs?=?null;
		try?{
			if（stmt?!=?null）?{
				rs?=?stmt.executeQuery（sql）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?rs;
	}
	
	/**
	?*?進行增刪改操作
	?*?@param?stmt
	?*?@param?sql
	?*/
	public?static?void?executeUpdate（Statement?stmt?String?sql）?{
		try?{
			if（stmt?!=?null）?{
				stmt.executeUpdate（sql）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?關閉conn
	?*?@param?conn
	?*/
	public?static?void?close（Connection?conn）?{
		try?{
			if（conn?!=?null）?{
				conn.close（）;
				conn?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	/**
	?*?關閉stmt
	?*?@param?stmt
	?*/
	public?static?void?close（Statement?stmt）?{
		try?{
			if（stmt?!=?null）?{
				stmt.close（）;
				stmt?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	/**
	?*?關閉resultset
	?*?@param?rs
	?*/
	public?static?void?close（ResultSet?rs）?{
		try?{
			if（rs?!=?null）?{
				rs.close（）;
				rs?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1093??2017-03-17?09:12??LunWen\.classpath

?????文件???????1343??2017-03-17?09:14??LunWen\.project

?????文件????????522??2017-03-17?09:12??LunWen\.settings\.jsdtscope

?????文件????????364??2017-03-17?09:12??LunWen\.settings\org.eclipse.jdt.core.prefs

?????文件????????513??2017-03-17?09:12??LunWen\.settings\org.eclipse.wst.common.component

?????文件????????414??2017-03-17?09:12??LunWen\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-03-17?09:12??LunWen\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-03-17?09:12??LunWen\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????950??2017-03-23?10:23??LunWen\doc\about.html

?????文件???????1866??2017-03-23?10:27??LunWen\doc\allclasses-frame.html

?????文件???????1626??2017-03-23?10:27??LunWen\doc\allclasses-noframe.html

?????文件???????3957??2017-03-23?10:27??LunWen\doc\com\DB\class-use\DB.html

?????文件???????4045??2017-03-23?10:27??LunWen\doc\com\DB\class-use\FileUpLoad.html

?????文件??????13307??2017-03-23?10:27??LunWen\doc\com\DB\DB.html

?????文件??????13809??2017-03-23?10:27??LunWen\doc\com\DB\FileUpLoad.html

?????文件????????842??2017-03-23?10:27??LunWen\doc\com\DB\package-frame.html

?????文件???????4650??2017-03-23?10:27??LunWen\doc\com\DB\package-summary.html

?????文件???????4314??2017-03-23?10:27??LunWen\doc\com\DB\package-tree.html

?????文件???????3812??2017-03-23?10:27??LunWen\doc\com\DB\package-use.html

?????文件???????6605??2017-03-23?10:27??LunWen\doc\com\entity\class-use\Msg.html

?????文件???????8994??2017-03-23?10:27??LunWen\doc\com\entity\class-use\Student.html

?????文件???????8990??2017-03-23?10:27??LunWen\doc\com\entity\class-use\Teacher.html

?????文件??????10587??2017-03-23?10:27??LunWen\doc\com\entity\class-use\Topic.html

?????文件???????9874??2017-03-23?10:27??LunWen\doc\com\entity\Msg.html

?????文件???????1040??2017-03-23?10:27??LunWen\doc\com\entity\package-frame.html

?????文件???????5243??2017-03-23?10:27??LunWen\doc\com\entity\package-summary.html

?????文件???????4722??2017-03-23?10:27??LunWen\doc\com\entity\package-tree.html

?????文件???????5574??2017-03-23?10:27??LunWen\doc\com\entity\package-use.html

?????文件??????17077??2017-03-23?10:27??LunWen\doc\com\entity\Student.html

?????文件??????20586??2017-03-23?10:27??LunWen\doc\com\entity\Teacher.html

............此處省略214個文件信息