/*
?*?SqlConn.java
?*?Text?file?encoding:?utf8
?*/

package?com.chrkey.bean;

import?java.sql.*;

public?class?SqlConn?{
	private?String?url?=?“jdbc:mysql://localhost:3306/adms“;
	private?String?user?=?“root“;?//?數據庫用戶名
	private?String?password?=?“123456789“;

	private?Connection?conn?=?null;?//?數據庫連接對象
	private?Statement?stmt?=?null;?//?數據庫連接狀態對象
	private?ResultSet?rs?=?null;?//?數據庫查詢結果集

	public?SqlConn（）?{?//使用JDBC建立數據庫連接
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;?//括號里邊為驅動程序名

		}?catch?（java.lang.ClassNotFoundException?e）?{
			System.err.println（“SqlConn（）:“?+?e.getMessage（））;
		}
	}

	public?ResultSet?executeQuery（String?sql）?{
		try?{
			conn?=?DriverManager.getConnection（url?user?password）;?//?獲得數據庫連接
			stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_SENSITIVE
					ResultSet.CONCUR_READ_ONLY）;?//?建立Statement對象
			rs?=?stmt.executeQuery（sql）;
		}?catch?（SQLException?ex）?{
			System.err.println（“SqlConn.executeQuery:“?+?ex.getMessage（））;
		}
		return?rs;
	}

	public?void?executeUpdate（String?sql）?{
		try?{
			conn?=?DriverManager.getConnection（url?user?password）;
			stmt?=?conn.createStatement（）;
			stmt.executeUpdate（sql）;
			stmt.close（）;
			conn.close（）;
		}?catch?（SQLException?ex）?{
			System.err.println（“SqlConn.executeUpdate:?“?+?ex.getMessage（））;
		}
	}

	public?void?closeStmt（）?{
		try?{
			stmt.close（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

	public?void?closeConn（）?{
		try?{
			conn.close（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2008-06-24?23:44??ADMS\
?????文件????????1342??2008-06-25?17:46??ADMS\.project
?????目錄???????????0??2008-06-24?23:44??ADMS\src\
?????目錄???????????0??2008-06-24?23:52??ADMS\src\com\
?????目錄???????????0??2008-06-24?23:52??ADMS\src\com\chrkey\
?????目錄???????????0??2008-06-24?23:52??ADMS\src\com\chrkey\bean\
?????文件????????1718??2008-07-20?16:46??ADMS\src\com\chrkey\bean\SqlConn.java
?????目錄???????????0??2008-06-24?23:44??ADMS\WebRoot\
?????目錄???????????0??2008-06-24?23:44??ADMS\WebRoot\WEB-INF\
?????目錄???????????0??2008-06-24?23:44??ADMS\WebRoot\WEB-INF\lib\
?????文件??????676693??2008-06-20?21:53??ADMS\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.5-bin.jar
?????目錄???????????0??2008-06-24?23:44??ADMS\WebRoot\WEB-INF\classes\
?????目錄???????????0??2008-06-29?19:48??ADMS\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2008-06-29?19:48??ADMS\WebRoot\WEB-INF\classes\com\chrkey\
?????目錄???????????0??2008-06-29?19:48??ADMS\WebRoot\WEB-INF\classes\com\chrkey\bean\
?????文件????????2416??2008-07-20?16:46??ADMS\WebRoot\WEB-INF\classes\com\chrkey\bean\SqlConn.class
?????文件?????????375??2008-06-24?23:44??ADMS\WebRoot\WEB-INF\web.xml
?????目錄???????????0??2008-06-24?23:44??ADMS\WebRoot\meta-INF\
?????文件??????????39??2008-06-24?23:44??ADMS\WebRoot\meta-INF\MANIFEST.MF
?????文件??????????90??2008-06-25?11:04??ADMS\WebRoot\index.jsp
?????文件????????2656??2008-07-19?13:13??ADMS\WebRoot\adms.jsp
?????文件????????1227??2008-07-19?10:49??ADMS\WebRoot\add.jsp
?????文件????????1130??2008-07-18?15:46??ADMS\WebRoot\addto.jsp
?????文件????????1116??2008-07-19?14:18??ADMS\WebRoot\del.jsp
?????文件????????1705??2008-07-20?16:29??ADMS\WebRoot\modify.jsp
?????文件????????1346??2008-07-20?16:25??ADMS\WebRoot\modifyto.jsp
?????文件????????1638??2008-07-20?11:14??ADMS\WebRoot\login.jsp
?????文件????????1703??2008-07-18?16:02??ADMS\WebRoot\loginto.jsp
?????文件????????1496??2008-07-19?13:33??ADMS\WebRoot\search.jsp
?????目錄???????????0??2008-06-24?23:44??ADMS\.myeclipse\
?????文件?????????285??2008-06-24?23:44??ADMS\.mymetadata
............此處省略4個文件信息