Answered You can hire a professional tutor to get the answer.
This is what I have so far. package edi.iupui.cit214; import java.Connection; import java.DriverManager; import java.PreparedStatement; import java....
I need help on this badly! This is what I have so far.
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!!
