Guest User

Untitled

a guest
Feb 11th, 2019
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. public void registerserver(Guild guild){
  2. String myDriver = "com.mysql.jdbc.Driver";
  3. String myUrl = "jdbc:mysql://localhost/bot";
  4. try {
  5. Class.forName(myDriver);
  6. Connection conn = DriverManager.getConnection(myUrl, "root", "");
  7.  
  8. String query = " insert into servers (ID, LANG, PREMIUM, OWNERID)"
  9. + " values (?, ?, ?, ?)";
  10. PreparedStatement preparedStmt = conn.prepareStatement(query);
  11. preparedStmt.setInt(1, Integer.parseInt(guild.getId()));
  12. preparedStmt.setInt(2, 1);
  13. preparedStmt.setInt(3, 0);
  14. preparedStmt.setInt(4, Integer.parseInt(guild.getOwnerId()));
  15. preparedStmt.execute();
  16.  
  17. conn.close();
  18.  
  19.  
  20.  
  21. } catch (ClassNotFoundException | SQLException e) {
  22. e.printStackTrace();
  23. }
  24. }
Add Comment
Please, Sign In to add comment