Advertisement
Guest User

Untitled

a guest
Mar 18th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.49 KB | None | 0 0
  1. try{
  2.     uniqueSubject2 = new ArrayList<>();
  3.     Class.forName("com.mysql.jdbc.Driver");
  4.     Connection con = DriverManager.getConnection("jdbc:mysql://(IPMYSQLSERVER)/(NAMA DATABASE)","(NAMA USER DB)","(PW USER DB)");
  5.     Statement stmt = con.createStatement();
  6.     String sql = "SELECT BLABLABAL SQL QUERY";
  7.     ResultSet rs = stmt.executeQuery(sql);
  8.     while(rs.next()) {
  9.         String code=rs.getString(1);
  10.         String section = rs.getString(2);
  11.     }
  12.     con.close();
  13. }catch(Exception e){
  14.     e.printStackTrace();
  15. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement