Description
See assignment attached.
1.Create a Java Project in Eclipse and set up the JDBC Driver.
2.Create the class in the lab to access the DB via JDBC.
3.Add a method to the class to insert a new student with the following attributes. This method should take all columns in as parameters: 98999, Charlie, Comp Sci., 12
4.Create a Java class that takes a command line parameter to delete a student
5.Create a class that write out the contents of the Instructor table to a comma separated file.
Unformatted Attachment Preview
These might be helpful:
http://db-book.com/ - where the database table examples came from
CSC
1. Create a Java Project in Eclipse and set up the JDBC Driver.
import java.sql.*;
public class maindb {
public static void main(String[] args) {
Connection conn;
Statement stat;
ResultSet rs;
String connectionURL = "csc540.cg3nl8ebpfzx.us-east1.rds.amazonaws.com";
String port = "5432";
String dbName ="csc540";
String userName = "csc540user";
String password = "password";
String jdbcUrl = "jdbc:postgresql://" + connectionURL +
":" + port + "/" + dbName + "?user=" + userName + "&password=" +
password;
try{
Class.forName("org.postgresql.Driver").newInstance();
conn = DriverManager.getConnection(jdbcUrl);
stat = conn.createStatement();
stat.executeQuery("select * from student");
System.out.println("I made it");
}
catch (Exception e)
{
}
}
}
2. Create the class in the lab to access the DB via JDBC.
3. Add a method to the class to insert a new student with the following attributes. This method
should take all columns in as parameters:
98999, Charlie, Comp Sci., 122
4. Create a Java class that takes a command line parameter to delete a student
5. Create a class that write out the contents of the Instructor table to a comma separated file.
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Really useful study material!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
I have 2 questions to answer in javascript.
1)Alice has an even number of N beads, and each bead has a number from 1 to N painted on it. She would like to make a neck...
Printing Chess board using NAMS
Please if you are not a programmer or computer scientist, do not send me anythingThe system that we are using is nasm. the...
Java Question
Assignment 2
Due: Monday 2/22/2021 11:59pm
Contents
Program
Warning!
Testing
2
...........................................
University of Arizona Encryption Pseudocode Matlab Coding Task
...
Harvard University GPA Calculator Program Python Project
Please write a program that calculate GPA with Python.
...
Develop a console program
The
first step in writing a software application is to determine the requirements.
There is no value in writing a pr...
Analysis Of Heart Disease 040026.chep 2
We start by displaying the data using code below.Then analyze the data and fit the different algorithms of my_data ...
Completed Explanations
These two lines initialize the respective packages in R. dplyr provides many tools for data manipulation such as ‘filter...
Cheapeatz Finalpaper Final 4 21
Cheap Eatz! is an application that uses the GPS service of any mobile device to locate casual dining restaurants that offe...
