package com.bookapp.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class ModelDAO {
	static Connection connection;
	public static Connection openConnection(){
		String driverName ="oracle.jdbc.driver.OracleDriver";
		String url ="jdbc:oracle:thin:@localhost:1521:xe";
		String username="system";
		String password="system";
		String sql = "create table Book(title varchar(20), bookid integer, price number, author varchar(20), category varchar(20), primary key(bookid)";

		try{
			Class.forName(driverName); //linking and loading the driver
			//establishing connection...
			connection = DriverManager.getConnection(url,username,password);
			//create a statement object
			PreparedStatement ps = connection.prepareStatement(sql);

			ps.execute(sql);
			}


		catch (Exception e){
			e.printStackTrace();

		}
		return connection;
		}

		public static void closeConnection(){
			try{
				if(connection!=null)
					connection.close();

			}catch(SQLException e)
			{
				e.printStackTrace();
			}
		}



	}