开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > MySQL数据库 > 查看源码
sqlManager.java
资源名称：travel_sql.rar　[点击查看]
上传用户：flow_meter
上传日期：2022-03-21
资源大小：40k
文件大小：5k
源码类别：

MySQL数据库

开发平台：

SQL

sqlManager.java：源码内容
  1. package sql_lab;
  2. import java.sql.*;
  4. /*
  5.  * 数据库操作接口类
  6.  */
  7. public class sqlManager {
  9. private static final String SQL_CLASSPATH="org.gjt.mm.mysql.Driver";
  10. private static final String SQL_URL="jdbc:mysql://222.201.145.113:3306/shop"; 
  11. private static final String SQL_USER="guo";
  12. private static final String SQL_PASSWORD="password";
  13. //tables
  14. public static final String tb_producer="producer";
  15. public static final String tb_produce="produce";
  16. public static final String tb_repair="repair";
  17. public static final String tb_sell="sell";
  18. public static final String tb_store="store";
  19. public static final String tb_customer="customer";
  20. public static final String tb_user="user";
  21. public static final String tb_repair_shop="repair_shop";
  22. public static final String tb_fitting_result="result";
  23. /*
  24.  * row
  25.  */
  26. // table sell
  27. public  static final String row_sell_id="sell_id";
  28. public  static final String row_sell_store_id="sell_store_id";
  29. public  static final String row_sell_produce_id="sell_produce_id";
  30. public  static final String row_sell_customer_id="sell_customer_id";
  31. public  static final String row_sell_amount="sell_amount";
  32. public  static final String row_sell_time="sell_time";
  33. //table store
  34. public  static final String row_store_id="store_id";
  35. public  static final String row_store_name="store_name";
  36. public  static final String row_store_address="store_address";
  37. public  static final String row_store_keeper="store_keeper";
  38. public  static final String row_store_call="store_call";
  39. //table customer
  40. public  static final String row_customer_id="customer_id";
  41. public  static final String row_customer_name="customer_name";
  42. public  static final String row_customer_address="customer_address";
  43. public  static final String row_customer_call="customer_call";
  44. public  static final String row_customer_mail="customer_mail";
  45. public  static final String row_customer_register="customer_register";
  46. //table produce
  47. public  static final String row_produce_id="produce_id";
  48. public  static final String row_produce_name="produce_name";
  49. public  static final String row_produce_funtion="produce_funtion";
  50. public  static final String row_produce_price="produce_price";
  51. public  static final String row_produce_sort="produce_sort";
  52. public  static final String row_produce_producer_id="producer_id";
  53. //table producer
  54. public  static final String row_producer_id="producer_id";
  55. public  static final String row_producer_name="producer_name";
  56. public  static final String row_producer_address="producer_address";
  57. public  static final String row_producer_call="producer_call";
  58. public  static final String row_producer_describe="producer_describe";
  59. //table repair
  60. public  static final String row_repair_id="repair_id";
  61. public  static final String row_repair_time="repair_time";
  62. public  static final String row_repair_information="repair_information";
  63. public  static final String row_repair_produce_id="repair_produce_id";
  64. public  static final String row_repair_customer_id="repair_customer_id";
  65. public  static final String row_repair_repair_shop_id="repair_repair_shop_id";
  66. //talbe repair_shop
  67. public  static final String row_repair_shop_id="repair_shop_id";
  68. public  static final String row_repair_shop_name="repair_shop_name";
  69. public  static final String row_repair_shop_address="repair_shop_address";
  70. public  static final String row_repair_shop_keeper="repair_shop_keeper";
  71. public  static final String row_repair_shop_call="repair_shop_call";
  72. //table result
  73. public  static final String row_result_id="id";
  75. private static Connection dbConn=null;
  76. private static Statement statement=null;
  77. public static sqlManager sqlManager=null;
  80. private sqlManager(){
  81. try{
  82. Class.forName(sqlManager.SQL_CLASSPATH).newInstance();
  83. dbConn=DriverManager.getConnection(SQL_URL,SQL_USER,SQL_PASSWORD);
  84. statement=dbConn.createStatement();
  86. System.out.println("Connection successful ");
  87. }
  88. catch(Exception e){
  89. e.printStackTrace();
  90. }
  92. }
  93. public static sqlManager getSqlManager(){
  94. if(null==sqlManager.sqlManager)
  95. sqlManager=new sqlManager();
  96. return sqlManager.sqlManager;
  97. }
  98. public  ResultSet executeQuery(String sql){
  99. ResultSet rs=null;
  100. try{
  101. rs=statement.executeQuery(sql);
  102. }
  103. catch(SQLException se){
  104. System.out.println("executeQuery error"+se.getMessage());
  105. }
  106. return rs;
  107. }
  108. public int executeUpdate(String sql){
  109. int count=0;
  111. try{
  112. count=statement.executeUpdate(sql);//执行更新操作
  113. }
  114. catch(SQLException sqle){
  115. System.out.println("executeUpdate error"+sqle.getMessage());
  116. count=0;
  117. }
  118. return count;
  119. }
  120. public static void closeSqlManager(){
  121. if(null!=sqlManager.sqlManager){
  122. try{
  123. statement.close();
  124. dbConn.close();
  125. }
  126. catch(Exception e){
  127. e.printStackTrace();
  128. }
  129. }
  130. }
  132. }