ISYS 303 - GUI

Question 1

how to set things visible/invisible

Answer 1

.setVisible(boolean: true or false);

EX: GreenPanel.setVisible(true);

Question 2

set cursor in specific place (i.e textbox)

Answer 2

nameoftextbox.requestFocus();

EX: txtYourName.requestFocus();

Question 3

convert double to a string

or anything to string

Answer 3

String.valueOf(NameofVariable.getSelectedItem());

String.valueOf(cmbIS100.getSelectedItem()),

Question 4

convert string to a double
(or anything to double)
or integer

Answer 4

Double.parseDouble(NameofVariable.getText())
Integer.parseInt(NameofVariable.getText())

Double.parseDouble(txtIS100.getText())

Question 5

DecimalFormat

Answer 5

DecimalFormat oDF = new DecimalFormat(#.00);
String sToHoldDecimal = oDF.format(whatyouwanttoformat)

GPALabel.setText(oDF.format(dFinGPA))

Question 6

set Textbox/Label

Answer 6

NameOfTxtBox/Lbl.setText(“anythinghere”);

Question 7

set combo box

Answer 7

NameOfCmb.setSelectedIndex(#);

**the # starts with 0, and ends with as many options as your put

Question 8

set jDialog form Visible/Not Visible

Answer 8

private void btnCloseActionPerformed(java.awt.event.ActionEvent evt) {
this.setVisible(false);
}

This statement tells the form that when the Close button is clicked it then the form object will change its visibility to false (thus hiding it)

Question 9

String sSQL

Answer 9

This variable will hold the SQL statement. It is not really needed but I am showing that you could dynamically build a SQL statement and store it to a variable and then use that variable within your program to access the data

Question 10

try{

Answer 10

All of the source code to access the database is protected within a try statement. That way if something goes wrong, Java can try to recover as needed.

Question 11

String driver = “net.ucanaccess.jdbc.UcanaccessDriver”;

Class.forName(driver);

Answer 11

The Class.forName(driver) statement specifies a specific driver that Java will use within the program. This statement indicates that Java will be using the UcanaccessDriver within the source code that follows

Question 12

Connection con = DriverManager.getConnection(“jdbc:ucanaccess://C:/Test/GoldStarHR.accdb”);

Answer 12

The Connection object informs Java which database file to use and how to access it. The jdbc (which stands for Java database connectivity) uses the ucanaccess driver

Question 13

Statement stmt = con.createStatement();

Answer 13

The Statement object connects the Connection object with a statement that will be executed and
specified later. It will be the actual SQL statement

Question 14

sSQL = “Select SSN, Last_Name, First_Name, Hire_Date FROM Employee”;

Answer 14

This is the string variable set up earlier to hold the SQL statement

Question 15

ResultSet rs = stmt.executeQuery(sSQL);

Answer 15

The ResultSet object contains the data returned from the Statement object attached to the Connection object using the SQL statement in the sSQL variable. So in essence, this runs the SQL statement and returns all of the records from the Employee table showing the SSN, Last_Name, First_Name, and Hire_Date columns

Question 16

DefaultTableModel model = (DefaultTableModel)tblEmployee.getModel();

Answer 16

The DefaultTableModel object indicates the storage space for the data to be used. Remember that the model represents the data. This statements says to create a model object and base it up on the tblEmployee JTable object on the form

Question 17

model.setRowCount(0);

Answer 17

This statement says to highlight the first row of data

Question 18

if (rs != null)
while ( rs.next() ){
model.addRow(new Object[]{
rs.getString("SSN"), 
rs.getString("Last_Name"),
rs.getString("First_Name"),
rs.getString("Hire_Date")
}); 
}

Answer 18

These statements says If there is a row in the result set called rs While there is a row of data Add a new row of data to the new model object using the columns specified IOW, this will check to see if there is data and as long as there IS data, extract the SSN, Last_Name,First_Name, and Hire_Date from the table and add it to the model for the JTable object.

Question 19

stmt. close();

con. close();

Answer 19

Then we close the resources we created

Question 20

char charAt

Answer 20

char charAt = sNameTogether.charAt(iCount);
//finds the letter in the names from the counter

String valueOf = String.valueOf(charAt);
//converts the found letter to a string

Question 21

Combo boxes

Answer 21

cmbIS100.setSelectedIndex(0); 
//resets the combo box to "A"

cmbIS100.getSelectedItem())

Question 22

Text boxes

Answer 22

txtIS100.getText()

Question 23

Checkboxes

Answer 23

cbHTAdv.setSelected(false);

cbHTAdv.isSelected()

Question 24

ListBoxes

Answer 24

confTeamList.getModel().getSize()

confTeamList.getModel().getElementAt(iCounter).toString()