標籤:sse 2.0 print res instant 圖片 安裝 result system
1.串連代碼
package Util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class DBUtil { public static void main (String args[]){ try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } String user = "system"; String password = "密碼"; String url = "jdbc:oracle:thin:@localhost:1521:orcl"; Connection connection = null; try { connection = DriverManager.getConnection(url,user,password); System.out.println("串連成功"); } catch (SQLException e) { System.out.println("串連失敗"); e.printStackTrace(); } } public static void close(Connection connection ) { try { if (connection != null) { connection.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void close(PreparedStatement preparedStatement ) { try { if (preparedStatement != null) { preparedStatement.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void close(ResultSet resultSet ) { try { if (resultSet != null) { resultSet.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
2.載入驅動
bulid path->Add External JARs 找到Oracle安裝路徑下的app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojbc6_g.jar
3.在WEB-INT 下lib 複製一個ojbc6_g.jar
串連Oracle資料庫