package?com.bwm.db;
import?java.sql.*;

/**
?*class?explain:Database?connection
?*set?up?name:	crazyadept
?*set?up?time:	11/22/2004
?*/
public?class?Conn?{
????private?static?Connection?con;
????private?Statement?stmt;
????private?ResultSet?rs;
????private?static?final?String?drivername?=
????????“sun.jdbc.odbc.JdbcOdbcDriver“;
????private?static?final?String?url?=?“jdbc:odbc:job“;

????/**
?????*method?explain:???Get?Connection?Database
?????*modify?time:	12/20/2004
?????*/
????public?static?synchronized?Connection?getCon（）?throws?Exception?{
????????try?{
????????????Class.forName（drivername）;
????????????con?=?DriverManager.getConnection（url）;
????????????return?con;
????????}?catch?（SQLException?e）?{
????????????System.err.println（e.getMessage（））;
????????????throw?e;
????????}
????}

????/**
?????*output?parameter:	in?order?select?in?SQL
?????*modify?time:	12/20/2004
?????*/
????public?Statement?getStmtread（）?{
????????try?{
????????????con?=?getCon（）;
????????????stmt?=?con.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE
???????????????????????????????????????ResultSet.CONCUR_READ_ONLY）;
????????????return?stmt;
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????return?null;
????}

????/**
?????*output?parameter:?Data
?????*input?parameter:??SQL?select?sentence
?????*modify?time:??????11/29/2004
?????*/
????public?ResultSet?getRs（String?sql）?{
????????try?{
????????????stmt?=?getStmtread（）;
????????????rs?=?stmt.executeQuery（sql）;
????????????return?rs;
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????return?null;
????}

????/**
?????*output?parameter:?not?in?order?select?in?str?SQL
?????*modify?time:??????11/29/2004
?????*/
????public?Statement?getStmt（）?{
????????try?{
????????????con?=?getCon（）;
????????????stmt?=?con.createStatement（）;
????????????return?stmt;
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????return?null;
????}

????/**
?????*method?explain:???Close?Database?Connection
?????*modify?time:??????11/29/2004
?????*/
????public?synchronized?void?close（）?{
????????try?{
????????????if?（rs?!=?null）?{
????????????????rs.close（）;
????????????????rs?=?null;
????????????}
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????try?{
????????????if?（stmt?!=?null）?{
????????????????stmt.close（）;
????????????????stmt?=?null;
????????????}
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????try?{
????????????if?（con?!=?null）?{
????????????????con.close（）;
????????????????con?=?null;
????????????}
????????}?catch?（Exception?e）?{
???????

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

?????文件????????382??2005-05-30?17:24??Job\index.htm

?????文件???????1517??2005-02-04?10:39??Job\login.jsp

?????文件???????4978??2008-06-27?06:48??Job\view.jsp

?????文件???????5305??2008-06-29?10:41??Job\index.jsp

?????文件????????673??2005-01-06?20:20??Job\admin\admin.jsp

?????文件???????1866??2005-01-07?09:09??Job\admin\aflink.jsp

?????文件???????1890??2005-02-04?09:35??Job\admin\cjob.jsp

?????文件????????448??2005-01-07?08:19??Job\admin\dcjob.jsp

?????文件????????451??2005-01-06?20:52??Job\admin\dcompany.jsp

?????文件????????451??2005-01-06?20:41??Job\admin\dstudent.jsp

?????文件????????162??2005-01-06?20:36??Job\admin\include.jsp

?????文件???????1222??2004-12-29?13:38??Job\admin\index.htm

?????文件????????561??2005-02-02?11:05??Job\admin\login.htm

?????文件???????1764??2005-02-04?09:32??Job\admin\sjob.jsp

?????文件???????1076??2005-01-07?08:22??Job\admin\top.htm

?????文件????????808??2008-06-29?17:58??Job\admin\login.jsp

?????文件????????443??2008-06-29?19:51??Job\admin\dsjob.jsp

?????文件???????2087??2008-06-29?20:27??Job\admin\flink.jsp

?????文件????????736??2008-06-29?20:33??Job\admin\mflink.jsp

?????文件????????439??2008-06-29?20:43??Job\admin\dflink.jsp

?????文件???????1691??2008-06-30?10:22??Job\admin\company.jsp

?????文件???????1903??2008-06-30?10:26??Job\admin\student.jsp

?????文件???????1825??2005-02-04?09:45??Job\company\ajobinfo.htm

?????文件????????907??2005-02-17?10:47??Job\company\ajobinfo.jsp

?????文件????????737??2005-01-19?10:05??Job\company\djobinfo.jsp

?????文件???????2591??2008-07-15?11:27??Job\company\index.htm

?????文件???????1726??2005-01-19?09:52??Job\company\left.htm

?????文件????????617??2005-01-03?14:17??Job\company\login.htm

?????文件???????1581??2005-01-06?14:18??Job\company\mreginfo.jsp

?????文件???????2165??2005-01-25?19:04??Job\company\reg.jsp

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