void doExeCommand() {
JViewport viewport = scrollPane.getViewport();
String strContent = new String();
PSlider slider;
int i;
File fp = new File(dataFile);
RandomAccessFile access = null;
Runtime program = Runtime.getRuntime();
String cmdTrigger = "trigger";
boolean delete = fp.delete();
try {
fp.createNewFile();
} catch (IOException ie) {
System.err.println("Couldn't create the new file " + ie);
// System.exit(-1);;
}
try {
access = new RandomAccessFile(fp, "rw");
} catch (IOException ie) {
System.err.println("Error in accessing the file " + ie);
// System.exit(-1);;
}
for (i = 0; i < COMPONENTS; i++) {
slider = (PSlider) vSlider.elementAt(i);
/* Modified on March 20th to satisfy advisors' new request */
if (slider.isString == true) strContent = strContent + slider.getRealStringValue() + " ";
else strContent = strContent + slider.getValue() + " ";
}
// Get value of the radio button group
if (firstBox.isSelected() == true) strContent = strContent + "1";
else strContent = strContent + "0";
try {
access.writeBytes(strContent);
access.close();
} catch (IOException ie) {
System.err.println("Error in writing to file " + ie);
// System.exit(-1);;
}
// Trigger the OpenGL program to update with new values
try {
Process pid = program.exec(cmdTrigger);
} catch (IOException ie) {
System.err.println("Couldn't run " + ie);
// System.exit(-1);;
}
doSourceFileUpdate();
}
public void actionPerformed(ActionEvent e) {
if (e.getSource() == submit) {
if (rb1.isSelected()) {
JFrame frame = Application.getFrame();
if (typeCodes.isEmpty()) {
JOptionPane.showMessageDialog(
frame,
"Please select at least one toponym type.",
"Error",
JOptionPane.ERROR_MESSAGE);
} else {
Application.getMainCitiesPanel(this, typeCodes, 0, 0.0);
}
} else if (rb2.isSelected()) {
JFrame frame = Application.getFrame();
try {
nCities = new Integer(nCitiesField.getText());
if (nCities <= 0) throw new NumberFormatException();
typeCodes = new ArrayList<String>();
Application.getMainCitiesPanel(this, typeCodes, nCities, 0.0);
} catch (NumberFormatException ex) {
JOptionPane.showMessageDialog(
frame, "Please enter a positive integer number.", "Error", JOptionPane.ERROR_MESSAGE);
}
} else {
JFrame frame = Application.getFrame();
try {
Double dist = new Double(distField.getText());
if (dist <= 0) throw new NumberFormatException();
typeCodes = new ArrayList<String>();
Application.getMainCitiesPanel(this, typeCodes, 0, dist);
} catch (NumberFormatException ex) {
JOptionPane.showMessageDialog(
frame, "Please enter a positive number.", "Error", JOptionPane.ERROR_MESSAGE);
}
}
} else {
Application.getOptionPanel(this, countryName);
}
}
public void bookRoom() {
try {
int code = 0;
Connection con =
DriverManager.getConnection(
"jdbc:mysql://67.20.111.85:3306/jeehtove_caliking?relaxAutoCommit=false",
"jeehtove_ck",
"Z_^PBBZT+kcy");
Statement stmt_insert = con.createStatement();
Statement stmt_tableRange = con.createStatement();
Statement stmt_checkrooms = con.createStatement();
Statement stmt_checkrooms_2 = con.createStatement();
String insert = null;
int flag = 0;
String room_type;
if (standardRoom.isSelected()) {
room_type = "Standard";
code = 1;
} else if (familyRoom.isSelected()) {
room_type = "Family";
code = 2;
} else {
room_type = "Suite";
code = 3;
}
// Converting string from checkin and checkout dates so that they can access the correct table
String currentDate_checkin_getText = checkindateField.getText();
String currentDate_checkin_rest = currentDate_checkin_getText.substring(5);
String currentDate_checkin_replace = currentDate_checkin_rest.replace("-", "_");
String currentDate_checkin_year = currentDate_checkin.substring(0, 4);
String currentDate_checkin_final =
currentDate_checkin_year + "_" + currentDate_checkin_replace;
String currentDate_checkout_getText = checkoutdateField.getText();
String currentDate_checkout_rest = currentDate_checkout_getText.substring(5);
String currentDate_checkout_replace = currentDate_checkout_rest.replace("-", "_");
String currentDate_checkout_year = currentDate_checkout.substring(0, 4);
String currentDate_checkout_final =
currentDate_checkout_year + "_" + currentDate_checkout_replace;
// MySQL Statement to select tables from schema that are in between checkin and checkout range
String tableRange =
"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='jeehtove_caliking' AND TABLE_NAME BETWEEN 'rooms_"
+ currentDate_checkin_final
+ "' AND 'rooms_"
+ currentDate_checkout_final
+ "';";
ResultSet tb_Range = stmt_tableRange.executeQuery(tableRange);
System.out.println(tableRange);
List tb_range_list = new ArrayList();
while (tb_Range.next()) {
String tb_range_date = tb_Range.getString("table_name");
tb_range_list.add(tb_range_date);
// String current_table = tb_Range.getString("table_name");
// System.out.println(tb_range_list.add(tb_Range.getString("table_name")));
}
stmt_tableRange.close();
for (int x = 0; x < tb_range_list.size(); x++) {
String query_checkrooms =
"SELECT * FROM "
+ tb_range_list.get(x)
+ " WHERE type = '"
+ code
+ "' AND booked = '0' LIMIT 1;";
// System.out.println(query_checkrooms);
ResultSet checkrooms = stmt_checkrooms.executeQuery(query_checkrooms);
while (checkrooms.next()) {
String getroomnumber = checkrooms.getString("room");
insert =
"INSERT INTO `reservations` VALUES ('"
+ getroomnumber
+ "', '"
+ checkindateField.getText()
+ "', '"
+ checkoutdateField.getText()
+ "', '"
+ room_type
+ "', '"
+ nameField.getText()
+ "');";
String bookroom =
"UPDATE `"
+ tb_range_list.get(x)
+ "` SET booked = '1' WHERE room = '"
+ getroomnumber
+ "';";
// System.out.println(insert);
int cr = stmt_checkrooms_2.executeUpdate(bookroom);
flag = 1;
System.out.println("Room Booked!");
}
}
if (flag == 1) {
int rs = stmt_insert.executeUpdate(insert);
} else {
System.out.println("All " + room_type + " rooms are booked for the time requested.");
}
/*String query_checkrooms = "SELECT * FROM rooms_" + currentDate_checkin_final + " WHERE type = '" + code + "' AND booked = '0';";
System.out.println(query_checkrooms);
Statement stmt_checkrooms = con.createStatement();
ResultSet checkrooms = stmt_checkrooms.executeQuery(query_checkrooms);*/
/*if (checkrooms.next()){
String getroomnumber = checkrooms.getString("room");
String insert = "INSERT INTO `reservations` VALUES ('" + getroomnumber + "', '" + checkindateField.getText() + "', '" + checkoutdateField.getText() + "', '" + room_type + "', '" + nameField.getText() + "');";
String bookroom = "UPDATE `rooms_" + currentDate_checkin_final + "` SET booked = '1' WHERE room = '" + getroomnumber + "';";
//System.out.println(insert);
int rs=stmt_insert.executeUpdate(insert);
int cr=stmt_checkrooms.executeUpdate(bookroom);
con.commit();
System.out.println("Room Booked!");
}*/
// else System.out.println("All " + room_type + " rooms are booked for the time requested.");
System.out.println("Complete.");
} catch (Exception e) {
System.out.println(e);
}
}
public void actionPerformed(ActionEvent a) {
int code = 0;
String roomtypeCompare_arr = null;
String roomtypeCompare_dep = null;
if ("book".equals(a.getActionCommand())) {
try {
Class.forName("com.mysql.jdbc.Driver");
// Database connection information. Please note that when porting the code, you must have
// the jdbc Driver installed where the code is running.
Connection con =
DriverManager.getConnection(
"jdbc:mysql://67.20.111.85:3306/jeehtove_caliking?relaxAutoCommit=true",
"jeehtove_ck",
"Z_^PBBZT+kcy");
// The SELECT query
String query_arr =
"SELECT * from reservations WHERE checkin BETWEEN '"
+ checkindateField.getText()
+ "' AND '"
+ checkoutdateField.getText()
+ "'";
String query_dep =
"SELECT * from reservations WHERE checkout BETWEEN '"
+ checkindateField.getText()
+ "' AND '"
+ checkoutdateField.getText()
+ "'";
Statement stmt_arr = con.createStatement();
Statement stmt_dep = con.createStatement();
Statement stmt_insert = con.createStatement();
ResultSet result_arr = stmt_arr.executeQuery(query_arr);
ResultSet result_dep = stmt_dep.executeQuery(query_dep);
// Get room type from radio buttons
String room_type;
if (standardRoom.isSelected()) {
room_type = "Standard";
code = 1;
} else if (familyRoom.isSelected()) {
room_type = "Family";
code = 2;
} else {
room_type = "Suite";
code = 3;
}
bookRoom();
// ResultSet rs=stmt.executeQuery("select * from emp");
/*if (!result_arr.next() && !result_dep.next()){
bookRoom();
//Query Prep for checking for open rooms
/*String query_checkrooms = "SELECT * FROM makereservation_rooms WHERE type = '" + code + "' AND booked = '0';";
Statement stmt_checkrooms = con.createStatement();
ResultSet checkrooms = stmt_checkrooms.executeQuery(query_checkrooms);
if (checkrooms.next()){
String getroomnumber = checkrooms.getString("room");
String insert = "INSERT INTO `reservations` VALUES ('" + getroomnumber + "', '" + checkindateField.getText() + "', '" + checkoutdateField.getText() + "', '" + room_type + "', '" + nameField.getText() + "');";
String bookroom = "UPDATE `makereservation_rooms` SET booked = '1' WHERE room = '" + getroomnumber + "';";
//System.out.println(insert);
int rs=stmt_insert.executeUpdate(insert);
int cr=stmt_checkrooms.executeUpdate(bookroom);
con.commit();
System.out.println("Room Booked!");
}
else System.out.println("All " + room_type + " rooms are booked for the time requested.");
}
else {
if (result_arr.next()){
roomtypeCompare_arr = result_arr.getString("type");
System.out.println("(arrival) Does " + roomtypeCompare_arr + " equal " + room_type + "?");
if (roomtypeCompare_arr.equals(room_type)){
String checkindateDB_arr = result_arr.getString("checkin");
String checkoutdateDB_arr = result_arr.getString("checkout");
System.out.println("There is a room booked on " + checkindateDB_arr + " that checks out on " + checkoutdateDB_arr + ". Please select another date.");
}
else {
System.out.println("Room Booked!");
}
}
}
//System.out.println(query_dep);
if (result_dep.next()){
roomtypeCompare_dep = result_dep.getString("type");
System.out.println("(departure) Does " + roomtypeCompare_dep + " equal " + room_type + "?");
if (roomtypeCompare_dep.equals(room_type)){
String checkindateDB_dep = result_dep.getString("checkin");
String checkoutdateDB_dep = result_dep.getString("checkout");
System.out.println("There is a room booked on " + checkindateDB_dep + " that checks out on " + checkoutdateDB_dep + ". Please select another date.");
}
else {
System.out.println("Room Booked!");
}
}*/
con.close();
} catch (Exception e) {
System.out.println(e);
}
}
}
void doSourceFileUpdate() {
BufferedReader bufferIn = null;
String str1 = new String();
String strContent = new String();
String sliderValue = new String();
String newLine = System.getProperty("line.separator");
StringBuffer strBuf = new StringBuffer();
RandomAccessFile access = null;
String tempFile = "temp" + round + ".html";
File fp = new File(tempFile);
boolean firstChoice = true;
int posFound = 0;
int i = 0;
PSlider slider;
// round += 1;
// Read the original source file to input buffer
try {
bufferIn = new BufferedReader(new FileReader(exampleSource));
} catch (FileNotFoundException fe) {
System.err.println("Example Source File not found " + fe);
// System.exit(-1);;
}
// get the first line of the buffer.
try {
str1 = bufferIn.readLine();
} catch (IOException ie) {
System.err.println("Error reading line from the buffer " + ie);
// System.exit(-1);;
}
// Transfer the whole content of the input buffer to the string
try {
do strContent += str1 + newLine;
while ((str1 = bufferIn.readLine()) != null);
} catch (IOException ie) {
System.err.println("Error readding content of the input buffer " + ie);
// System.exit(-1);;
}
// do the replacement.
// First having to update the code part that is active in this section before
// doing variables updated. Look at the current active radiobutton to make decision
if (secondBox.isSelected() == true) firstChoice = false;
if (firstChoice == true) {
String tempStr = new String();
strBuf = new StringBuffer(strContent);
posFound = strContent.indexOf(textStr2);
tempStr =
"<font color=blue>/***********" + newLine + textStr2 + newLine + "***********/</font>";
strBuf.replace(posFound, posFound + textStr2.length(), tempStr);
strContent = new String(strBuf);
} else {
String tempStr = new String();
strBuf = new StringBuffer(strContent);
posFound = strContent.indexOf(textStr1);
tempStr =
"<font color=blue>/***********" + newLine + textStr1 + newLine + "***********/</font>";
strBuf.replace(posFound, posFound + textStr1.length(), tempStr);
strContent = new String(strBuf);
}
for (i = COMPONENTS; i > 0; i--) {
// get the current value of slider
slider = (PSlider) vSlider.elementAt(i - 1);
sliderValue = slider.getValue();
// construct the search string
str1 = "JPOT$" + i;
// get the position of the search string in the content string.
while ((posFound = strContent.indexOf(str1)) != -1) {
strBuf = new StringBuffer(strContent);
strBuf.replace(posFound, posFound + str1.length(), sliderValue);
strContent = new String(strBuf);
}
}
boolean delete = fp.delete();
try {
fp.createNewFile();
} catch (IOException ie) {
System.err.println("Couldn't create the new file " + ie);
// System.exit(-1);;
}
try {
access = new RandomAccessFile(fp, "rw");
} catch (IOException ie) {
System.err.println("Error in accessing the file " + ie);
// System.exit(-1);;
}
try {
access.writeBytes(strContent);
access.close();
} catch (IOException ie) {
System.err.println("Error in writing to file " + ie);
// System.exit(-1);;
}
try {
textPane.getDocument().putProperty(Document.StreamDescriptionProperty, null);
URL url = new URL("file:" + tempFile + "#gohere");
textPane.setPage(url);
delete = fp.delete();
} catch (IOException ie) {
System.err.println("Can not get the example html file " + ie);
// System.exit(-1);;
}
}