package?baseDao;

import?java.sql.*;

import?javax.naming.InitialContext;
import?javax.naming.NamingException;
import?javax.sql.DataSource;

import?org.omg.CORBA.Context;


public?class?MoBan?{
	private?static?String?dirver=“oracle.jdbc.driver.OracleDriver“;
	private?static?String?url=“jdbc:oracle:thin:@localhost:1521:orcl“;
	private?static?String?uname=“l(fā)vjiarui“;
	private?static?String?upwd=“Aa422422“;
	
	
	protected?static?Connection?con=null;//將連接的對(duì)象進(jìn)行初始化
	protected?static?Statement?stmt=null;//進(jìn)行初始化?執(zhí)行靜態(tài)SQL語句返回它生成結(jié)果
	protected?static?PreparedStatement?pstmt=null;//安全的statement
	protected?static?ResultSet?rs=null;//集初始化
	
	public?static?Connection?getConnection（）{//創(chuàng)建登陸連接函數(shù)
		
			
			try?{
				javax.naming.Context?ctx=new?InitialContext（）;
				DataSource?ds=（DataSource）ctx.lookup（“java:comp/env/jdbc/oracle“）;
				con=ds.getConnection（）;
			}?catch?（NamingException?e）?{
				System.out.println（“失敗“）;
				e.printStackTrace（）;
			}?catch?（SQLException?e）?{
				System.out.println（“失敗“）;
				e.printStackTrace（）;
			}
			
//			Class.forName（dirver）;//注冊(cè)去驅(qū)動(dòng)	
//			System.out.println（“驅(qū)動(dòng)成功“）;
//		}?catch?（ClassNotFoundException?e）?{
//			e.printStackTrace（）;
//		}
//		try?{
//			con=DriverManager.getConnection（url?uname?upwd）;//驅(qū)動(dòng)管理器的取數(shù)據(jù)連接方法???到數(shù)據(jù)庫賬戶信息?交給?連接對(duì)象?進(jìn)行連接
//			
//			System.out.println（“連接成功“）;

		return?con;//返回對(duì)象con
	}

	public?static?void?main（String[]?aStrings）{
		MoBan?mb=new?MoBan（）;
		System.out.println（mb.getConnection（））;
	}
	public?static?void?closeall（）{
		try?{
			if?（rs!=null）?{
			rs.close（）;
			}if?（stmt!=null）?{
				stmt.close（）;
			}if?（pstmt!=null）?{
				pstmt.close（）;
			}if?（con!=null）?{
				pstmt.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	public?static?void?closeall（ResultSet?rsPreparedStatement?pstmtConnection?conStatement?stmt）{
		try?{
			if?（rs!=null）?{
			rs.close（）;
			}if?（stmt!=null）?{
				stmt.close（）;
			}if?（pstmt!=null）?{
				pstmt.close（）;
			}if?（con!=null）?{
				pstmt.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

}

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

?????文件???????1143??2014-07-26?14:47??LiaoTianShi\.classpath

?????文件???????1336??2014-07-26?15:18??LiaoTianShi\.project

?????文件????????522??2014-07-26?14:47??LiaoTianShi\.settings\.jsdtscope

?????文件????????364??2014-07-26?14:47??LiaoTianShi\.settings\org.eclipse.jdt.core.prefs

?????文件????????494??2014-07-26?14:47??LiaoTianShi\.settings\org.eclipse.wst.common.component

?????文件????????401??2014-07-26?14:47??LiaoTianShi\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-07-26?14:47??LiaoTianShi\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-07-26?14:47??LiaoTianShi\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2237??2014-07-26?15:01??LiaoTianShi\src\baseDao\MoBan.java

?????文件????????430??2014-07-26?18:34??LiaoTianShi\src\bean\YongHu.java

?????文件?????????45??2014-07-26?18:33??LiaoTianShi\src\Dao\BaesDao.java

?????文件????????648??2014-07-26?18:59??LiaoTianShi\src\Dao\MessageDao.java

?????文件???????3512??2014-07-27?22:27??LiaoTianShi\src\servlet\JieShou.java

?????文件???????3246??2014-07-27?01:30??LiaoTianShi\src\servlet\Login.java

?????文件???????2590??2014-07-27?02:17??LiaoTianShi\WebRoot\index.jsp

?????文件?????282944??2014-06-10?14:27??LiaoTianShi\WebRoot\jq\jquery-1.11.0.js

?????文件???????1064??2014-07-27?22:31??LiaoTianShi\WebRoot\Login.jsp

?????文件????????325??2014-07-26?04:06??LiaoTianShi\WebRoot\meta-INF\context.xml

?????文件?????????39??2014-07-26?14:47??LiaoTianShi\WebRoot\meta-INF\MANIFEST.MF

?????文件????????963??2014-07-26?17:47??LiaoTianShi\WebRoot\MyJsp.jsp

?????文件????????962??2014-07-27?02:08??LiaoTianShi\WebRoot\t.jsp

?????文件???????2456??2014-08-01?15:32??LiaoTianShi\WebRoot\WEB-INF\classes\baseDao\MoBan.class

?????文件????????772??2014-08-01?15:32??LiaoTianShi\WebRoot\WEB-INF\classes\bean\YongHu.class

?????文件????????254??2014-08-01?15:32??LiaoTianShi\WebRoot\WEB-INF\classes\Dao\BaesDao.class

?????文件???????1697??2014-08-01?15:32??LiaoTianShi\WebRoot\WEB-INF\classes\Dao\MessageDao.class

?????文件???????3949??2014-08-01?15:32??LiaoTianShi\WebRoot\WEB-INF\classes\servlet\JieShou.class

?????文件???????3567??2014-08-01?15:32??LiaoTianShi\WebRoot\WEB-INF\classes\servlet\Login.class

?????文件?????445288??2014-06-06?19:27??LiaoTianShi\WebRoot\WEB-INF\lib\antlr-2.7.7.jar

?????文件??????43578??2014-06-06?19:27??LiaoTianShi\WebRoot\WEB-INF\lib\asm-3.3.jar

?????文件??????38275??2014-06-06?19:27??LiaoTianShi\WebRoot\WEB-INF\lib\asm-commons-3.3.jar

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