Guest User

Untitled

a guest
Dec 26th, 2018
248
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. import java.sql.Driver;
  2. import java.sql.DriverManager;
  3. import java.sql.SQLException;
  4.  
  5. public class Main {
  6. public static void main(String[] args) throws SQLException {
  7. Driver driver;
  8. driver=new com.mysql.cj.jdbc.Driver();
  9. DriverManager.registerDriver(driver);
  10.  
  11.  
  12. // ApiContextInitializer.init();
  13. // TelegramBotsApi telegramBotsApi = new TelegramBotsApi();
  14. // Botstart1 bot = new Botstart1();
  15. // try {
  16. // telegramBotsApi.registerBot(bot);
  17. // } catch (TelegramApiRequestException e) {
  18. // e.printStackTrace();
  19. // }
  20. Bdate ss=new Bdate();
  21. try {
  22. // ss.bd("set names utf8");
  23. ss.bd("update users set username = 'уаыаыы' where userId=535077417");
  24. ss.bs("select username from users where userid=535077417");
  25. System.out.println( ss.res.getString(1));
  26. } catch (SQLException e) {
  27. e.printStackTrace();
  28.  
  29. public class Bdate{
  30. String url = "jdbc:mysql://eu-cdbr-west-02.cleardb.net:3306/heroku_ab7637be43866cf?charset=utf8";
  31. String name="*******";
  32. String password="*******";
  33. Connection con;
  34.  
  35. {
  36. try {
  37. con = DriverManager.getConnection(url,name,password);
  38. } catch (SQLException e) {
  39. e.printStackTrace();
  40. }
  41. }
  42.  
  43. ResultSet res;
  44.  
  45.  
  46. public void bd(String sql) throws SQLException {
  47.  
  48.  
  49.  
  50.  
  51.  
  52. con.createStatement().execute(sql);
  53.  
  54.  
  55.  
  56.  
  57.  
  58.  
  59.  
  60. }
  61. public void bs(String sql)throws SQLException{
  62.  
  63.  
  64.  
  65. res=con.createStatement().executeQuery(sql);
  66. res.next();
Add Comment
Please, Sign In to add comment