package?lv.bean;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

public?class?DBManager?{
	
	/**get?database?connection
	?*?@return
	?*?@throws?SQLException
	?*/
	public?static?Connection?getConnection（）?throws?SQLException?{
		try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;//“oracle.jdbc.driver.OracleDriver“//com.mysql.jdbc.Driver
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}

		Connection?con?=?DriverManager.getConnection（
				//“jdbc:mysql://localhost/bookge““root“““）;
				“jdbc:oracle:thin:@127.0.0.1:1521:ora2““neu““oracle“）;
				//“jdbc:mysql://localhost:3306/bookge“
				//user=root&password=123456&useUnicode=true&characterEncoding=gb2312“;

		return?con;
	}
	
	/**
	?*?@param?args
	?*/
	public?static?void?main（String[]?args）?throws?SQLException{
		//?TODO?Auto-generated?method?stub
		System.out.println（“--------------conn“+getConnection（））;

	}

	public?static?void?clearup（PreparedStatement?pstmt）?{
		if?（pstmt?!=?null）?{
			try?{
				pstmt.close（）;
			}?catch?（SQLException?se）?{
				se.printStackTrace（）;
			}
			pstmt?=?null;
		}
	}

	/**
	?*?Close?database?resource.
	?*?
	?*?@param?conn
	?*?@param?pstmt
	?*/
	public?static?void?clearup（Connection?conn?PreparedStatement?pstmt）?{
		if?（pstmt?!=?null）?{
			try?{
				pstmt.close（）;
			}?catch?（SQLException?se）?{
				se.printStackTrace（）;
			}
			pstmt?=?null;
		}

		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?se）?{
				se.printStackTrace（）;
			}
			conn?=?null;
		}

	}

	/**
	?*?Close?databse?resource.
	?*?
	?*?@param?conn
	?*?@param?pstmt
	?*?@param?rs
	?*/
	public?static?void?clearup（Connection?conn?PreparedStatement?pstmt
			ResultSet?rs）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?se）?{
				se.printStackTrace（）;
			}
			rs?=?null;
		}

		if?（pstmt?!=?null）?{
			try?{
				pstmt.close（）;
			}?catch?（SQLException?se）?{
				se.printStackTrace（）;
			}
			pstmt?=?null;
		}

		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?se）?{
				se.printStackTrace（）;
			}
			conn?=?null;
		}
	}

	/**
	?*?Close?databse?resource.
	?*?@param?pstmt
	?*?@param?rs
	?*/
	public?static?void?clearup（PreparedStatement?pstmt?ResultSet?rs）?{
		try{
			if（rs!=null）{
				rs.close（）;			
				rs=null;
			}
			if（pstmt!=null）{
				pstmt.close（）;
				pstmt=null;
			}
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}

	}

}

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

?????文件????????464??2008-12-27?10:21??JavaBean+Jsp+Servlet\.classpath

?????文件????????396??2008-12-27?10:05??JavaBean+Jsp+Servlet\.project

?????文件???????2648??2008-12-26?20:13??JavaBean+Jsp+Servlet\src\lv\bean\DBManager.java

?????文件????????756??2008-12-26?19:18??JavaBean+Jsp+Servlet\src\lv\bean\User.java

?????文件????????727??2008-12-27?09:57??JavaBean+Jsp+Servlet\src\lv\filter\CharacterEncodingFilter.java

?????文件???????1831??2008-12-27?09:59??JavaBean+Jsp+Servlet\src\lv\servlet\UserAddServlet.java

?????文件???????1558??2010-03-20?17:23??JavaBean+Jsp+Servlet\src\lv\servlet\UserAllServlet.java

?????文件???????1204??2008-12-27?16:06??JavaBean+Jsp+Servlet\src\lv\servlet\UserDeleteServlet.java

?????文件???????1722??2008-12-26?22:23??JavaBean+Jsp+Servlet\src\lv\servlet\UserQueryServlet.java

?????文件???????1635??2008-12-27?09:59??JavaBean+Jsp+Servlet\src\lv\servlet\UserUpdateServlet.java

?????文件????????119??2008-12-27?16:15??JavaBean+Jsp+Servlet\webapp\DB\users_tab.sql

?????文件???????2350??2008-12-28?15:59??JavaBean+Jsp+Servlet\webapp\default.css

?????文件???????8737??2008-12-28?16:08??JavaBean+Jsp+Servlet\webapp\images\57.gif

?????文件??????45937??2008-12-26?21:26??JavaBean+Jsp+Servlet\webapp\images\earth.gif

?????文件?????274446??2008-12-26?21:26??JavaBean+Jsp+Servlet\webapp\images\qingming2.jpg

?????文件????????339??2008-12-26?21:24??JavaBean+Jsp+Servlet\webapp\index.htm

?????文件???????1401??2008-12-27?16:38??JavaBean+Jsp+Servlet\webapp\left.html

?????文件???????2350??2008-12-28?16:23??JavaBean+Jsp+Servlet\webapp\lv-pages\default.css

?????文件???????1278??2008-12-28?16:05??JavaBean+Jsp+Servlet\webapp\lv-pages\userAdd.jsp

?????文件???????1209??2008-12-28?16:04??JavaBean+Jsp+Servlet\webapp\lv-pages\userAll.jsp

?????文件???????1126??2008-12-28?16:05??JavaBean+Jsp+Servlet\webapp\lv-pages\userUpdate.jsp

?????文件????????552??2008-12-26?21:25??JavaBean+Jsp+Servlet\webapp\right.html

?????文件????????310??2008-12-26?21:28??JavaBean+Jsp+Servlet\webapp\top.html

?????文件???????2637??2010-03-24?17:58??JavaBean+Jsp+Servlet\webapp\WEB-INF\classes\lv\bean\DBManager.class

?????文件???????1264??2010-03-24?17:58??JavaBean+Jsp+Servlet\webapp\WEB-INF\classes\lv\bean\User.class

?????文件???????1215??2010-03-24?17:58??JavaBean+Jsp+Servlet\webapp\WEB-INF\classes\lv\filter\CharacterEncodingFilter.class

?????文件???????2882??2010-03-24?17:58??JavaBean+Jsp+Servlet\webapp\WEB-INF\classes\lv\servlet\UserAddServlet.class

?????文件???????2273??2010-03-24?17:58??JavaBean+Jsp+Servlet\webapp\WEB-INF\classes\lv\servlet\UserAllServlet.class

?????文件???????1958??2010-03-24?17:58??JavaBean+Jsp+Servlet\webapp\WEB-INF\classes\lv\servlet\UserDeleteServlet.class

?????文件???????2807??2010-03-24?17:58??JavaBean+Jsp+Servlet\webapp\WEB-INF\classes\lv\servlet\UserQueryServlet.class

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