01.package com.java.myapp;
02.
03.import java.sql.Connection;
04.import java.sql.DriverManager;
05.import java.sql.ResultSet;
06.import java.sql.SQLException;
07.import java.sql.Statement;
08.
09.public class DatabaseConnect {
10.
11. private static Connection connect = null;
12. private static Statement s = null;
13.
14. public DatabaseConnect()
15. {
16. try {
17. Class.forName("com.mysql.jdbc.Driver");
19. "?user=root&password=root");
20. } catch (ClassNotFoundException e) {
21.
22. e.printStackTrace();
23. } catch (SQLException e) {
24.
25. e.printStackTrace();
26. }
27. }
28.
29. public ResultSet getResultSet(String strSQL)
30. {
31. try {
32. s = connect.createStatement();
33. return s.executeQuery(strSQL);
34. } catch (SQLException e) {
35.
36. e.printStackTrace();
37. }
38. return null;
39. }
40.
41. public Boolean executeQuery(String strSQL)
42. {
43. try {
44. s = connect.createStatement();
45. s.execute(strSQL);
46. return true;
47. } catch (SQLException e) {
48.
49. return false;
50. }
51. }
52.
53. public void closeConnect()
54. {
55. try {
56. if (s != null) {
57. s.close();
58. connect.close();
59. }
60. } catch (SQLException e) {
61.
62. System.out.println(e.getMessage());
63. e.printStackTrace();
64. }
65. }
66.
67.}
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
