1. package DATOS;
3. import java.sql.Connection;
4. import java.sql.DriverManager;
5. import java.sql.SQLException;
7. import java.sql.ResultSet;
8. import java.sql.Statement;
9. public class MyDataAcces {
10. //Datos acceso a la base de datos
11. //declaracion de variables necesarias para la connexión
12. private String _usuario="root";
13. private String _pwd="";
14. private String _bd="db_academicokrw";
15. private String _url="jdbc:mysql://localhost/"+_bd;
17. private Connection conn = null;
18. //metodo que realiza la connexión
20. public MyDataAcces() {
21. try {
22. Class.forName("com.mysql.jdbc.Connection");
24. try {
25. conn = (Connection)DriverManager.getConnection(_url,_usuario,_pwd);
26. } catch (SQLException e) {
27. // TODO Auto-generated catch block
28. e.printStackTrace();
29. }
31. if (conn != null)
32. {
33. System.out.println("Conneción a Base de datos " +_url);
34. }
35. } catch (ClassNotFoundException e) {
36. // TODO Auto-generated catch block
37. e.printStackTrace();
38. }
42. }//CONSTRUCTOR CLASSE MYDATA ACCES
43. //***********************************************************
44. public ResultSet getQuery (String _query)
45. {
46. Statement state = null;
47. ResultSet resultado = null;
49. try {
50. state = (Statement) conn.createStatement();
51. resultado = state.executeQuery(_query);
52. } catch (SQLException e) {
53. // TODO Auto-generated catch block
54. e.printStackTrace();
55. }
57. return resultado;
59. }//fin
60. //Statement = tipo de coneccion
61. //***********************************************************
62. public void setQuery(String _query) {
64. Statement state = null;
66. try {
67. state = (Statement) conn.createStatement();
68. state.execute(_query);
70. } catch (SQLException e) {
71. // TODO Auto-generated catch block
72. e.printStackTrace();
73. }
75. }
77. }

mydataacces