public void changeLAF(int iLAFIndex) {
try {
// Change LAF
if (iLAFIndex >= marrLaf.length) iLAFIndex = marrLaf.length - 1;
UIManager.setLookAndFeel(
(LookAndFeel) Class.forName(marrLaf[iLAFIndex].getClassName()).newInstance());
// Update UI
((JMenuItem) mvtLAFItem.elementAt(iLAFIndex)).setSelected(true);
SwingUtilities.updateComponentTreeUI(this);
SwingUtilities.updateComponentTreeUI(mnuMain);
WindowManager.updateLookAndField();
// Store config
try {
Hashtable prt = Global.loadHashtable(Global.FILE_CONFIG);
prt.put("LAF", String.valueOf(iLAFIndex));
Global.storeHashtable(prt, Global.FILE_CONFIG);
} catch (Exception e) {
}
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
private void isEdit(Boolean isEdit) {
if (isEdit) {
try {
Connection con = FrameLogin.getConnect();
String sql = "SELECT * FROM Persons WHERE personId = " + Id;
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
if (rs.first()) {
String firstname = rs.getString("FirstName");
String lastname = rs.getString("LastName");
String cellphone = rs.getString("CellPhoneNo");
String homephone = rs.getString("HomePhoneNo");
String gradyear = rs.getString("Graduation Year");
String Gender = rs.getString("Gender");
firstName.setText(firstname);
lastName.setText(lastname);
cellPhone.setText(cellphone);
homePhone.setText(homephone);
gradYear.setText(gradyear);
gender.setSelectedItem(Gender);
jLabel7.setVisible(false);
studentId.setVisible(false);
} else {
MessageBox.infoBox("Error: ID not found", "Error");
}
} catch (Exception e) {
MessageBox.infoBox(e.toString(), "Error in isEdit");
}
}
FrameLogin.closeConnect();
}
/**
* Load a file of a particular type. It's a pretty standard helper function, which uses DarwinCSV
* and setCurrentCSV(...) to make file loading happen with messaging and whatnot. We can also
* reset the display: just call loadFile(null).
*
* @param file The file to load.
* @param type The type of file (see DarwinCSV's constants).
*/
private void loadFile(File file, short type) {
// If the file was reset, reset the display and keep going.
if (file == null) {
mainFrame.setTitle(basicTitle);
setCurrentCSV(null);
return;
}
// Load up a new DarwinCSV and set current CSV.
try {
setCurrentCSV(new DarwinCSV(file, type));
} catch (IOException ex) {
MessageBox.messageBox(
mainFrame,
"Could not read file '" + file + "'",
"Unable to read file '" + file + "': " + ex);
}
// Set the main frame title, based on the filename and the index.
mainFrame.setTitle(
basicTitle
+ ": "
+ file.getName()
+ " ("
+ String.format("%,d", currentCSV.getRowIndex().getRowCount())
+ " rows)");
}
private void updateTabBar(Vector vtThread) {
pnlThread.removeAll();
for (int iThreadIndex = 0; iThreadIndex < vtThread.size(); iThreadIndex++) {
try {
Vector vtThreadInfo = (Vector) vtThread.elementAt(iThreadIndex);
PanelThreadMonitor mntTemp = new PanelThreadMonitor(channel);
String strThreadID = (String) vtThreadInfo.elementAt(0);
String strThreadName = (String) vtThreadInfo.elementAt(1);
int iThreadStatus = Integer.parseInt((String) vtThreadInfo.elementAt(2));
mntTemp.setThreadID(strThreadID);
mntTemp.setThreadName(strThreadName);
mntTemp.setThreadStatus(iThreadStatus);
showResult(mntTemp.txtMonitor, (String) vtThreadInfo.elementAt(3));
mntTemp.addPropertyChangeListener(this);
pnlThread.add(strThreadName, mntTemp);
mntTemp.updateStatus();
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
Skin.applySkin(this);
}
public static void closeConnect() {
try {
con.close();
} catch (SQLException e) {
MessageBox.infoBox(e.toString(), "Error in closeConnect");
}
}
void lookUpTaxonID(String taxonID) {
URI url;
try {
// We should look up the miITIS_TSN status, but since we don't
// have any options there ...
url =
new URI(
"http://www.itis.gov/servlet/SingleRpt/SingleRpt?search_topic=TSN&search_value="
+ taxonID);
} catch (URISyntaxException e) {
throw new RuntimeException(e);
}
try {
Desktop desktop = Desktop.getDesktop();
desktop.browse(url);
} catch (IOException e) {
MessageBox.messageBox(
mainFrame,
"Could not open URL '" + url + "'",
"The following error occurred while looking up URL '" + url + "': " + e.getMessage(),
MessageBox.ERROR);
}
}
void searchName(String nameToMatch) {
URI url;
try {
// We should look up the miITIS_TSN status, but since we don't
// have any options there ...
url = new URI("http", "www.google.com", "/search", "q=" + nameToMatch);
// I think the URI handles the URL encoding?
} catch (URISyntaxException e) {
throw new RuntimeException(e);
}
try {
Desktop desktop = Desktop.getDesktop();
desktop.browse(url);
} catch (IOException e) {
MessageBox.messageBox(
mainFrame,
"Could not open URL '" + url + "'",
"The following error occurred while looking up URL '" + url + "': " + e.getMessage(),
MessageBox.ERROR);
}
}
////////////////////////////////////////////////////////
// Purpose: send message stop server
// Author: TrungDD
// Date: 10/2003
////////////////////////////////////////////////////////
public void stopServer() {
if (MessageBox.showConfirmDialog(
this,
MonitorDictionary.getString("Confirm.Shutdown"),
Global.APP_NAME,
MessageBox.YES_NO_OPTION)
== MessageBox.NO_OPTION) return;
try {
DDTP request = new DDTP();
request.setRequestID(String.valueOf(System.currentTimeMillis()));
channel.sendRequest("ThreadProcessor", "closeServer", request);
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
public void changePassword() {
try {
DialogChangePassword dlgPass = new DialogChangePassword(this, channel);
if (dlgPass != null) WindowManager.centeredWindow(dlgPass);
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
private void submitButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_submitButtonActionPerformed
// TODO add your handling code here:
Connection con = FrameLogin.getConnect();
String SQLInsert =
"INSERT INTO `2761DB`.`Persons` (`FirstName`, `LastName`, `CellPhoneNo`, `HomePhoneNo`, "
+ "`SchoolId`, `Graduation Year`, `Gender`) VALUES ('"
+ firstName.getText()
+ "', '"
+ lastName.getText()
+ "', '"
+ cellPhone.getText()
+ "', '"
+ homePhone.getText()
+ "', '"
+ studentId.getText()
+ "', '"
+ gradYear.getText()
+ "', '"
+ (String) (gender.getSelectedItem())
+ "');";
String SQLUpdate =
"UPDATE `2761DB`.`Persons` SET `FirstName` = '"
+ firstName.getText()
+ "', `LastName` = '"
+ lastName.getText()
+ "', `CellPhoneNo` = ' "
+ cellPhone.getText()
+ "', `HomePhoneNo` = '"
+ homePhone.getText()
+ "', `Graduation Year` = '"
+ gradYear.getText()
+ "', `Gender` = '"
+ (String) (gender.getSelectedItem())
+ "' WHERE `PersonId` = '"
+ Id
+ "';";
// UPDATE `2761DB`.`Persons` SET `FirstName`='Robbie', `LastName`='Tacescu', `CellPhoneNo`='',
// `HomePhoneNo`='559300', `SchoolId`='15648916', `Graduation Year`='6545', `Gender`='males'
// WHERE
// `PersonId`='42';
try {
if (isEdit) {
Statement stmt = con.createStatement();
// System.out.println(SQLUpdate);
stmt.executeUpdate(SQLUpdate);
} else {
Statement stmt = con.createStatement();
// System.out.println(SQLInsert);
stmt.executeUpdate(SQLInsert);
}
} catch (SQLException err) {
MessageBox.infoBox(err.toString(), "Error in AddUserForm submitButton");
}
FrameLogin.closeConnect();
this.dispose();
} // GEN-LAST:event_submitButtonActionPerformed
private void formWindowClosing(
java.awt.event.WindowEvent evt) { // GEN-FIRST:event_formWindowClosing
// TODO add your handling code here:
Connection con = getConnect();
try {
// con.close();
} catch (Exception err) {
MessageBox.infoBox(err.toString(), "Error closing connection in formWindowClosed");
}
} // GEN-LAST:event_formWindowClosing
public PanelThreadManager() {
try {
Global.APP_NAME = ThreadConstant.APP_NAME;
Global.APP_VERSION = ThreadConstant.APP_VERSION;
jbInit();
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
public static boolean isId(String id) {
boolean isInt = true;
try {
Integer.parseInt(id);
} catch (Error er) {
isInt = false;
MessageBox.infoBox("Error: ID incorrect", "Error");
}
return isInt;
}
private void onClick() {
try {
DialogTabularParameter dlg =
new DialogTabularParameter(cmpCaller, mbModal, mstrTitle, mvtDefinition, mvtValue);
// DialogTableParameter dlg = new
// DialogTableParameter(cmpCaller,mbModal,mstrTitle,mvtDefinition,mvtValue);
WindowManager.centeredWindow(dlg);
cmpCaller.repaint();
setValue(mvtValue);
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
private void logIn(int personId) {
Connection con = getConnect();
try {
// MessageBox.infoBox("You have successfully logged in", "Login");
// INSERT INTO LogInOut (PersonId, TimeIn) VALUES (1, NOW())
String SQLLogin = "******" + personId + ", NOW())";
Statement stmtLogin = con.createStatement();
stmtLogin.executeUpdate(SQLLogin);
Update_table();
} catch (SQLException err) {
MessageBox.infoBox(err.toString(), "Error");
}
closeConnect();
}
private void manualOutActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_manualOutActionPerformed
String strId = manualInput.getText();
if (isId(strId)) {
int id = getId();
if (isIdFound(id)) {
int personId = getPersonId(id);
if (!isLoggedIn(id)) {
MessageBox.infoBox("Error: Already Logged In", "Error");
} else {
logOut(personId);
manualInput.setText("");
}
}
}
} // GEN-LAST:event_manualOutActionPerformed
public void manageThreads() {
try {
DDTP request = new DDTP();
request.setRequestID(String.valueOf(System.currentTimeMillis()));
DDTP response = channel.sendRequest("ThreadProcessor", "manageThreadsLoad", request);
if (response != null) {
DialogThreadManager dlg =
new DialogThreadManager(this, channel, response.getVector("vtTableData"));
dlg.setComboStartupType(response.getVector("vtStartupType"), "");
WindowManager.centeredWindow(dlg);
}
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
public void loadThread(String threadID, String threadName, String threadStatus) {
try {
PanelThreadMonitor mntTemp = new PanelThreadMonitor(channel);
int iThreadStatus = Integer.parseInt(threadStatus);
mntTemp.setThreadID(threadID);
mntTemp.setThreadName(threadName);
mntTemp.setThreadStatus(iThreadStatus);
mntTemp.addPropertyChangeListener(this);
pnlThread.add(threadName, mntTemp);
mntTemp.updateStatus();
Skin.applySkin(mntTemp);
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
private synchronized void closeAll() {
try {
// Close all child window
WindowManager.closeAll();
// Remove all child component
pnlThread.setVisible(false);
pnlUser.setVisible(false);
pnlThread.removeAll();
clearAll(txtBoard);
tblUser.setData(new Vector());
Thread.sleep(500);
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
}
}
private void logOut(int personId) {
Connection con = getConnect();
try {
// MessageBox.infoBox("You have successfully logged out", "Logout");
// UPDATE LogInOut SET TimeOut = NOW() WHERE PersonId = 1 AND TimeOut IS NULL
String SQLLogin =
"******"
+ personId
+ " AND TimeOut IS NULL";
Statement stmtLogin = con.createStatement();
stmtLogin.executeUpdate(SQLLogin);
Update_table();
} catch (SQLException err) {
System.out.println(err);
MessageBox.infoBox(err.toString(), "Error");
}
closeConnect();
}
private boolean isLoggedIn(int id) {
boolean isLoggedIn = false;
Connection con = getConnect();
int personId = getPersonId(id);
try {
String SQL = "SELECT * FROM LogInOut WHERE personId = " + personId + " AND TimeOut IS NULL";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQL);
if (rs != null && rs.next()) {
rs.last();
isLoggedIn = true;
}
} catch (Exception err) {
MessageBox.infoBox(err.toString(), "Error from isLoggedIn");
System.out.println(err);
}
closeConnect();
return isLoggedIn;
// SELECT * FROM LogInOut WHERE personId = 1 AND TimeOut IS NULL
}
public static int getPersonId(int id) {
Connection con = getConnect();
ResultSet rs = null;
int personId = 0;
try {
String SQL = "SELECT PersonId FROM 2761DB.Persons WHERE SchoolId = " + id;
Statement stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
if (rs.next()) {
rs.first();
personId = rs.getInt("PersonId");
} else {
AddUserQuery addUserQuery = new AddUserQuery();
addUserQuery.setVisible(true);
}
} catch (Exception err) {
MessageBox.infoBox(err.toString(), "Error in getPersonId");
}
closeConnect();
return personId;
}
public static boolean isIdFound(int id) {
Connection con = getConnect();
boolean isFound = false;
try {
String SQL =
"SELECT PersonId, FirstName, LastName, SchoolId FROM 2761DB.Persons WHERE SchoolId = "
+ id;
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(SQL);
if (rs.first()) {
isFound = true;
} else {
AddUserQuery addUser = new AddUserQuery();
addUser.setVisible(true);
}
} catch (SQLException err) {
System.out.println(err);
MessageBox.infoBox(err.toString(), "Error");
}
closeConnect();
return isFound;
}
@Override
protected void done() {
// Turn off indeterminate.
progressBar.setIndeterminate(false);
// Check for exceptions, and display them if necessary.
try {
get();
} catch (Exception e) {
StringWriter stack_trace = new StringWriter();
e.printStackTrace(new PrintWriter(stack_trace));
MessageBox.messageBox(
mainFrame,
"Error while " + task,
"The following error occurred while "
+ task
+ ": "
+ e.getMessage()
+ "\n\nStack trace: "
+ stack_trace,
MessageBox.ERROR);
}
}
public void login() {
mbAutoLogIn = false;
while (!mbAutoLogIn) {
try {
// Confirm logout
if (isOpen()) {
if (MessageBox.showConfirmDialog(
this,
MonitorDictionary.getString("Confirm.Exit"),
Global.APP_NAME,
MessageBox.YES_NO_OPTION)
== MessageBox.NO_OPTION) return;
// Disconnect from server
disconnect();
}
// Login
DialogLogin dlgLogin = new DialogLogin(this);
WindowManager.centeredWindow(dlgLogin);
if (dlgLogin.miReturn == JOptionPane.OK_OPTION) {
// Update UI
SwingUtilities.updateComponentTreeUI(pnlUser);
SwingUtilities.updateComponentTreeUI(pnlThread);
// Request to connect
Socket sck = new Socket(dlgLogin.mstrHost, Integer.parseInt(dlgLogin.mstrPort));
sck.setSoLinger(true, 0);
// Start up a channel thread that reads messages from the server
channel =
new SocketTransmitter(sck) {
public void close() {
if (msckMain != null) {
super.close();
closeAll();
if (mbAutoLogIn) login();
}
}
};
channel.setUserName(dlgLogin.mstrUserName);
channel.setPackage("com.fss.thread.");
channel.start();
// Request to Server
DDTP request = new DDTP();
request.setRequestID(String.valueOf(System.currentTimeMillis()));
request.setString("UserName", dlgLogin.mstrUserName);
request.setString("Password", dlgLogin.mstrPassword);
// Response from Server
DDTP response = channel.sendRequest("ThreadProcessor", "login", request);
mstrThreadAppName = response.getString("strThreadAppName");
mstrThreadAppVersion = response.getString("strThreadAppVersion");
mstrAppName = response.getString("strAppName");
mstrAppVersion = response.getString("strAppVersion");
if (response != null) {
if (response.getString("PasswordExpired") != null) {
DialogChangePassword frm = new DialogChangePassword(this, channel);
WindowManager.centeredWindow(frm);
if (frm.miReturnValue != JOptionPane.OK_OPTION) throw new AppException("FSS-10003");
}
String strLog = StringUtil.nvl(response.getString("strLog"), "");
showResult(txtBoard, strLog);
Vector vtThread = response.getVector("vtThread");
updateTabBar(vtThread);
mstrChannel = response.getString("strChannel");
if (mstrChannel != null) removeUser(mstrChannel);
}
btnRefresh.doClick();
pnlThread.setVisible(true);
pnlUser.setVisible(true);
setResizeWeight(1);
setDividerLocation((int) (getSize().getHeight() - 160));
}
mbAutoLogIn = true;
updateLanguage();
} catch (Exception e) {
e.printStackTrace();
MessageBox.showMessageDialog(this, e, Global.APP_NAME, MessageBox.ERROR_MESSAGE);
// Disconnect from server
mstrChannel = null;
disconnect();
}
}
}
