Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package DatabaseAssignment2;
- import java.io.FileInputStream;
- import java.io.FileNotFoundException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.sql.SQLException;
- import java.util.Scanner;
- import oracle.jdbc.*;
- import oracle.net.aso.s;
- import oracle.xdb.XMLType;
- public class DatabaseAssignment2 {
- private static String username, password, hostname, serviceName;
- private static Connection conn;
- private static Scanner userInput;
- public static void main(String[] args) throws SQLException {
- // TODO code application logic here
- loadOracleJdbcDriver();
- connectToServer(username, password, hostname, serviceName);
- //Statement s = conn.createStatement();
- createFilmTable();
- }
- public DatabaseAssignment2() {
- }
- public static void loadOracleJdbcDriver() {
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- } catch (ClassNotFoundException e) {
- System.out.println("Error -" + e.toString());
- System.out.println("Could not load the driver");
- }
- }
- public static void connectToServer(String username, String password,
- String hostname, String serviceName) throws SQLException {
- try {
- Scanner sc = new Scanner(System.in);
- System.out.println("Type userid, password, hostname, servicename: ");
- username = sc.next();
- password = sc.next();
- hostname = sc.next();
- serviceName = "orcl";
- System.out.println(username + " " + password + " " + hostname);
- System.out.println("Connecting to Database...");
- // userid, password and hostname are obtained from the console
- //try-with-resources
- conn = DriverManager.getConnection("jdbc"
- + ":oracle:thin:"
- + username + "/" + password + "@" + hostname + ":1521/"
- + serviceName);
- conn.setAutoCommit(false);
- } catch (SQLException e) {
- System.out.println("Error + " + e.toString());
- System.out.println("Connection Failure");
- }
- }
- public static void createFilmTable() throws SQLException {
- Statement s = conn.createStatement();
- s.executeUpdate("DROP TABLE ASS2_FILM");
- System.out.println("Table Dropped");
- s.executeUpdate("CREATE TABLE ASS2_FILM(fnum VARCHAR(20) " +
- "CONSTRAINT fnum_PK PRIMARY KEY, " +
- " film SYS.XMLTYPE)");
- System.out.println("Made");
- }
- public static void populateFilmTable() {
- }
- public static void showTitleOfAllFilms() {
- }
- public static void showTitleOfAllFilmWithoutTitleTags() {
- }
- public static void showNamesOfActorsWhoAppearedInGodfather() {
- }
- public static void showTitleAndYearOfAllCrimeFilms() {
- }
- public static void showTitleAndYearOfAllFilmsMarlonBrando() {
- }
- public static void showOneDirectorFilms() {
- }
- public static void showTitleAndNamesMoreThanOneDirector() {
- }
- public static void ShowTheNamesOfActorsAndSoleDirectorOfSameFilm() {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement