Advertisement
Guest User

Untitled

a guest
Mar 18th, 2019
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. Connection conn;
  2. String host ="127.0.0.1:3308"; //server gde je baza podataka ip adresa;
  3. String shema = "nova_vezba";
  4. String user ="root";
  5. String pass="root";
  6.  
  7. String url = "jdbc:mysql://" + host +"/"+shema;
  8. conn = DriverManager.getConnection(url,user,pass);
  9.  
  10. ResultSet result =
  11. conn.createStatement().executeQuery("SELECT * FROM imenik where imk_ime = " + ime +"&&" + "imk_prezime = " + prezime );
  12. ResultSetMetaData rmd = result.getMetaData();
  13. System.out.println(rmd.getColumnType(2) == Types.VARCHAR);
  14.  
  15. while(result.next()){
  16.  
  17. laRezultat.setText(result.getString(2) + " " + result.getString(3)
  18. +" "+result.getDate(4)+" "+result.getString(5));
  19.  
  20.  
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement