Monday, April 15, 2013

Updating Database And JButtons - Java | Dream.In.Code


Example
#{example}
"); ipb.editor_values.get('templates')['togglesource'] = new Template("
??? Cancel Source Edit
"); ipb.editor_values.get('templates')['toolbar'] = new Template(""); ipb.editor_values.get('templates')['button'] = new Template("
  • Icon
  • "); ipb.editor_values.get('templates')['menu_item'] = new Template("
  • #{title}
  • "); ipb.editor_values.get('templates')['togglesource'] = new Template("
    ??? Cancel Source Edit
    "); ipb.editor_values.get('templates')['emoticons_showall'] = new Template(""); ipb.editor_values.get('templates')['emoticon_wrapper'] = 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]\n \n Test\n \n[/xml]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"member":{"id":"31","title":"Member","desc":"Given a member name, a link is automatically generated to the member's profile","tag":"member","useoption":"1","example":"[member=skyhawk133] runs this site.","switch_option":"0","menu_option_text":"Input Username of Member","menu_content_text":"","single_tag":"1","optional_option":"0","image":"memberbbcode.png"},"extract":{"id":"33","title":"Extract Blog Entry","desc":"This will allow users to define an extract for an entry. Only this piece of the entry will be displayed on the main blog page and will show up in the RSS feed.","tag":"extract","useoption":"0","example":"[extract]This is an example![/extract]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"blog":{"id":"34","title":"Blog Link","desc":"This tag provides an easy way to link to a blog.","tag":"blog","useoption":"1","example":"[blog=100]Click me![/blog]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"entry":{"id":"35","title":"Blog Entry Link","desc":"This tag provides an easy way to link to a blog entry.","tag":"entry","useoption":"1","example":"[entry=100]Click me![/entry]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"twitter":{"id":"36","title":"Twitter","desc":"A tag to link to a user's twitter account","tag":"twitter","useoption":"0","example":"[twitter]userName[/twitter]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":"twitter.png"},"inline":{"id":"37","title":"Inline Code","desc":"Formats code inline instead of in a seperate code box. ","tag":"inline","useoption":"0","example":"[inline]style=\"font-size: 12px;\"[/inline]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"il":{"id":"38","title":"Abbreviated Inline (IL)","desc":"Abbreviated version of the [inline] tag. ","tag":"il","useoption":"0","example":"[il]Code Here[/il]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":"il2.png"},"code":{"id":"41","title":"Code","desc":"Allows you to enter general code","tag":"code","useoption":"1","example":"[code]$text = 'Some long code here';[/code]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"1","image":""}}) ); ipb.vars['emoticon_url'] = "http://cdn.dreamincode.net/forums/public/style_emoticons/default"; //Search Setup ipb.vars['search_type'] = 'forum'; ipb.vars['search_type_id'] = 32; ipb.vars['search_type_2'] = 'topic'; ipb.vars['search_type_id_2'] = 318492; //]]>

    4 Replies - 22 Views - Last Post: Today, 12:47 PM Rate Topic: -----

    #1 Raha69 ?Icon User is offline

    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 ?Icon User is online

    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 ?Icon User is online

    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 ?Icon User is online

    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 ?Icon User is online

    Reputation: 810

    • Posts: 2,512
    • Joined: 12-December 12

    Re: updating database and JButtons

    Posted Today, 12:47 PM

    View Postg00se, on 14 April 2013 - 07:30 PM, said:

    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/

    Griselda Blanco Michelle Obama Speech eva longoria Michael Clarke Duncan Nazanin Boniadi Deval Patrick Dedication 4

    No comments:

    Post a Comment

    Note: Only a member of this blog may post a comment.