Advertisement
Guest User

Untitled

a guest
May 17th, 2018
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.24 KB | None | 0 0
  1. package mysql;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8.  
  9. public class ConexionJDBC {
  10. String db = "popbl4tienda";
  11. String usuario = "root";
  12. String contrasena = "";
  13. String url = "jdbc:mysql://localhost/"+db+"?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
  14. Connection conexion;
  15. Statement statement = null;
  16. ResultSet result;
  17.  
  18. public ConexionJDBC() {
  19. try {
  20. Class.forName("com.mysql.cj.jdbc.Driver");
  21. conexion = DriverManager.getConnection(url, usuario, contrasena);
  22. if (conexion != null) {
  23. statement = conexion.createStatement();
  24. System.out.println(" Conexion a base de datos " + db + " correcta.");
  25. } else
  26. System.out.println("Conexion fallida.");
  27. } catch (SQLException e) {
  28. e.printStackTrace();
  29. } catch (ClassNotFoundException e) {
  30. e.printStackTrace();
  31. } catch (Exception e) {
  32. e.printStackTrace();
  33. }
  34. }
  35.  
  36. public ResultSet select(String query){
  37. try{
  38. statement = conexion.createStatement();
  39. result = statement.executeQuery(query);
  40. return result;
  41. }catch(SQLException e){
  42. System.out.println("Error al ejecutar el comando select!");
  43. System.out.println(e.toString());
  44. return null;
  45. }
  46. }
  47.  
  48. public int update(String query){
  49. try{
  50. statement = conexion.createStatement();
  51. return statement.executeUpdate(query);
  52. }catch(SQLException e){
  53. System.out.println("Error al ejecutar el comando query");
  54. System.out.println(e.toString());
  55. return -1;
  56. }
  57. }
  58.  
  59. public int delete(String query){
  60. try{
  61. statement = conexion.createStatement();
  62. return statement.executeUpdate(query);
  63. }catch(SQLException e){
  64. System.out.println("Error al ejecutar el comando delete");
  65. System.out.println(e.toString());
  66. return -1;
  67. }
  68. }
  69.  
  70. public void close(){
  71. try{
  72. statement.close();
  73. result.close();
  74. }catch(SQLException e){
  75. System.out.println("Error al cerrar!");
  76. System.out.println(e.toString());
  77. }
  78. }
  79.  
  80.  
  81. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement