Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void registerserver(Guild guild){
- String myDriver = "com.mysql.jdbc.Driver";
- String myUrl = "jdbc:mysql://localhost/bot";
- try {
- Class.forName(myDriver);
- Connection conn = DriverManager.getConnection(myUrl, "root", "");
- String query = " insert into servers (ID, LANG, PREMIUM, OWNERID)"
- + " values (?, ?, ?, ?)";
- PreparedStatement preparedStmt = conn.prepareStatement(query);
- preparedStmt.setInt(1, Integer.parseInt(guild.getId()));
- preparedStmt.setInt(2, 1);
- preparedStmt.setInt(3, 0);
- preparedStmt.setInt(4, Integer.parseInt(guild.getOwnerId()));
- preparedStmt.execute();
- conn.close();
- } catch (ClassNotFoundException | SQLException e) {
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment