Example
#{example}"); ipb.editor_values.get('templates')['togglesource'] = new Template(""); ipb.editor_values.get('templates')['toolbar'] = new Template(""); ipb.editor_values.get('templates')['button'] = new Template("
Emoticons
"); // Add smilies into the mix ipb.editor_values.set( 'show_emoticon_link', false ); ipb.editor_values.set( 'bbcodes', $H({"snapback":{"id":"1","title":"Post Snap Back","desc":"This tag displays a little linked image which links back to a post - used when quoting posts from the board. Opens in same window by default.","tag":"snapback","useoption":"0","example":"[snapback]100[/snapback]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"topic":{"id":"5","title":"Topic Link","desc":"This tag provides an easy way to link to a topic","tag":"topic","useoption":"1","example":"[topic=1]Click me![/topic]","switch_option":"0","menu_option_text":"Enter the topic ID","menu_content_text":"Enter the title for this link","single_tag":"0","optional_option":"0","image":""},"post":{"id":"6","title":"Post Link","desc":"This tag provides an easy way to link to a post.","tag":"post","useoption":"1","example":"[post=1]Click me![/post]","switch_option":"0","menu_option_text":"Enter the Post ID","menu_content_text":"Enter the title for this link","single_tag":"0","optional_option":"0","image":""},"spoiler":{"id":"7","title":"Spoiler","desc":"Spoiler tag","tag":"spoiler","useoption":"0","example":"[spoiler]Some hidden text[/spoiler]","switch_option":"0","menu_option_text":"","menu_content_text":"Enter the text to be masked","single_tag":"0","optional_option":"0","image":""},"acronym":{"id":"8","title":"Acronym","desc":"Allows you to make an acronym that will display a description when moused over","tag":"acronym","useoption":"1","example":"[acronym='Laugh Out Loud']lol[/acronym]","switch_option":"0","menu_option_text":"Enter the description for this acronym (EG: Laugh Out Loud)","menu_content_text":"Enter the acronym (EG: lol)","single_tag":"0","optional_option":"0","image":""},"hr":{"id":"12","title":"Horizontal Rule","desc":"Adds a horizontal rule to separate text","tag":"hr","useoption":"0","example":"[hr]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"1","optional_option":"0","image":""},"php":{"id":"14","title":"PHP Code","desc":"Allows you to enter PHP code into a formatted/highlighted syntax box","tag":"php","useoption":"0","example":"[php]$variable = true;\n\nprint_r($variable);[/php]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"html":{"id":"15","title":"HTML Code","desc":"Allows you to enter formatted/syntax-highlighted HTML code","tag":"html","useoption":"0","example":"[html]\n \n[/html]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"sql":{"id":"16","title":"SQL Code","desc":"Allows you to enter formatted/syntax-highlighted SQL code","tag":"sql","useoption":"0","example":"[sql]SELECT p.*, t.* FROM posts p LEFT JOIN topics t ON t.tid=p.topic_id WHERE t.tid=7[/sql]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"xml":{"id":"17","title":"XML Code","desc":"Allows you to enter formatted/syntax-highlighted XML code","tag":"xml","useoption":"0","example":"[xml] 4 Replies - 22 Views - Last Post: Today, 12:47 PM Rate Topic: 
#1 Raha69 ?
Reputation: 0
- Posts: 4
- Joined: 08-April 13
Posted Today, 12:01 PM
I Have this code, whereby I want to update my database in microsoft access for seatNumbers...The table have the following fields, seat1, seat2,seat3, seat4 and seat5.
So when the user confirms the seats to be booked, e.g there are 5 seats in the form of JButton(5). The record for that row in the database is
supposed to be updated to booked. When user clicks button1 then seat1 column is changed to booked. and should go on for the next 5 buttons.
So far I can only do for one button and update one field, however when i try to add other buttons,
my database do have so many records and i only need one record to be updated not multiple.this is for modifyDB() method.
For the method bookedSeatDB(), it supposed to connect to the database and if seat is still empty, it will display green when it is booked then it will be red and not possible for the user to click on it
Am new to java programming and I really wish to be understand my mistakes in terms of coding.
The problem are on this 2 methods.Hopeful u understand my explanation
Thank you in advance
public void bookedSeatsDB() { try{ String xx = "Select * FROM myBus"; Connection con = DriverManager.getConnection("jdbc:odbc:BusDetails"); tatement st = con.createStatement(); ResultSet rs = st.executeQuery(xx); while (rs.next()){ // My Problem is on this part as once I click then it changes all three buttons seatButtons[0].setText(rs.getString("Seat1")); seatButtons[0].setBackground(Color.RED); seatButtons[0].setEnabled(false); seatButtons[1].setText(rs.getString("Seat2")); seatButtons[1].setBackground(Color.RED); seatButtons[1].setEnabled(false); seatButtons[2].setText(rs.getString("Seat3")); seatButtons[2].setBackground(Color.RED); seatButtons[2].setEnabled(false); }//end of while JOptionPane.showMessageDialog(null, "Seat 1 is already Booked") ; }//wnd of try catch (Exception eva){ System.out.println("Cannot Connect to Databse"); } }
public void modifyDB(){ try{ //DBConnection(); String st1 = seatButtons[0].getText(); String st2 = seatButtons[1].getText(); String st3 = seatButtons[2].getText(); String st4 = seatButtons[3].getText(); String st5 = seatButtons[4].getText(); //I have tried update but its is not favouring the solution //String updst1 = "UPDATE myBus SET seat1 = Booked WHERE FromCol = Ipoh "; String dataInsertion = "Insert into myBus (seat1) VALUES ('" + st1 + "') "; st.executeUpdate(updst1); String changeSeat2 = "Insert into myBus (seat2) VALUES ('" + st2 + "') "; st.executeUpdate(changeSeat2); String changeSeat3 = "Insert into myBus (seat3) VALUES ('" + st3 + "') "; st.executeUpdate(changeSeat3); String changeSeat4 = "Insert into myBus (seat4) VALUES ('" + st4 + "') "; st.executeUpdate(changeSeat4); String changeSeat5 = "Insert into myBus (seat5) VALUES ('" + st5 + "') "; st.executeUpdate(changeSeat5); } catch (Exception even) { }
Is This A Good Question/Topic? 0
Replies To: updating database and JButtons
#2 andrewsw ? 
Reputation: 810
- Posts: 2,512
- Joined: 12-December 12
Re: updating database and JButtons
Posted Today, 12:21 PM
The first thing I suggest that you do is to remove those try..catch statements; you need to see all errors messages while developing your application.Quote
So far I can only do for one button and update one field, however when i try to add other buttons,my database do have so many records and i only need one record to be updated not multiple.this is for modifyDB() method.
For the method bookedSeatDB(), it supposed to connect to the database and if seat is still empty, it will display green when it is booked then it will be red and not possible for the user to click on it
You need to use a WHERE clause so that an UPDATE will only update specific records. In the UPDATE statement that you attempted you need to include apostrophes around text-values (as you did with you SET statements). I assume, also, that Ipoh is a variable(?) (defined somewhere) in which case it needs to be split out from the expression, as you did further down with st1, st2.
For the second point you need to examine the data retrieved from the database, and use an if statement, based on a value from the database, to paint something red or green. Google and study how to retrieve data from a database, although there may be tutorials available here at DIC.
This post has been edited by andrewsw: Today, 12:22 PM
#3 andrewsw ?
Reputation: 810
- Posts: 2,512
- Joined: 12-December 12
Re: updating database and JButtons
Posted Today, 12:26 PM
You are using while (rs.next()) to loop through the recordset but you aren't doing anything with the data in this recordset - such as using an if-statement to paint something red or green.This post has been edited by andrewsw: Today, 12:27 PM
#4 g00se ?
Reputation: 2030
- Posts: 8,476
- Joined: 20-September 08
Re: updating database and JButtons
Posted Today, 12:30 PM
Quote
The table have the following fields, seat1, seat2,
seat3, seat4 and seat5.
That's not the way to do it. A Seat entity has a principal attribute of 'Number'. You could make that the primary key. A Bookings table would map a User to one or more seats.
#5 andrewsw ?
Reputation: 810
- Posts: 2,512
- Joined: 12-December 12
Re: updating database and JButtons
Posted Today, 12:47 PM
Quote
The table have the following fields, seat1, seat2,
seat3, seat4 and seat5.
That's not the way to do it. A Seat entity has a principal attribute of 'Number'. You could make that the primary key. A Bookings table would map a User to one or more seats.
I quite agree
the database is poorly constructed and this should be OPs prime concern. Page 1 of 1
Source: http://www.dreamincode.net/forums/topic/318492-updating-database-and-jbuttons/
michael beasley jermaine jones hbo luck unc asheville stephen jackson marchmadness mike d antoni
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন