01.package com.java.myapp;
02.
03.import java.sql.ResultSet;
04.import java.sql.SQLException;
05.import java.sql.Statement;
06.import java.sql.Connection;
07.import java.sql.DriverManager;
08.
09.public class MyClass {
10.
11. public static void main(String[] args) {
12.
13. Connection connect = null;
14. Statement s = null;
15.
16. try {
17. Class.forName("org.mariadb.jdbc.Driver");
19. "?user=root&password=root");
20.
21. s = connect.createStatement();
22.
23. String Name = "Win";
24.
25. String sql = "SELECT * FROM customer WHERE Name LIKE '%" + Name + "%' ";
26.
27. ResultSet rec = s.executeQuery(sql);
28.
29. while((rec!=null) && (rec.next()))
30. {
31. System.out.print(rec.getString("CustomerID"));
32. System.out.print(" - ");
33. System.out.print(rec.getString("Name"));
34. System.out.print(" - ");
35. System.out.print(rec.getString("Email"));
36. System.out.print(" - ");
37. System.out.print(rec.getString("CountryCode"));
38. System.out.print(" - ");
39. System.out.print(rec.getFloat("Budget"));
40. System.out.print(" - ");
41. System.out.print(rec.getFloat("Used"));
42. System.out.println("");
43. }
44.
45. } catch (Exception e) {
46.
47. e.printStackTrace();
48. }
49.
50.
51. try {
52. if(connect != null){
53. s.close();
54. connect.close();
55. }
56. } catch (SQLException e) {
57.
58. e.printStackTrace();
59. }
60.
61. }
62.
63.}
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
