This is what I have so far. The database can just be made up. package edi.

I need help on this badly! This is what I have so far. As much help as you can give will be greatly appreciated, please just let me know how far you got. The database can just be made up.

package edi.iupui.cit214;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class JDBCBasic {

private static final String SELECT_FROM_CUSTOMER = "select * from

customer";

public static void main(String[] args) throws SQLException {

Connection connection = null;

try {

loadDriver();

connection = getConnection();

//selectFromCustomerTable(connection);

insertToCustomerTable(connection);

} finally {

connection.close();

}

}

private static void selectFromCustomerTable(Connection connection)

throws SQLException {

PreparedStatement prepareStatement =

connection.prepareStatement(SELECT_FROM_CUSTOMER);

ResultSet resultSet = prepareStatement.executeQuery();

System.out.println("================================================

========================");

System.out.println("CUSTOMER");

System.out.println("================================================

========================");

while (resultSet.next()) {

// , CUSTOMER_NAME, STREET, CITY, STATE, ZIP,

BALANCE, CREDIT_LIMIT, REP_NUM

String data =

resultSet.getString("CUSTOMER_NUM") + ", " +

resultSet.getString("CUSTOMER_NAME");

System.out.println(data);

}

System.out.println("================================================

========================");

}

private static void insertToCustomerTable(Connection connection)

throws SQLException {

PreparedStatement prepareStatement =

connection.prepareStatement(" INSERT INTO CUSTOMER " +

" VALUES " +

" ('104','Cool Sports','2837

Greenway','Fillmore','FL','33336',6550.00,7500.00,'20') ");

int result = prepareStatement.executeUpdate();

if (result == 1) {

System.out.println("Successfully inserted.");

}

else {

System.out.println("Failed to insert.");

}

}

private static Connection getConnection() {

Connection connection = null;

try {

connection = DriverManager

.getConnection("jdbc:mysql://localhost/premiere?" +

"user=root&password=mysql214");

System.out.println("Database connection

acquired");

} catch (SQLException ex) {

// handle any errors

System.out.println("SQLException: " +

ex.getMessage());

System.out.println("SQLState: " +

ex.getSQLState());

System.out.println("VendorError: " +

ex.getErrorCode());

}

return connection;

}

private static void loadDriver() {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

System.out.println("Driver Loaded");

} catch (Exception ex) {

ex.printStackTrace();

}

}

}

Instructions!!

The movie catalog viewing and rating component allows any user (no login necessary) to perform the following:

1.      Search and view for movies. Searching capabilities could be limit to the title of the movie.

2.      Add rating to a movie. This includes rating scale 1 to 10 and a comment section.

3.      (This could be another bonus functionality) Ability to select existing comment and like it. The system should display the number for likes a comment has received.

How to Calculate the Rating

Rating calculation can be as simple as average of all the rates given movie has received.

Implementation Details

Command line Menu:

Main Menu:

1)     Admin

2)     User

3)     Exit

User could select an option from this list. If user select 1, it should display Admin Menu with the following options:

Admin Menu:

1)     Add new movie

2)     Search and update movie

3)     Search and delete

Implements these options for admin personnel.

In main menu, if user select 2 from the Main Menu it should display user menu. User menu should contains the following options:

User Menu:

1)     Search movie

2)     Rate movie

3)     Add comments

Implement these options for user activities.

Note

: Make sure you implement the project by following object oriented design paradigm 

The movie catalog viewing and rating component allows any user (no login necessary) to perform the following:

1.      Search and view for movies. Searching capabilities could be limit to the title of the movie.

2.      Add rating to a movie. This includes rating scale 1 to 10 and a comment section.

3.      (This could be another bonus functionality) Ability to select existing comment and like it. The system should display the number for likes a comment has received.

How to Calculate the Rating

Rating calculation can be as simple as average of all the rates given movie has received.

Implementation Details

Command line Menu:

Main Menu:

1)     Admin

2)     User

3)     Exit

User could select an option from this list. If user select 1, it should display Admin Menu with the following options:

Admin Menu:

1)     Add new movie

2)     Search and update movie

3)     Search and delete

Implements these options for admin personnel.

In main menu, if user select 2 from the Main Menu it should display user menu. User menu should contains the following options:

User Menu:

1)     Search movie

2)     Rate movie

3)     Add comments

Implement these options for user activities.