JAVA串連ORACLE資料庫的步驟

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 TestJDBC {</p><p>public static void main(String[] args) {<br />Connection conn = null;<br />ResultSet rs = null;<br />Statement state = null;<br />try {<br />Class.forName("oracle.jdbc.OracleDriver");<br />conn = DriverManager.getConnection("jdbc:oracle:" +<br />"thin:@127.0.0.1:1521:ORCL","scott","tiger");<br />state = conn.createStatement();<br />rs = state.executeQuery("select * from dept");<br />while(rs.next()){<br />String s = rs.getString("dname");<br />System.out.println(s.toLowerCase());<br />}<br />} catch (ClassNotFoundException e) {<br />e.printStackTrace();<br />} catch (SQLException e) {<br />e.printStackTrace();<br />} finally {<br />try {<br />if(rs != null)<br />rs.close();<br />if(state != null)<br />state.close();<br />if(conn != null)<br />conn.close();<br />} catch (SQLException e) {<br />e.printStackTrace();<br />}</p><p>}</p><p>}</p><p>}<br />