/**
* _more_
*
* @return _more_
*/
public Connection getConnection() {
if (connection != null) {
return connection;
}
String url = getFilename();
if ((dataSource.getUserName() == null) || (dataSource.getUserName().trim().length() == 0)) {
if (url.indexOf("?") >= 0) {
int idx = url.indexOf("?");
List<String> args =
(List<String>) StringUtil.split(url.substring(idx + 1), "&", true, true);
url = url.substring(0, idx);
for (String tok : args) {
List<String> subtoks = (List<String>) StringUtil.split(tok, "=", true, true);
if (subtoks.size() != 2) {
continue;
}
String name = subtoks.get(0);
String value = subtoks.get(1);
if (name.equals("user")) {
dataSource.setUserName(value);
} else if (name.equals("password")) {
dataSource.setPassword(value);
}
}
}
}
int cnt = 0;
while (true) {
String userName = dataSource.getUserName();
String password = dataSource.getPassword();
if (userName == null) {
userName = "";
}
if (password == null) {
password = "";
}
try {
connection = DriverManager.getConnection(url, userName, password);
return connection;
} catch (SQLException sqe) {
if ((sqe.toString().indexOf("role \"" + userName + "\" does not exist") >= 0)
|| (sqe.toString().indexOf("user name specified") >= 0)) {
String label;
if (cnt == 0) {
label =
"<html>The database requires a login.<br>Please enter a user name and password:</html>";
} else {
label = "<html>Incorrect username/password. Please try again.</html>";
}
if (!dataSource.showPasswordDialog("Database Login", label)) {
return null;
}
cnt++;
continue;
}
throw new BadDataException("Unable to connect to database", sqe);
}
}
}
public static void closeConnect() {
try {
con.close();
} catch (SQLException e) {
MessageBox.infoBox(e.toString(), "Error in closeConnect");
}
}
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 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 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();
}
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;
}
/** Method declaration */
void testPerformance() {
String all = txtCommand.getText();
StringBuffer b = new StringBuffer();
long total = 0;
for (int i = 0; i < all.length(); i++) {
char c = all.charAt(i);
if (c != '\n') {
b.append(c);
}
}
all = b.toString();
String g[] = new String[4];
g[0] = "ms";
g[1] = "count";
g[2] = "sql";
g[3] = "error";
gResult.setHead(g);
int max = 1;
lTime = System.currentTimeMillis() - lTime;
while (!all.equals("")) {
int i = all.indexOf(';');
String sql;
if (i != -1) {
sql = all.substring(0, i);
all = all.substring(i + 1);
} else {
sql = all;
all = "";
}
if (sql.startsWith("--#")) {
max = Integer.parseInt(sql.substring(3));
continue;
} else if (sql.startsWith("--")) {
continue;
}
g[2] = sql;
long l = 0;
try {
l = DatabaseManagerCommon.testStatement(sStatement, sql, max);
total += l;
g[0] = String.valueOf(l);
g[1] = String.valueOf(max);
g[3] = "";
} catch (SQLException e) {
g[0] = g[1] = "n/a";
g[3] = e.toString();
}
gResult.addRow(g);
System.out.println(l + " ms : " + sql);
}
g[0] = "" + total;
g[1] = "total";
g[2] = "";
gResult.addRow(g);
lTime = System.currentTimeMillis() - lTime;
updateResult();
}
