Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package application;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class ConnectDB {
- static ResultSet rs = null;
- String query;
- static Connection con = null;
- static Statement stmt = null;
- static String user = "SYSTEM";
- static String password = "system";
- static String url = "jdbc:oracle:thin:@localhost:1521/xe";
- public static void ConnectToDB() {
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
- con = DriverManager.getConnection(url,user,password);
- stmt = con.createStatement();
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }/*finally {
- try {
- rs.close();
- stmt.close();
- con.close();
- }catch(SQLException e) {
- e.printStackTrace();
- }*/
- }
- public static ResultSet ReadFromDB(String query) {
- try {
- rs = stmt.executeQuery(query);
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- /*try {if (rs!=null)
- while(rs.next()) {
- System.out.println("Etudiant id : " + rs.getInt(1) + "\t" + " - Nom : " + rs.getString(2) + " - prénom : " + rs.getString(3));
- }
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }*/
- return rs;
- }
- public static void CloseConnectionDB() {
- try {
- rs.close();
- stmt.close();
- con.close();
- }catch(SQLException e) {
- e.printStackTrace();
- }
- }
- public static void UpdateDB(String query) {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement