public void actionPerformed(ActionEvent ae) {
try {
if (ae.getSource() == b7) {
rs = st.executeQuery("select count(*) from employeemaster");
if (rs.next()) {
t6.setText(rs.getString(1));
}
rs = st.executeQuery("select * from Head");
if (rs.next()) {
t1.setText(rs.getString(1));
t2.setText(rs.getString(2));
t7.setText(rs.getString(3));
t4.setText(rs.getString(4));
t5.setText(rs.getString(5));
t3.setText(rs.getString(6));
}
} else if (ae.getSource() == b6) {
dispose();
}
} catch (Exception e) {
JOptionPane.showMessageDialog(this, "Error is" + e);
}
}
public void actionPerformed(ActionEvent ae) {
try {
Integer num = Integer.parseInt(tfdid.getText());
String name;
String addr;
String contact;
String spec;
String workf;
String workt;
Statement st = cn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM DOC WHERE did=" + num);
if (rs.next()) {
num = rs.getInt("did");
name = rs.getString("name");
addr = rs.getString("address");
contact = rs.getString("contact");
spec = rs.getString("specialization");
workf = rs.getString("workfrom");
workt = rs.getString("workto");
tfname.setText(name);
taadd.setText(addr);
tftel.setText(contact);
taspecial.setText(spec);
tfworkf.setText(workf);
tfworkt.setText(workt);
}
} catch (SQLException sq) {
System.out.println(sq);
}
}
private void ListValueChanged(
javax.swing.event.ListSelectionEvent evt) { // GEN-FIRST:event_ListValueChanged
// TODO add your handling code here:
// String part=partno.getText();
try {
String sql =
"SELECT TYPE,ITEM_NAME,QUANTITY,MRP FROM MOTORS WHERE ITEM_NAME='"
+ List.getSelectedValue()
+ "'";
Class.forName("com.mysql.jdbc.Driver");
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
partno.setText(rs.getString("TYPE"));
name.setText(rs.getString("ITEM_NAME"));
qty.setText(rs.getString("QUANTITY"));
rate.setText(rs.getString("MRP"));
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.toString());
}
} // GEN-LAST:event_ListValueChanged
public void setQuery(String q) {
cache = new Vector();
try {
ResultSet rs = statement.executeQuery(q);
ResultSetMetaData meta = rs.getMetaData();
colCount = meta.getColumnCount();
headers = new String[colCount];
for (int h = 1; h <= colCount; h++) {
headers[h - 1] = meta.getColumnName(h);
}
while (rs.next()) {
String[] record = new String[colCount];
for (int i = 0; i < colCount; i++) {
record[i] = rs.getString(i + 1);
}
cache.addElement(record);
} // while sonu
fireTableChanged(null);
} // try sonu
catch (Exception e) {
cache = new Vector();
e.printStackTrace();
}
} // setQuery sonu
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();
}
public void connectItems(String query)
// PRE: query must be initialized
// POST: Updates the list of Items based on the query.
{
String driver = "org.apache.derby.jdbc.ClientDriver"; // Driver for DB
String url = "jdbc:derby://localhost:1527/ShopDataBase"; // Url for DB
String user = "******"; // Username for db
String pass = "******"; // Password for db
Connection myConnection; // Connection obj to db
Statement stmt; // Statement to execute a result appon
ResultSet results; // A set containing the returned results
int rowcount; // Num objects in the resultSet
int i; // Index for the array
try { // Try connection to db
Class.forName(driver).newInstance(); // Create our db driver
myConnection = DriverManager.getConnection(url, user, pass); // Initalize our connection
stmt =
myConnection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE); // Create a new statement
results = stmt.executeQuery(query); // Store the results of our query
rowcount = 0;
if (results.last()) // Go to the last result
{
rowcount = results.getRow();
results.beforeFirst();
}
itemsArray = new Item[rowcount];
i = 0;
while (results.next()) // Itterate through the results set
{
itemsArray[i] =
new Item(
results.getInt("item_id"),
results.getString("item_name"),
results.getString("item_type"),
results.getInt("price"),
results.getInt("owner_id"),
results.getString("item_path")); // Creat new Item
i++;
}
results.close(); // Close the ResultSet
stmt.close(); // Close the statement
myConnection.close(); // Close the connection to db
} catch (Exception e) // Cannot connect to db
{
System.err.println(e.toString());
System.err.println("Error, something went horribly wrong in connectItems!");
}
}
private void jButton3ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton3ActionPerformed
try {
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt = con.createStatement();
ResultSet resultSet = stmt.executeQuery("select Bill_No from bill;");
String productCode = null;
while (resultSet.next()) {
productCode = resultSet.getString("Bill_No");
}
int pc = Integer.parseInt(productCode);
System.out.println(pc);
no.setText((String.valueOf(++pc)));
// TODO add your handling code here:
String part = partno.getText();
String itemname = name.getText();
String qty1 = qty.getText();
String rate1 = rate.getText();
// String amo=amount.getText();
String noo = no.getText();
no1 = Integer.parseInt(noo);
cname = custname.getText();
bill1 = bill.getText();
addr1 = addr.getText();
String ta = tax.getText();
int a = Integer.parseInt(qty1);
int b = Integer.parseInt(rate1);
int c = a * b;
String str = Integer.toString(c);
amount.setText(str);
String str1 = amount.getText();
/* String sql1="select Quantity from lubricants";
String sql2="UPDATE LUBRICANTS SET QUANTITY=QUANTITY-qty1 WHERE PART_NO='"+partno+"'";
Statement stmt1=con.createStatement();
ResultSet rs1= stmt1.executeQuery(sql1);
String ch=rs1.getString("QUANTITY");
int q=Integer.parseInt(qty1);
int r=Integer.parseInt(ch);
if(q >r)
{
JOptionPane.showMessageDialog(this,"STOCK UNAVAILABLE");
}
else
{
stmt1.executeUpdate(sql2);
}*/
} catch (SQLException ex) {
Logger.getLogger(Billspare.class.getName()).log(Level.SEVERE, null, ex);
}
} // GEN-LAST:event_jButton3ActionPerformed
private void passwordTextBoxKeyPressed(
java.awt.event.KeyEvent evt) { // GEN-FIRST:event_passwordTextBoxKeyPressed
// TODO add your handling code here:
int key = evt.getKeyCode();
if (key == KeyEvent.VK_ENTER) {
boolean verify = false;
String user = usernameTextBox.getText();
String passwd = passwordTextBox.getText();
if (user.equals("") || passwd.equals("")) {
JOptionPane.showMessageDialog(
AdminLogin.this, "Sorry! You must enter a Username and Password to login ");
usernameTextBox.requestFocus();
} else {
Connection con = getConnection();
try {
ResultSet rows;
Statement s =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String select = "Select * from admin;";
rows = s.executeQuery(select);
while (rows.next()) {
String username = rows.getString("Username");
String password = rows.getString("Password");
if (user.equals(username) && passwd.equals(password)) {
verify = true;
this.dispose();
// btn.btnEnabled();
break;
}
}
if (verify == false) {
verify = false;
JOptionPane.showMessageDialog(
AdminLogin.this, "Access Denied! Invalid Username or Password");
usernameTextBox.setText("");
passwordTextBox.setText("");
usernameTextBox.requestFocus();
}
} catch (SQLException e) {
System.out.println(e.getMessage());
}
if (verify == false) {
JOptionPane.showMessageDialog(
AdminLogin.this, "Access Denied! Invalid Username or Password");
usernameTextBox.setText("");
passwordTextBox.setText("");
usernameTextBox.requestFocus();
} // TODO add your handling code here:
}
}
if (key == KeyEvent.VK_UP) {
usernameTextBox.grabFocus();
}
if (key == KeyEvent.VK_KP_UP) {
usernameTextBox.grabFocus();
}
} // GEN-LAST:event_passwordTextBoxKeyPressed
public static void goer() throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con =
(Connection) DriverManager.getConnection("jdbc:oracle:thin:@localhost", "system", "system");
String query2 = "select * from logger";
Statement st2 = con.createStatement();
ResultSet rs = st2.executeQuery(query2);
boolean b = false;
while (rs.next()) {
if ((rs.getString(3)).equals(p2.str3)) {
b = true;
}
}
if (b == false) {
String query1 =
"insert into logger values('"
+ p2.str1
+ "','"
+ p2.str2
+ "','"
+ p2.str3
+ "','"
+ p2.str4
+ "','"
+ p2.str5
+ "','"
+ p2.str7
+ "','"
+ p2.str8
+ "','"
+ p2.str9
+ "','"
+ p2.str13
+ "')";
Statement st1 = con.createStatement();
st1.executeQuery(query1);
JOptionPane.showMessageDialog(null, "welcome\n now you are a meber of our team ");
} else {
JOptionPane.showMessageDialog(null, "this username already exist");
}
}
public void updateTables(String updateQuery1, String updateQuery2, String updateQuery3)
// PRE: updateQuery1,updateQuery2, updateQuery3 must be initialized
// POST: Updates the list of Items based on the querys.
{
String driver = "org.apache.derby.jdbc.ClientDriver"; // Driver for DB
String url = "jdbc:derby://localhost:1527/ShopDataBase"; // Url for DB
String user = "******"; // Username for db
String pass = "******"; // Password for db
Connection myConnection; // Connection obj to db
Statement stmt; // Statement to execute a result appon
ResultSet results; // A set containing the returned results
int i; // Index for the array
try // Try connection to db
{
Class.forName(driver).newInstance(); // Create our db driver
myConnection = DriverManager.getConnection(url, user, pass); // Initalize our connection
stmt =
myConnection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(updateQuery1);
stmt.executeUpdate(updateQuery2);
stmt.executeUpdate(updateQuery3);
results = stmt.executeQuery(previous_query); // Call the previous query
i = 0;
while (results.next()) // Itterate through the results set
{
itemsArray[i] =
new Item(
results.getInt("item_id"),
results.getString("item_name"),
results.getString("item_type"),
results.getInt("price"),
results.getInt("owner_id"),
results.getString("item_path"));
i++;
}
results.close(); // Close the ResultSet
stmt.close(); // Close the statement
myConnection.close(); // Close the connection to db
} catch (Exception e) // Cannot connect to db
{
System.err.println(e.toString());
System.err.println("Error, something went horribly wrong! in updateTables");
}
}
public boolean isValidUser() throws SQLException {
CreateJDBCConnection jdbc = new CreateJDBCConnection();
Statement stmt = jdbc.getStatement();
stmt.execute("use jana;");
String sqlQuery =
"select password from user_details where idno = '" + nameText.getText() + "';";
ResultSet rs = stmt.executeQuery(sqlQuery);
while (rs.next()) {
if (rs.getString("password").equals(passText.getText())) return true;
}
return false;
}
public void updateRecord() {
String totalSeat, alotSeat, vacentSeat, strHostel;
try {
rs = statement.executeQuery("select hostelName from hostelStatus");
while (rs.next()) {
strHostel = rs.getString(1);
try {
rs1 = statement1.executeQuery("select count(*) from " + strHostel + "");
rs1.next();
totalSeat = rs1.getString(1);
rs1 = statement1.executeQuery("select count(*) from " + strHostel + " where status='F'");
rs1.next();
alotSeat = rs1.getString(1);
try {
vacentSeat = String.valueOf(Integer.parseInt(totalSeat) - Integer.parseInt(alotSeat));
statement1.executeUpdate(
"update hostelStatus set totalSeat='"
+ totalSeat
+ "',vacentSeat='"
+ vacentSeat
+ "'where hostelName='"
+ strHostel
+ "'");
statement1.executeUpdate("commit");
rs1.close();
} catch (SQLException sqle) {
JOptionPane.showMessageDialog(null, sqle);
}
} catch (SQLException sqle) {
JOptionPane.showMessageDialog(null, "Error " + sqle);
}
}
} catch (SQLException sq) {
JOptionPane.showMessageDialog(null, sq);
}
}
public void actionPerformed(ActionEvent ae) {
String str = ae.getActionCommand();
if (str.equals("Ok")) {
String str1 = (String) jcmname.getSelectedItem();
Connection con = null;
Statement stat = null;
if (str1.equals("Pulsar")
|| str1.equals("CT 100")
|| str1.equals("Discover DTS-i")
|| str1.equals("Wave DTS-i")) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("Jdbc:Odbc:showroom");
System.out.println("Got Connection :" + con);
stat = con.createStatement();
ResultSet rs = stat.executeQuery("select * from vehicle");
System.out.println("chk1");
while (rs.next()) {
if (str1.equals(rs.getString(1))) {
tfcap.setText("" + rs.getInt(2));
tfeng.setText("" + rs.getInt(3));
tfbhp.setText("" + rs.getInt(4));
tfvolt.setText("" + rs.getInt(5));
tfrpm.setText("" + rs.getInt(6));
tfweight.setText("" + rs.getInt(7));
tfgear.setText("" + rs.getInt(8));
}
}
stat.close();
con.close();
} catch (Exception ex) {
}
} else {
JOptionPane.showMessageDialog(
null, "Please Choose Model Name", "Error", JOptionPane.ERROR_MESSAGE);
}
}
if (str.equals("can")) {
this.dispose();
// new menu(1);
}
}
/**
* Fill the table using m_sql
*
* @param table table
*/
private static void tableLoad(MiniTable table) {
// log.finest(m_sql + " - " + m_groupBy);
String sql =
MRole.getDefault()
.addAccessSQL(m_sql.toString(), "tab", MRole.SQL_FULLYQUALIFIED, MRole.SQL_RO)
+ m_groupBy
+ m_orderBy;
log.finest(sql);
try {
Statement stmt = DB.createStatement();
ResultSet rs = stmt.executeQuery(sql);
table.loadTable(rs);
stmt.close();
} catch (SQLException e) {
log.log(Level.SEVERE, sql, e);
}
} // tableLoad
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 void actionPerformed(ActionEvent e) {
String name4 = JOptionPane.showInputDialog("Enter the UserId:");
String name5 = JOptionPane.showInputDialog("Enter the DOB(dd/mm/yyyy):");
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection con =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
ResultSet rs =
st.executeQuery(
"select * from database where userid='" + name4 + "' and dob='" + name5 + "'");
rs.next();
String z = rs.getString("password");
JOptionPane.showMessageDialog(null, "Your Password is < " + z + " >");
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(null, "Please Enter valid UserId and DOB(dd/mm/yyyy) .");
}
}
public void login() {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String id, pw, sql;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, "hr", "hr");
stmt = con.createStatement();
sql = "select * from chatuser where id = '" + lid.getText() + "'";
rs = stmt.executeQuery(sql);
if (rs.next()) {
pw = rs.getString(2);
nick = rs.getString(3);
if (lpw.getText().equals(pw)) {
jd.setVisible(false);
setVisible(true);
} else {
lpw.setText("일치하지 않습니다.");
}
} else {
lid.setText("일치하지 않습니다.");
}
} catch (Exception e1) {
e1.printStackTrace();
System.out.println("데이터 베이스 연결 실패!!");
} finally {
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (con != null) con.close();
} catch (Exception e1) {
System.out.println(e1.getMessage());
}
}
}
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;
}
public void FillList() {
try {
String sql1 = "select * from motors";
Class.forName("com.mysql.jdbc.Driver");
Connection con =
(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/bharatmotors", "root", "");
Statement stmt = con.createStatement();
ResultSet rs1 = stmt.executeQuery(sql1);
DefaultListModel DLM = new DefaultListModel();
while (rs1.next()) {
DLM.addElement(rs1.getString(3));
// DLM.addElement(rs1.getString(2));
}
List.setModel(DLM);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "e.getString()");
}
}
public void actionPerformed(ActionEvent e) {
String name6 = JOptionPane.showInputDialog("Enter old Password:"******"Enter New Password:"******"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from database where password='******'");
rs.next();
String k8 = rs.getString("password");
if (k8.equals(name6)) {
st.executeUpdate(
"update database set password='******' where password='******'");
JOptionPane.showMessageDialog(null, "Your Password has been Reset");
new Jf();
}
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(null, "Please Enter valid DATA .");
}
}
public void actionPerformed(ActionEvent e) {
String name8 = JOptionPane.showInputDialog("Enter old MobileNo:");
String name9 = JOptionPane.showInputDialog("Enter New MobileNo:");
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection con =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from database where mob='" + name8 + "'");
rs.next();
String k9 = rs.getString("mob");
if (k9.equals(name8)) {
st.executeUpdate("update database set mob='" + name9 + "' where mob='" + name8 + "'");
JOptionPane.showMessageDialog(
null, "Your Mobile is Reset . Now Your mobile no is < " + name9 + " >");
new Jf();
}
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(null, "Please Enter valid DATA.");
}
}
/** Initialize the contents of the frame. */
private void initialize() {
JPanel mainPanel = new JPanel();
JButton book = new JButton("Book");
mainPanel.add(book);
book.setPreferredSize(new Dimension(200, 80));
JTextField enterFlightNum = new JTextField("Enter Flight Number");
enterFlightNum.setColumns(10);
enterFlightNum.setBounds(227, 251, 286, 42);
mainPanel.add(enterFlightNum);
JButton mainMenu = new JButton("Main Menu");
mainPanel.add(mainMenu);
mainMenu.setPreferredSize(new Dimension(200, 80));
mainMenu.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
fFrame.setVisible(false);
new MainUI(c1);
}
});
book.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
c1.bookFlight(Integer.parseInt(enterFlightNum.getText()));
;
} catch (Exception ex) {
ex.printStackTrace();
}
}
});
JPanel mainPanel2 = new JPanel();
JLabel listFlights = new JLabel();
mainPanel2.add(listFlights);
Connection connection;
String labelText = "<html>";
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Driver loaded");
connection = DriverManager.getConnection("jdbc:mysql://localhost/mydb", "CIS3270", "Cis3270");
System.out.println("Connection complete");
Statement statement;
statement = connection.createStatement();
String queryString = "select * from flight";
ResultSet rs = statement.executeQuery(queryString);
while (rs.next()) {
labelText =
labelText
+ rs.getString(1)
+ " "
+ rs.getString(3)
+ " "
+ rs.getString(4)
+ " "
+ rs.getString(5)
+ " "
+ rs.getString(6)
+ "<br>";
}
} catch (Exception e) {
}
listFlights.setText(labelText);
System.out.println(labelText);
JPanel mainCombine = new JPanel();
mainCombine.add(mainPanel, BorderLayout.NORTH);
mainCombine.add(mainPanel2, BorderLayout.SOUTH);
fFrame = new JFrame();
fFrame.setSize(1000, 800);
fFrame.add(mainCombine);
fFrame.setVisible(true);
fFrame.setResizable(false);
fFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
fFrame.getContentPane().setLayout(null);
}
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);
}
}
}
public void actionPerformed(ActionEvent e) {
String t = fid.getText();
// char[] t2=fpass.getPassword();
String t2 = fpass.getText();
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection con =
DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "system", "9696030257");
Statement st = con.createStatement();
ResultSet rs =
st.executeQuery(
"select * from database where userid='" + t + "' AND password='******'");
rs.next();
String g = rs.getString("userid");
String h = rs.getString("password");
String i = rs.getString("mob");
String j = rs.getString("dob");
if (g.equals(t) && h.equals(t2)) {
// JOptionPane.showMessageDialog(null,"WoW !! You Are a Valid User");
JFrame jf1 = new JFrame("About Saras");
jf1.setBounds(500, 40, 500, 500);
jf1.setVisible(true);
jf1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf1.setLayout(null);
String ab =
"\n\nHis Name is Saraswatendra Singh.\nHe is pursuing B.Tech from ABES Engineering College(032) Ghaziabad U.P.\nHe is belong from VARANASI which is also called BANARAS.\nHis Email and Facebook id is <*****@*****.**>\n\n\n \t\t\tTHANK YOU";
String bc =
"\n\n\nABOUT YOU:-\n\n\t UserId is < "
+ g
+ " >\n\t Password is <"
+ h
+ " > \n\t Mobile No is < "
+ i
+ " >\n\t Date Of Birth(dd/mm/yyyy) is < "
+ j
+ " >\n \n\nABOUT DEVELOPER:-"
+ ab;
JTextArea about = new JTextArea(bc);
jf1.add(about);
about.setBounds(0, 0, 500, 500);
JButton rest = new JButton("ResetPassword");
about.add(rest);
rest.setBounds(30, 400, 150, 20);
Cursor k1 = new Cursor(Cursor.HAND_CURSOR);
rest.setCursor(k1);
rest.addActionListener(new ResetPassword());
JButton restmob = new JButton("ResetMobileNo");
about.add(restmob);
restmob.setBounds(230, 400, 150, 20);
Cursor k2 = new Cursor(Cursor.HAND_CURSOR);
restmob.setCursor(k2);
restmob.addActionListener(new ResetMob());
}
} catch (Exception ex) {
System.out.print(ex);
JOptionPane.showMessageDialog(
null,
"UserId or Password MissMatched !!! please Enter Valid UserId and Password");
}
}
public void actionPerformed(ActionEvent ae) {
String s1 = ae.getActionCommand();
if (s1.equals("Calendar")) {
// DatePicker dp=new DatePicker(f);
// dp.displayDate();
// f.getContentPane().add(p);
b3.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent ae) {
t6.setText(new DatePicker(f).setPickedDate());
}
});
} else if (s1.equals("LogOut")) {
f.dispose();
start p = new start();
p.method();
} else if (s1.equals("Search")) {
try {
String data = t1.getSelectedItem();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:raman1");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from mprofile where Manager_Id='" + data + "' ");
while (rs.next()) {
String a2 = rs.getString(1);
t2.setText(a2);
String a3 = rs.getString(2);
t3.setText(a3);
String a4 = rs.getString(3);
t4.setText(a4);
String a5 = rs.getString(4);
t5.setText(a5);
String a6 = rs.getString(6);
t6.setText(a6);
String a7 = rs.getString(7);
t7.setText(a7);
String a8 = rs.getString(8);
t8.setText(a8);
String a9 = rs.getString(9);
t9.setText(a9);
String a10 = rs.getString(10);
t10.setText(a10);
p.add(l3);
p.add(t2);
p.add(l4);
p.add(t3);
p.add(l5);
p.add(t4);
p.add(l6);
p.add(t5);
p.add(l7);
p.add(c1);
p.add(c2);
p.add(l8);
p.add(t6);
p.add(l9);
p.add(t7);
p.add(l10);
p.add(t8);
p.add(l11);
p.add(t9);
p.add(l12);
p.add(t10);
p.add(b2);
p.add(b3);
p.add(b4);
}
} catch (Exception e) {
}
} else if (s1.equals("Update")) {
String y2 = t2.getText();
String y3 = t3.getText();
String update_id = t4.getText();
String y4 = t5.getText();
String y6 = t6.getText();
String y7 = t7.getText();
String y8 = t8.getText();
String y9 = t9.getText();
String y10 = t10.getText();
try {
String y = t1.getSelectedItem();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:raman1");
PreparedStatement ps =
con.prepareStatement(
"update mprofile set Location=? , E_Mail_Id=? ,Contact_No =?, Address=?, D_O_B=?,Gender=?, Password=?, Manager_Id=?,manager_father=?,manager_name=? where Manager_Id='"
+ y
+ "' ");
ps.setString(1, y10);
ps.setString(2, y9);
ps.setString(3, y8);
ps.setString(4, y7);
ps.setString(5, y6);
ps.setString(6, g);
ps.setString(7, y4);
ps.setString(8, update_id);
ps.setString(9, y3);
ps.setString(10, y2);
ps.executeUpdate();
JOptionPane.showMessageDialog(p, "data has been updated");
f.dispose();
project p = new project();
p.method();
} catch (Exception e) {
System.out.println(e);
}
} else if (s1.equals("Close")) {
f.dispose();
} else {
f.dispose();
project p = new project();
p.method();
}
}
mupdate() {
f = new JFrame("POS");
p = new Panel();
l1 = new Label("Welcome:Admin");
l2 = new Label("POINT OF SALE");
l14 = new Label("Enter Manager_Id");
l3 = new Label("Name");
l4 = new Label("Father's_Name");
l5 = new Label("Manager_Id");
l6 = new Label("Password");
l7 = new Label("Gender");
l9 = new Label("Address");
l8 = new Label("D.O.B.");
l10 = new Label("Contact_No.");
l11 = new Label("E-Mail_Id");
l12 = new Label("Location");
l13 =
new Label(
"_______________________________________________________________________________________________");
l15 =
new Label(
"_______________________________________________________________________________________________________________________");
cbg = new CheckboxGroup();
c1 = new Checkbox("Male", cbg, false);
c2 = new Checkbox("Female", cbg, false);
t11 = new TextField();
t2 = new TextField();
t3 = new TextField();
t4 = new TextField();
t5 = new TextField();
t6 = new TextField();
t7 = new TextField();
t8 = new TextField();
t9 = new TextField();
t10 = new TextField();
try {
t1 = new Choice();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:raman1");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from mprofile");
while (rs.next()) {
String a2 = rs.getString(3);
t1.add(a2);
}
} catch (Exception e) {
System.out.println(e);
}
b1 = new Button("Search");
b2 = new Button("Update");
b3 = new Button("Calendar");
b4 = new Button("Close");
b5 = new Button("Back");
b6 = new Button("Logout");
f1 = new Font("sherif", Font.BOLD | Font.ITALIC, 45);
f2 = new Font("sherif", Font.BOLD | Font.ITALIC, 30);
f3 = new Font("sherif", Font.BOLD | Font.ITALIC, 35);
f4 = new Font("sherif", Font.BOLD, 20);
f5 = new Font("sherif", Font.BOLD | Font.ITALIC, 15);
f6 = new Font("sherif", Font.BOLD | Font.ITALIC, 20);
l1.setFont(f5);
l2.setFont(f1);
l3.setFont(f6);
l4.setFont(f6);
l5.setFont(f6);
l6.setFont(f6);
l7.setFont(f6);
l8.setFont(f6);
l9.setFont(f6);
l10.setFont(f6);
l11.setFont(f6);
l12.setFont(f6);
l13.setFont(f6);
l14.setFont(f6);
b1.setFont(f6);
b2.setFont(f6);
b3.setFont(f6);
b4.setFont(f6);
b5.setFont(f6);
b6.setFont(f6);
}
public void actionPerformed(ActionEvent e) {
String a, b, c, f, g, h, j, k, l, m, n, o, p, tol = "";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:db2");
stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
} catch (Exception error) {
System.out.println(error);
}
if (e.getSource() == student) {
name = "Student";
cl.show(pnc, "cstu");
try {
rs = stm.executeQuery("Select * from Student");
rs.next();
t1.setText(rs.getString(1));
t2.setText(rs.getString(2));
t3.setText(rs.getString(3));
t4.setText(rs.getString(4));
t5.setText(rs.getString(5));
t6.setText(rs.getString(6));
} catch (Exception error) {
System.out.println(error);
}
}
if (e.getSource() == teacher) {
name = "Teacher";
cl.show(pnc, "ctea");
try {
rs = stm.executeQuery("Select * from Teacher");
rs.next();
t11.setText(rs.getString(1));
t12.setText(rs.getString(2));
t13.setText(rs.getString(3));
t14.setText(rs.getString(4));
} catch (Exception error) {
System.out.println(error);
}
}
if (e.getSource() == course) {
name = "Course";
cl.show(pnc, "ccou");
try {
rs = stm.executeQuery("Select * from Course");
rs.next();
t7.setText(rs.getString(1));
t8.setText(rs.getString(2));
t9.setText(rs.getString(3));
t0.setText(rs.getString(4));
} catch (Exception error) {
System.out.println(error);
}
}
if (e.getSource() == result) {
name = "Result";
cl.show(pnc, "cres");
try {
rs = stm.executeQuery("Select * from Result");
rs.next();
t15.setText(rs.getString(1));
t16.setText(rs.getString(2));
t17.setText(rs.getString(3));
t18.setText(rs.getString(4));
t19.setText(rs.getString(5));
t20.setText(rs.getString(6));
t21.setText(rs.getString(7));
t22.setText(rs.getString(8));
t23.setText(rs.getString(9));
t24.setText(rs.getString(10));
t25.setText(rs.getString(11));
t26.setText(rs.getString(12));
t27.setText(rs.getString(13));
} catch (Exception error) {
System.out.println(error);
}
}
if (e.getSource() == b6) {
Vector cols = new Vector();
Vector rows = new Vector();
if (z == 1) {
String sql = "Select * from " + co;
try {
rs = stm.executeQuery(sql);
meta = rs.getMetaData();
for (int i = 1; i <= meta.getColumnCount(); i++) cols.addElement(meta.getColumnName(i));
while (rs.next()) {
Vector currow = new Vector();
for (int i = 1; i <= meta.getColumnCount(); i++) currow.addElement(rs.getString(i));
rows.addElement(currow);
}
} catch (Exception ex) {
System.out.print(ex);
}
tb = new JTable(rows, cols);
js = new JScrollPane(tb);
pne2.remove(js);
pne2.add(blk, "bb");
cl2.show(pne2, "bb");
pne2.add(js, "jjs");
cl2.show(pne2, "jjs");
pne2.remove(blk);
z = 0;
}
}
if (e.getSource() == b1) // **** ADD BUTTON ****//
{
if (name == "Student") {
a = t1.getText();
b = t2.getText();
c = t3.getText();
f = t4.getText();
g = t5.getText();
h = t6.getText();
tol =
"Insert into Student values ('"
+ a
+ "','"
+ b
+ "','"
+ c
+ "','"
+ f
+ "','"
+ g
+ "','"
+ h
+ "')";
}
if (name == "Teacher") {
a = t11.getText();
b = t12.getText();
c = t13.getText();
f = t14.getText();
tol = "Insert into Teacher values ('" + a + "','" + b + "','" + c + "','" + f + "')";
}
if (name == "Course") {
a = t7.getText();
b = t8.getText();
c = t9.getText();
f = t0.getText();
tol = "Insert into Course values ('" + a + "','" + b + "','" + c + "','" + f + "')";
}
if (name == "Result") {
a = t15.getText();
b = t16.getText();
c = t17.getText();
f = t18.getText();
g = t19.getText();
h = t20.getText();
j = t21.getText();
k = t22.getText();
l = t23.getText();
m = t24.getText();
n = t25.getText();
o = t26.getText();
p = t27.getText();
tol =
"Insert into Result values ('"
+ a
+ "','"
+ b
+ "','"
+ c
+ "','"
+ f
+ "','"
+ g
+ "','"
+ h
+ "','"
+ j
+ "','"
+ k
+ "','"
+ l
+ "','"
+ m
+ "','"
+ n
+ "','"
+ o
+ "','"
+ p
+ "')";
}
try {
stm.executeUpdate(tol);
} catch (Exception error) {
System.out.println(error);
}
}
if (e.getSource() == b2) // **** DELETE BUTTON ****//
{
if (name == "Student") {
b = t2.getText();
tol = "Delete from Student where Id = '" + b + "'";
}
if (name == "Teacher") {
b = t12.getText();
tol = "Delete from Teacher where Id = '" + b + "'";
}
if (name == "Course") {
b = t8.getText();
tol = "Delete from Course where Id = '" + b + "'";
}
if (name == "Result") {
b = t16.getText();
tol = "Delete from Result where Code = '" + b + "'";
}
try {
stm.executeUpdate(tol);
} catch (Exception error) {
System.out.println(error);
}
}
if (e.getSource() == b3) // **** UPDATE BUTTON ****//
{
if (name == "Student") {
a = t1.getText();
b = t2.getText();
c = t3.getText();
f = t4.getText();
g = t5.getText();
h = t6.getText();
tol =
"Update Student set Name = '"
+ a
+ "', ID = '"
+ b
+ "', Dept = '"
+ c
+ "', CGPA = '"
+ f
+ "', Address = '"
+ g
+ "', Cell = '"
+ h
+ "' where ID = '"
+ b
+ "'";
}
if (name == "Teacher") {
a = t11.getText();
b = t12.getText();
c = t13.getText();
f = t14.getText();
tol =
"Update Teacher set Name = '"
+ a
+ "', ID = '"
+ b
+ "', Dept = '"
+ c
+ "', Course = '"
+ f
+ "' where ID = '"
+ b
+ "'";
}
if (name == "Course") {
a = t7.getText();
b = t8.getText();
c = t9.getText();
f = t0.getText();
tol =
"Update Course set Name = '"
+ a
+ "', Code = '"
+ b
+ "', Credit = '"
+ c
+ "', Prerecusite = '"
+ f
+ "' where Code = '"
+ b
+ "'";
}
if (name == "Result") {
a = t15.getText();
b = t16.getText();
c = t17.getText();
f = t18.getText();
g = t19.getText();
h = t20.getText();
j = t21.getText();
k = t22.getText();
l = t23.getText();
m = t24.getText();
n = t25.getText();
o = t26.getText();
p = t27.getText();
tol =
"Update Result set Course = '"
+ a
+ "', Code = '"
+ b
+ "', Credit = '"
+ c
+ "', A = '"
+ f
+ "', B+ = '"
+ g
+ "', B = '"
+ h
+ "', C+ = '"
+ j
+ "', C = '"
+ k
+ "', D+ = '"
+ l
+ "', D = '"
+ m
+ "', F = '"
+ n
+ "', I = '"
+ o
+ "', W = '"
+ p
+ "' where Code = '"
+ b
+ "'";
// JOptionPane.showMessageDialog(null,tol,null,JOptionPane.PLAIN_MESSAGE);
// tol = "Update Result set Course = '"+a+"', Code = '"+b+"', Credit = '"+c+"' where Code =
// '"+b+"'";
}
try {
stm.executeUpdate(tol);
} catch (Exception error) {
System.out.println(error);
}
}
if (e.getSource() == b4) // **** NEXT BUTTON ****//
{
if (name == "Student") {
try {
if (rs.next()) {
t1.setText(rs.getString(1));
t2.setText(rs.getString(2));
t3.setText(rs.getString(3));
t4.setText(rs.getString(4));
t5.setText(rs.getString(5));
t6.setText(rs.getString(6));
}
} catch (Exception error) {
System.out.println(error);
}
}
if (name == "Teacher") {
try {
if (rs.next()) {
t11.setText(rs.getString(1));
t12.setText(rs.getString(2));
t13.setText(rs.getString(3));
t14.setText(rs.getString(4));
}
} catch (Exception error) {
System.out.println(error);
}
}
if (name == "Course") {
try {
if (rs.next()) {
t7.setText(rs.getString(1));
t8.setText(rs.getString(2));
t9.setText(rs.getString(3));
t0.setText(rs.getString(4));
}
} catch (Exception error) {
System.out.println(error);
}
}
if (name == "Result") {
try {
if (rs.next()) {
t15.setText(rs.getString(1));
t16.setText(rs.getString(2));
t17.setText(rs.getString(3));
t18.setText(rs.getString(4));
t19.setText(rs.getString(5));
t20.setText(rs.getString(6));
t21.setText(rs.getString(7));
t22.setText(rs.getString(8));
t23.setText(rs.getString(9));
t24.setText(rs.getString(10));
t25.setText(rs.getString(11));
t26.setText(rs.getString(12));
t27.setText(rs.getString(13));
}
} catch (Exception error) {
System.out.println(error);
}
}
}
if (e.getSource() == b5) // **** PREVIOUS BUTTON ****//
{
if (name == "Student") {
try {
if (rs.previous()) {
t1.setText(rs.getString(1));
t2.setText(rs.getString(2));
t3.setText(rs.getString(3));
t4.setText(rs.getString(4));
t5.setText(rs.getString(5));
t6.setText(rs.getString(6));
}
} catch (Exception error) {
System.out.println(error);
}
}
if (name == "Teacher") {
try {
if (rs.previous()) {
t11.setText(rs.getString(1));
t12.setText(rs.getString(2));
t13.setText(rs.getString(3));
t14.setText(rs.getString(4));
}
} catch (Exception error) {
System.out.println(error);
}
}
if (name == "Course") {
try {
if (rs.previous()) {
t7.setText(rs.getString(1));
t8.setText(rs.getString(2));
t9.setText(rs.getString(3));
t0.setText(rs.getString(4));
}
} catch (Exception error) {
System.out.println(error);
}
}
if (name == "Result") {
try {
if (rs.previous()) {
t15.setText(rs.getString(1));
t16.setText(rs.getString(2));
t17.setText(rs.getString(3));
t18.setText(rs.getString(4));
t19.setText(rs.getString(5));
t20.setText(rs.getString(6));
t21.setText(rs.getString(7));
t22.setText(rs.getString(8));
t23.setText(rs.getString(9));
t24.setText(rs.getString(10));
t25.setText(rs.getString(11));
t26.setText(rs.getString(12));
t27.setText(rs.getString(13));
}
} catch (Exception error) {
System.out.println(error);
}
}
}
}
public QueryDBFrame() {
setTitle("QueryDB");
setSize(400, 300);
addWindowListener(
new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
getContentPane().setLayout(new GridBagLayout());
GridBagConstraints gbc = new GridBagConstraints();
authors = new JComboBox();
authors.setEditable(false);
authors.addItem("Any");
publishers = new JComboBox();
publishers.setEditable(false);
publishers.addItem("Any");
result = new JTextArea(4, 50);
result.setEditable(false);
priceChange = new JTextField(8);
priceChange.setText("-5.00");
try {
// 连接数据库
con = getConnection();
stmt = con.createStatement();
// 将数据库中的作者名添加到组合框
String query = "SELECT Name FROM Authors";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) authors.addItem(rs.getString(1));
// 将出版社名添加到组合框
query = "SELECT Name FROM Publishers";
rs = stmt.executeQuery(query);
while (rs.next()) publishers.addItem(rs.getString(1));
} catch (Exception e) {
result.setText("Error " + e);
}
gbc.fill = GridBagConstraints.NONE;
gbc.weightx = 100;
gbc.weighty = 100;
add(authors, gbc, 0, 0, 2, 1);
add(publishers, gbc, 2, 0, 2, 1);
gbc.fill = GridBagConstraints.NONE;
JButton queryButton = new JButton("Query");
queryButton.addActionListener(this);
add(queryButton, gbc, 0, 1, 1, 1);
JButton changeButton = new JButton("Change prices");
changeButton.addActionListener(this);
add(changeButton, gbc, 2, 1, 1, 1);
gbc.fill = GridBagConstraints.HORIZONTAL;
add(priceChange, gbc, 3, 1, 1, 1);
gbc.fill = GridBagConstraints.BOTH;
add(result, gbc, 0, 2, 4, 1);
}
