学步园

package com.zc.struts.db;</p> <p>import java.sql.Connection;<br /> import java.sql.DriverManager;<br /> import java.sql.ResultSet;<br /> import java.sql.SQLException;<br /> import java.sql.Statement;</p> <p>public class DBConnection {<br /> //ע����<br /> static{<br /> try{<br /> Class.forName("oracle.jdbc.driver.OracleDriver");<br /> }catch(Exception e)<br /> {<br /> e.printStackTrace();<br /> }<br /> }<br /> //��bl��<br /> public static Connection getConnection(){<br /> Connection connection = null;<br /> try {<br /> connection =DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.45:1521:orcl","shiqi","shiqi");<br /> } catch (SQLException e) {<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> }<br /> return connection;<br /> }<br /> public static void close(Connection con, Statement st, ResultSet rs) {<br /> try {<br /> if (rs != null) {<br /> rs.close();<br /> }<br /> } catch (SQLException e) {<br /> e.printStackTrace();<br /> } finally {<br /> try {<br /> if (st != null) {<br /> st.close();<br /> }<br /> } catch (SQLException e) {<br /> e.printStackTrace();<br /> } finally {<br /> try {<br /> con.close();<br /> } catch (SQLException e) {<br /> e.printStackTrace();<br /> }<br /> }<br /> }<br /> }<br /> }<br />