package?utils;

import?java.sql.Connection;
import?javax.sql.DataSource;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?javax.naming.InitialContext;

public?class?DBManager?{
	?private?Connection?con?=?null;
	????private?Statement?stmt?=?null;
	????private?ResultSet?rs?=?null;
	????private?DataSource?ds;
	????public?void?init（）
	????{
	????????try
	????????{
	????????????//InitialContext?ctx=new?InitialContext（）;
	????????????//ds=（DataSource）ctx.lookup（“java:/MSSQLXADS“）;
	????????????//con=ds.getConnection（）;
	????????	Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
	????????????//加載驅(qū)動(dòng)程序
	????????????con?=?DriverManager.getConnection（“jdbc:microsoft:sqlserver://localhost;DatabaseName=Final““sa“““）;
	????????????//創(chuàng)建連接
	????????}catch（Exception?e）{}
	????}
	?
	????//獲取連接
	????public?Connection?getConnection（）
	????{
	????????if（con?==?null）
	???????????init（）;
	????????return?con;
	????}
	????
	????//執(zhí)行有結(jié)果集的查詢
	????public?int?executeUpdate（String?sql）?throws?SQLException
	????{
	????????stmt?=?getConnection（）.createStatement（）;
	????????return?stmt.executeUpdate（sql）;
	????}
	????public?ResultSet?executeQuery（String?sql）?throws?SQLException
	????{
	????????stmt?=?getConnection（）.createStatement（）;
	????????return?stmt.executeQuery（sql）;
	????}
	????
	????public?void?close（）
	????{
	????????if（rs!=null）
	????????????try?{
	????????????????rs.close（）;
	????????????}?catch?（SQLException?e）?{??????????}
	????????if（stmt!=null）
	????????????try?{
	????????????????stmt.close（）;
	????????????}?catch?（SQLException?e）?{??????????}
	????????if（con!=null）
	????????????try?{
	????????????????con.close（）;
	????????????}?catch?（SQLException?e）?{??????????}
	?
	????}
	????
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????5242880??2008-04-16?19:04??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\DB\Final_Data.MDF

?????文件????2097152??2008-04-16?19:04??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\DB\Final_Log.LDF

?????文件?????????34??2007-03-21?13:57??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\DB\程序運(yùn)行說(shuō)明.txt

?????文件???????6417??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\Book.jsp

?????文件???????7480??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\BookAdd.jsp

?????文件???????7471??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\BookDel.jsp

?????文件???????3772??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\BookInfo.jsp

?????文件???????8509??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\BookMod.jsp

?????文件???????8146??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\BookQuery.jsp

?????文件???????7009??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\MainImages\bg01.gif

?????文件???????5617??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\MainImages\bottom.gif

?????文件??????20992??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\MainImages\Thumbs.db

?????文件??????59764??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\MainImages\Top.jpg

?????文件???????2382??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Book\style.css

?????文件???????5833??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\Class.jsp

?????文件???????6736??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\ClassAdd.jsp

?????文件???????6599??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\ClassDel.jsp

?????文件???????3832??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\ClassInfo.jsp

?????文件???????7245??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\ClassMod.jsp

?????文件???????8317??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\ClassQuery.jsp

?????文件???????7009??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\MainImages\bg01.gif

?????文件???????5617??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\MainImages\bottom.gif

?????文件??????20992??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\MainImages\Thumbs.db

?????文件??????59764??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\MainImages\Top.jpg

?????文件???????2382??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Class\style.css

?????文件???????1872??2007-03-21?13:48??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\DBManager.java

?????文件???????5603??2008-04-18?12:06??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\EJB\TeachingM.jar

?????文件???????1261??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\error.jsp

?????文件??????19994??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Help\3aa846f5-3209-43f6-bd18-cdeaff9ed418.jpg

?????文件???????1054??2008-04-17?10:45??基于J2EE的教材管理系統(tǒng)分析與設(shè)計(jì)\TeachingM2.war\Help\check.jsp

............此處省略89個(gè)文件信息