Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String id = null;
- String root="root",student="root";
- String h=""%";
- String t="%"";
- String name=jTextField1.getText();
- String fname=h+name+t;
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection
- con=(Connection)DriverManager.getConnection
- ("jdbc:mysql://localhost:3306/dijlafinal1",root,student);
- String query2="SELECT * FROM name WHERE name like ? ";
- PreparedStatement pstm2=null;
- pstm2.setString(1,fname);
- pstm2=con.prepareStatement(query2);
- String name1="";
- ResultSet rs = pstm2.executeQuery();
- while (rs.next()){
- name1=rs.getString("name");
- id= rs.getString("id");
- int epo =rs.getInt("epo");
- }
- jTextField2.setText(name1);
- jTextField3.setText(fname);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement