Search data in database using java
Vložit
- čas přidán 17. 03. 2018
- How to search a particular data in SQL Database in Netbeans java | How To Search Values From SQL Database And Set It Into JTextfield ,radiobuttons, checkbox, combobox, jdatechooser, image label In Java
Channel Subscription : goo.gl/FZrbXg
Affilate: amzn.to/2DPwG8d
Find all the videos in the playlist: • Java programming train...
![JAVA - How To Search Between 2 Date2 In MySQL Database In Java NetBeans [ With Source Code ]](http://i.ytimg.com/vi/EZAwkPdeCgU/mqdefault.jpg)
Hello My Brothers and Sisters. My humble request to you, *Please* *Don't* *Forget* *To* *Subscribe*
If you have any problem, Comment down. I will provide you solution as soon as possible.
hello broters can i have your source code or project?
That was awesome thank you
God bless you brother
Hi Indra can you do another tutorial on using a combo box so that the user can search by name or by sno? btw thanks for the awsome tutorials.
Hello Indra, please make a video on how to count number of particular rows from database and then display results in a text field in net beans Java
Hi,
What if I want to make the image feature as optional and I want to save the records without image, how can I avoid not getting java.lang.NullPointerException.
Please show us how to do that because in the real world application there are some instances that you add the details of a person or things but the image of that object is not available.
Effective videos
Thanks for your feedback
brother, we are updating through jtable, my question is, what about our online server? is it changing simultaneously or not?
hi , I want to print the search line using jasper report. How?
Can you search jtable? and select row show in jtextfield.
Thank you Idra for your nice tutorial. I have already subscribe into your channel, but my question:
1. How to embed sql into standalone java app?
2. Can I export those data from sql into .docx, .xlsx, .pdf or other format?
Thanks for your feedback. I have been working to prepare the related videos which you have mentioned. It will be available soon.
Thanks bro, we are together
I got an error saying "java.sql.SQL TransactionRollbackException: A lock could not be obtained within the time requested"
Can you make a video how to print in Java
Bro if u Kindly help me in making search Function in Like Resturant management system
searching eating items using search category ?
Hi i'm Quang. Now, i want to click mouse one button. So the value from textfield is effected and show compatible results in SQL server. I feel quite difficult to execute and help me, please !!
While performing the mouse action click on mouse click instead of click on mouse release
your video only using one textfied can search compatible data, i understand. In my case, i have more one button instead of using textfield to search i use that button to search
Please help me. in minute 8:46 I execute and console show me this error:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
your date is probably empty, that's message point to you that you try to use object with value null.
Indra, I got a question for you. Basically, I am done with displaying data into the jtable and my own search system(search keyword and show data that contains the keyword). Then, I got an update from my project leader to add 1 more column in the middle of the table. Then, I added it and change the code according to my table addition.
Somehow, after changing the code, when I run the application and show all the data, it wont show the data for the column that I just added in. In that exact column and onwards, it puts in the data for the "next column", hence leaving the last column blank.
But, when I search for a keyword, the table worked perfectly and the data shows exactly how it is supposed to. When I looked at my code, there is no difference at all except the query for showing the data(obviously).
I hope you understand my question and are able to help me. Thank you.
You may not have added column in the jtable for new data. Add a column and set the value in the code
If you read my question carefully, I already said that "I got an update from my project leader to add 1 more column in the middle of the table. Then, I ADDED IT...."
Here to simplify my concern. Lets say I created a table with 7 column, the names of each column are in alphabets so A to G(A column- B column- C column- D column- E column- F column- G column). The data shows exactly how it should be and the search system is also working perfectly.
Then, my project leader asked me to add H column between column D and column E. I added H column between them, so my table now is A column- B column- C column- D column- H column- E column- F column- G column(8 column in total). I also CHANGED THE CODE ACCORDING TO MY TABLE ADDITION. I have 2 kind of show function, 1 for show all the data, and 1 to show the data based on the keyword in the search textfield.
When I tried to show all the data, the function did not work well, starting from H column. H column showed E data, E column showed F data, F column showed G data. At the end, G column shows nothing and H data didnt show up at all.
But when I show the data based on the searched keyword. It shows perfectly. Each column shows each of their data match and no column is blank. Then, the problem should be in the show all data function right? But no, it is the exact code with the other and the only difference is in the query since this need to show all and the other function need to show only based on the keyword as I already mentioned above.
Send me your code on indrasubedi95@gmail.com
Alright, will do. We will discuss this in the email. I have another question. I have a column for tax and it has decimal numbers. What type should I use for this column?
nice screen...
I have doubt so pl. let me know how can i contact u sir
what does rs.next() mean
Like cursor moves to next row
Then how it is getting data of the current row ??????
What can I fix this error
java.sql.SQLException: invalid operation at current cursor position
I complete with input data into SQL Database, but when I need to display them it fail to show data into table and show up the above error
Find the solution on
stackoverflow.com/questions/32803849/invalid-operation-at-current-cursor-position-java-db
Can i Search pdf file with same search box and fetch pdf window over my html page.
please reply.
Yes, you need to add extra code to create pdf window
@@indrasubedi thank you for your reply , can you share any link related to this, it will helpful
From where lb1.image in 3:01 please ?
Please tell us that is there any way to add Searching and Sorting Algorithms.
Searching done in my video. I havent done for sorting. I am not sure about sorting. But in programming it is possible to sort. Please find the related video.
Is there a sourcecode for this?
How can i contact u?
How can i get the Source Code?
source for this?
can you drop the sourcecode pleasee...................
Hello !! Brother, Indra !
My search textfield is not working properly. May I send my code to your g-mail id ?. I have tried a lot to solve it . All fields are displaying their respective data but Date field remains empty and a message pop ups:- " java.sql.SQLDataException: The syntax of the string representation of a date/time value is incorrect ".
Please help me.
Your videos are very much helpful