Question

Can you please upload the video to step by step with eclipse and mysql workbench.please................................

Part 1

Design the database using the ER approach. Then using Java and SQL, implement the following

functionality:

1. Implement a button called “Initialize Database” . When a user clicks it, all necessary tables will be created (or recreated) automatically, with each table be populated with at least 10 tuples so that each query below will return some results. All students should use the database name “sampledb”, username “john”, and password “pass1234”.

2. Create the functionality to assign three reviewers to a paper.

Your system must be web-based. Some simple GUI interfaces are required for each functionality. All functionality must be performed via the interface of your system, direct SQL statement execution via any tools (MySQL workbench) is not allowed.

How to submit:

All files (source codes, class files, bat, and txt) should be contained in a war file called

csc4710_xx_part1.war or csc4710_xx_part2.war which should be uploaded to Canvas.

The following files must be contained in the submission:



Readme.txt, which lists the ids, names, emails of your group members.

Detailed instructions regarding how to compile and run your program and

user’s guide are part of this file.

Answer 1

1 import java.awt.*; 2 import java.sql.*; 3 import java.awt.event.*; 4 import javax.swing.*; 5 import java.util.Vector; 6 import javax.swing.table.DefaultTableModel; 8 public class confereencepaper extends JFrame implements ActionListener t 10 JFrame jframe1; 11 JComboBox JComb; 12 JLabel jlabela, jlabelb, labeld; 13 14 JButton butt, butt2; 15 16 Connection con 17 18 ResultSet rese, rs1; 19 20 Statement s1, st1; 22 PreparedStatement pst; 23 24 String ids; 25 26 static JTable tab; 27 28 String[] cfields (Papid , "FU" , "Lu', "umall'," tilte", "adstract" , "pdf" };

emp.sql

create table paperconf
(
    papid int primary key autoincrement, FU varchar2(20), Lu varchar2(20), umail varchar2(30),
    tilte varchar2(20), adstract varchar2(20), pdf varchar2(20), pcid int forien key references pc
);

create table pc
(
    pcid int autoincrement, report id int autoincrement, reviewrep varchar2(80), papid int forien key references papercof );

Then the java program to be run which works as the requirment: first give Initialize Database button to fetch

the database then give user interface to insert the query to the database.

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;

public class confereencepaper extends JFrame implements ActionListener {

JFrame jframe1;
JComboBox JComb;
JLabel jlabela, jlabelb, labeld;

JButton butt, butt2;

Connection con;

ResultSet res0, rs1;

Statement s1, st1;

PreparedStatement pst;

String ids;

static JTable tab;

String[] cfields = {papid , "FU" , "Lu" , "umail" ," tilte", "adstract" , "pdf" };

String from;

Paperdisplay() {

jlabela = new JLabel("Coference paper submition");

jlabela.setForeground(Color.blue);

jlabela.setFont(new Font("Serif", Font.BOLD, 20));

//l1 = new JLabel("Select name");

butt = new JButton("Initialize Database");
  

jlabela.setBounds(100, 50, 350, 40);

jlabelb.setBounds(75, 110, 75, 20);

butt.setBounds(150, 150, 150, 20);
butt.addActionListener(this);
  

  
  

setTitle("Fetching paper detailis DataBase");

setLayout(null);

setVisible(true);

setSize(500, 500);

setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);

add(jlabela);

add(jlabelb);;

add(butt);

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

con = DriverManager.getConnection("sampledb", "john", "pass1234");

s1 = con.createStatement();

res0 = s1.executeQuery("select * from conference");

Vector v = new Vector();

while (res0.next()) {

ids = res0.getString(1);

v.add(ids);

}

JComb = new JComboBox(v);

JComb.setBounds(150, 110, 150, 20);

add(JComb);

s1.close();

res0.close();

} catch (Exception e) {

}

}
labeld = new JLabel("select paper id");

butt2 = new JButton("submit");
labeld.setBounds(100, 50, 350, 40);

labeld.setBounds(75, 110, 75, 20);

butt2.setBounds(150, 150, 150, 20);

butt2.addActionListener(this);
setTitle("Fetching paper detailis DataBase");

setLayout(null);

setVisible(true);

setSize(500, 500);

setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);

add(jlabela);

add(jlabelb);;

add(butt);

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

con = DriverManager.getConnection("sampledb", "john", "pass1234");

s1 = con.createStatement();

  
res0 = s1.executeQuery("select uname from emp");

Vector v = new Vector();

while (res0.next()) {

ids = res0.getString(1);

v.add(ids);

}

JComb = new JComboBox(v);

JComb.setBounds(150, 110, 150, 20);

add(JComb);

s1.close();

res0.close();

} catch (Exception e) {

}

}

public void actionPerformed(ActionEvent ae) {

if (ae.getSource() == butt) {

showTableData();

}

}

public void showTableData() {

jframe1 = new JFrame("Detail of all the papers");

jframe1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jframe1.setLayout(new BorderLayout());

//TableModel tm = new TableModel();

DefaultTableModel model = new DefaultTableModel();

model.setColumnIdentifiers(fields);

//DefaultTableModel model = new DefaultTableModel(tm.getData1(), tm.getColumnNames());

//table = new JTable(model);

tab = new JTable();

tab.setModel(model);

tab.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);

tab.setFillsViewportHeight(true);

JScrollPane scroll = new JScrollPane(tab);

scroll.setHorizontalScrollBarPolicy(

JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);

scroll.setVerticalScrollBarPolicy(

JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED);

from = (String) JComb.getSelectedItem();

//String textvalue = textbox.getText();

String paperid = "";

String authername = "";
String affiliation = "";
String email = "";
String title = "";
String abstracts = "";
String pdfatt = "";

String reviewreport = "";

try {

pst = con.prepareStatement("select * from emp where UNAME='" + from + "'");

ResultSet res0 = pst.executeQuery();

int i = 0;

if (res0.next()) {

uname = res0.getString("papid");

email = res0.getString("Fu");

pass = res0.getString("Lu");

cou = res0.getString("email");

model.addRow(new Object[]{uname, email, pass, cou});

i++;

}

if (i < 1) {

JOptionPane.showMessageDialog(null, "No Record Found", "Error", JOptionPane.ERROR_MESSAGE);

}

if (i == 1) {

System.out.println(i + " Record Found");

} else {

System.out.println(i + " Records Found");

}

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, ex.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);

}

jframe1.add(scroll);

jframe1.setVisible(true);

jframe1.setSize(400, 300);

}

public static void main(String args[]) {

new Paperdisplay();

}

}