package controller;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DatabaseController {

	public static Connection con;
	public static Statement stmt;

	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

	public void openConnection () {

		try {
		Driver d = new oracle.jdbc.driver.OracleDriver();
		Properties p = new Properties();
		p.put("user", "wpr");
		p.put("password", "1234");

		con = d.connect("jdbc:oracle:thin:@localhost:1521:xe",p);

		stmt = con.createStatement();

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}