Hello
guys !!
Hows
it going ??
Welcome
back to masunduh2,last post,I’ve
shared tutorial about how to edit and update data from mysql database with
netbeans java swing part 13.now i gonna show you the next awesome tutorials How
to search a part data from mysql database with netbeans java(vol.14)
How
do that??
Lets
get started !
Drag
and drop jtextfield component for search the data with java programs into mysql
database.
And
rename to “search_text”
Then,
right click “search_text [ jtextfields ]”
Events
> Key > keyReleased
in
search_textActionPerformed block
Type
or copy all syntax below :
try {
String sql = "select * from dataop where username=?";
pst=connect.prepareStatement(sql);
pst.setString(1, search_text.getText()); // jtextfields name
rst=pst.executeQuery();
if(rst.next())
{
String show1 = rst.getString("id");
// id > field name in mysql database
id_text.setText(show1);// jtextfields name
String show2 = rst.getString("username");
// username > field name in mysql database
user_text.setText(show2); // jtextfields name
String show3 = rst.getString("password");
// password > field name in mysql database
pass_text.setText(show3); // jtextfields name
String show4 = rst.getString("age");
age_text.setText(show4); // jtextfields name
String show5 = rst.getString("email");
email_text.setText(show5); // jtextfields name
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null, e);
}
Now,
if no error in your java swing project you can run that programs
Click
Run > choose Clean and build
project.
Then,
click run again > and select Run File.
Like
image below
Screenshot
Watch
video tutorial how to search the data
from mysql database with netbeans java swing
part
14.
Please write comment,share it, and subscribed !
Don’t forget join on my fanspage now,ok guys !
See you the next awesome and simple tutorials. Bye
!
without class ye code run ho jata kay or jho data mysql may name or table name kon sa
ReplyDelete