当前位置:Gxlcms > 数据库问题 > Java创建连接池连接不同数据库

Java创建连接池连接不同数据库

时间:2021-07-01 10:21:17 帮助过:7人阅读

/** 2 * 数据库连接配置信息类 3 * @author Damon 4 */ 5 public class JdbcUrl 6 { 7 8 /** 定义数据库参数 */ 9 10 // 数据库类型 11 private String DBType; 12 // 数据库服务器IP 13 private String IP; 14 // 数据库服务器端口 15 private String Port; 16 // 数据库名称 17 private String DBName; 18 // 用户名 19 private String UserName; 20 // 密码 21 private String PassWord; 22 23 24 /** 25 * 默认构造方法,连接默认数据库 26 */ 27 public JdbcUrl() 28 { 29 // TODO Auto-generated constructor stub 30 DBType = SysCon.DATABASE_TYPE_MYSQL; 31 IP = "127.0.0.1"; 32 DBName = "mysql"; 33 Port = "3306"; 34 UserName = "damon"; 35 PassWord = "damon"; 36 } 37 38 /** 39 * 连接指定数据库 40 * @param urlType 传入连接类型标识 41 */ 42 public JdbcUrl(String urlType) 43 { 44 if ("mysql".equals(urlType)) 45 { 46 DBType = SysCon.DATABASE_TYPE_MYSQL; 47 IP = "127.0.0.1"; 48 DBName = "mysql"; 49 Port = "3306"; 50 UserName = "damon"; 51 PassWord = "damon"; 52 } 53 } 54 55 /** 56 * 获取连接句柄 57 * @return String 58 */ 59 public String getJdbcUrl() 60 { 61 String sUrl = ""; 62 63 if (DBType.trim().toUpperCase().equals("MYSQL")) 64 { 65 sUrl = "jdbc:mysql://" + IP + ":" + Port + "/" + DBName; 66 } 67 else if (DBType.trim().toUpperCase().equals("DB2")) 68 { 69 sUrl = "jdbc:db2://" + IP + ":" + Port + "/" + DBName; 70 } 71 72 else if (DBType.trim().toUpperCase().equals("ORACLE")) 73 { 74 sUrl = "jdbc:oracle:thin:@" + IP + ":" + Port + ":" + DBName; 75 } 76 77 else if (DBType.trim().toUpperCase().equals("SQLSERVER")) 78 { 79 sUrl = "jdbc:microsoft:sqlserver://" + IP + ":" + Port + ";databaseName=" + DBName + ";selectMethod=cursor"; 80 } 81 else if (DBType.trim().toUpperCase().equals("WEBLOGICPOOL")) 82 { 83 sUrl = "jdbc:weblogic:pool:" + DBName; 84 } 85 else 86 { 87 System.out.println("暂无对应数据库驱动"); 88 } 89 return sUrl; 90 } 91 92 // getters and setters 93 94 public String getDBType() 95 { 96 return DBType; 97 } 98 99 public void setDBType(String dBType) 100 { 101 DBType = dBType; 102 } 103 104 public String getIP() 105 { 106 return IP; 107 } 108 109 public void setIP(String iP) 110 { 111 IP = iP; 112 } 113 114 public String getPort() 115 { 116 return Port; 117 } 118 119 public void setPort(String port) 120 { 121 Port = port; 122 } 123 124 public String getDBName() 125 { 126 return DBName; 127 } 128 129 public void setDBName(String dBName) 130 { 131 DBName = dBName; 132 } 133 134 public String getUserName() 135 { 136 return UserName; 137 } 138 139 public void setUserName(String userName) 140 { 141 UserName = userName; 142 } 143 144 public String getPassWord() 145 { 146 return PassWord; 147 } 148 149 public void setPassWord(String passWord) 150 { 151 PassWord = passWord; 152 } 153 154 } View Code

 

2、重写一个Connection类,实现Connection接口的方法,同时连接数据库。

参数有已实现的JdbrUrl类,主要新增方法为:createConnection() 根据DBType来对不同数据库进行处理:加载对应的数据库,然后获取数据库连接。 技术分享 技术分享
  1. <span style="color: #008080"> 1</span> **
  2. <span style="color: #008080"> 2</span> *<span style="color: #000000"> 数据库连接类,连接数据库
  3. </span><span style="color: #008080"> 3</span> *<span style="color: #000000"> @author Damon
  4. </span><span style="color: #008080"> 4</span> */
  5. <span style="color: #008080"> 5</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span> DBConn <span style="color: #0000ff">implements</span><span style="color: #000000"> Connection
  6. </span><span style="color: #008080"> 6</span> <span style="color: #000000">{
  7. </span><span style="color: #008080"> 7</span>
  8. <span style="color: #008080"> 8</span> <span style="color: #008000">//</span><span style="color: #008000"> 获取JdbcUrl信息</span>
  9. <span style="color: #008080"> 9</span> <span style="color: #0000ff">private</span><span style="color: #000000"> JdbcUrl JUrl;
  10. </span><span style="color: #008080"> 10</span>
  11. <span style="color: #008080"> 11</span> <span style="color: #008000">//</span><span style="color: #008000"> 数据库连接</span>
  12. <span style="color: #008080"> 12</span> <span style="color: #0000ff">private</span> Connection con = <span style="color: #0000ff">null</span><span style="color: #000000">;
  13. </span><span style="color: #008080"> 13</span>
  14. <span style="color: #008080"> 14</span> <span style="color: #008000">//</span><span style="color: #008000"> 连接是否已使用</span>
  15. <span style="color: #008080"> 15</span> <span style="color: #0000ff">private</span> <span style="color: #0000ff">boolean</span><span style="color: #000000"> bNotInUse;
  16. </span><span style="color: #008080"> 16</span>
  17. <span style="color: #008080"> 17</span> <span style="color: #0000ff">private</span> CharArrayWriter m_buf = <span style="color: #0000ff">new</span><span style="color: #000000"> CharArrayWriter();
  18. </span><span style="color: #008080"> 18</span>
  19. <span style="color: #008080"> 19</span> <span style="color: #0000ff">private</span> PrintWriter m_pw = <span style="color: #0000ff">new</span> PrintWriter(m_buf, <span style="color: #0000ff">true</span><span style="color: #000000">);
  20. </span><span style="color: #008080"> 20</span>
  21. <span style="color: #008080"> 21</span> <span style="color: #008000">//</span><span style="color: #008000"> 默认连接</span>
  22. <span style="color: #008080"> 22</span> <span style="color: #0000ff">public</span><span style="color: #000000"> DBConn()
  23. </span><span style="color: #008080"> 23</span> <span style="color: #000000"> {
  24. </span><span style="color: #008080"> 24</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated constructor stub</span>
  25. <span style="color: #008080"> 25</span> <span style="color: #0000ff">this</span>.JUrl = <span style="color: #0000ff">new</span><span style="color: #000000"> JdbcUrl();
  26. </span><span style="color: #008080"> 26</span> <span style="color: #000000"> }
  27. </span><span style="color: #008080"> 27</span>
  28. <span style="color: #008080"> 28</span> <span style="color: #008000">//</span><span style="color: #008000"> 指定数据库连接</span>
  29. <span style="color: #008080"> 29</span> <span style="color: #0000ff">public</span><span style="color: #000000"> DBConn(String urlType)
  30. </span><span style="color: #008080"> 30</span> <span style="color: #000000"> {
  31. </span><span style="color: #008080"> 31</span> <span style="color: #0000ff">this</span>.JUrl = <span style="color: #0000ff">new</span><span style="color: #000000"> JdbcUrl(urlType);
  32. </span><span style="color: #008080"> 32</span> <span style="color: #000000"> }
  33. </span><span style="color: #008080"> 33</span>
  34. <span style="color: #008080"> 34</span> <span style="color: #008000">//</span><span style="color: #008000"> 创建连接</span>
  35. <span style="color: #008080"> 35</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">boolean</span><span style="color: #000000"> createConnection()
  36. </span><span style="color: #008080"> 36</span> <span style="color: #000000"> {
  37. </span><span style="color: #008080"> 37</span>
  38. <span style="color: #008080"> 38</span> <span style="color: #008000">//</span><span style="color: #008000"> 根据数据库类型加载驱动及连接</span>
  39. <span style="color: #008080"> 39</span> <span style="color: #0000ff">try</span>
  40. <span style="color: #008080"> 40</span> <span style="color: #000000"> {
  41. </span><span style="color: #008080"> 41</span> <span style="color: #008000">//</span><span style="color: #008000"> 连接MySQL数据库</span>
  42. <span style="color: #008080"> 42</span> <span style="color: #0000ff">if</span><span style="color: #000000"> (SysCon.DATABASE_TYPE_MYSQL.equals(JUrl.getDBType()))
  43. </span><span style="color: #008080"> 43</span> <span style="color: #000000"> {
  44. </span><span style="color: #008080"> 44</span> <span style="color: #008000">//</span><span style="color: #008000"> 加载数据库驱动</span>
  45. <span style="color: #008080"> 45</span> Class.forName("com.mysql.jdbc.Driver"<span style="color: #000000">);
  46. </span><span style="color: #008080"> 46</span>
  47. <span style="color: #008080"> 47</span> <span style="color: #008000">//</span><span style="color: #008000"> 尝试连接数据库</span>
  48. <span style="color: #008080"> 48</span> con =<span style="color: #000000"> DriverManager.getConnection(JUrl.getJdbcUrl(), JUrl.getUserName(), JUrl.getPassWord());
  49. </span><span style="color: #008080"> 49</span> <span style="color: #000000"> }
  50. </span><span style="color: #008080"> 50</span> <span style="color: #008000">//</span><span style="color: #008000"> 其他数据库类型判断及处理
  51. </span><span style="color: #008080"> 51</span> <span style="color: #008000">//</span><span style="color: #008000"> SQLSERVER</span>
  52. <span style="color: #008080"> 52</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span><span style="color: #000000"> (SysCon.DATABASE_TYPE_SQLSERVER.equals(JUrl.getDBType()))
  53. </span><span style="color: #008080"> 53</span> <span style="color: #000000"> {
  54. </span><span style="color: #008080"> 54</span> Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"<span style="color: #000000">);
  55. </span><span style="color: #008080"> 55</span> con =<span style="color: #000000"> DriverManager.getConnection(JUrl.getJdbcUrl(), JUrl.getUserName(), JUrl.getPassWord());
  56. </span><span style="color: #008080"> 56</span> <span style="color: #000000"> }
  57. </span><span style="color: #008080"> 57</span> <span style="color: #008000">//</span><span style="color: #008000"> DB2</span>
  58. <span style="color: #008080"> 58</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span><span style="color: #000000"> (SysCon.DATABASE_TYPE_DB2.equals(JUrl.getDBType()))
  59. </span><span style="color: #008080"> 59</span> <span style="color: #000000"> {
  60. </span><span style="color: #008080"> 60</span> Class.forName("com.ibm.db2.jcc.DB2Driver"<span style="color: #000000">);
  61. </span><span style="color: #008080"> 61</span> con =<span style="color: #000000"> DriverManager.getConnection(JUrl.getJdbcUrl(), JUrl.getUserName(), JUrl.getPassWord());
  62. </span><span style="color: #008080"> 62</span> <span style="color: #000000"> }
  63. </span><span style="color: #008080"> 63</span> <span style="color: #008000">//</span><span style="color: #008000"> ORACLE</span>
  64. <span style="color: #008080"> 64</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span><span style="color: #000000"> (SysCon.DATABASE_TYPE_ORACLE.equals(JUrl.getDBType()))
  65. </span><span style="color: #008080"> 65</span> <span style="color: #000000"> {
  66. </span><span style="color: #008080"> 66</span> Class.forName("oracle.jdbc.driver.OracleDriver"<span style="color: #000000">);
  67. </span><span style="color: #008080"> 67</span> <span style="color: #008000">//</span><span style="color: #008000"> 一个是缓存取到的记录数,一个是设置默认的批量提交数</span>
  68. <span style="color: #008080"> 68</span> Properties props = <span style="color: #0000ff">new</span><span style="color: #000000"> Properties();
  69. </span><span style="color: #008080"> 69</span> props.setProperty("user"<span style="color: #000000">, JUrl.getUserName());
  70. </span><span style="color: #008080"> 70</span> props.setProperty("password"<span style="color: #000000">, JUrl.getPassWord());
  71. </span><span style="color: #008080"> 71</span> props.setProperty("defaultRowPrefetch", "50"<span style="color: #000000">);
  72. </span><span style="color: #008080"> 72</span> props.setProperty("defaultExecuteBatch", "50"<span style="color: #000000">);
  73. </span><span style="color: #008080"> 73</span> con =<span style="color: #000000"> DriverManager.getConnection(JUrl.getJdbcUrl(), props);
  74. </span><span style="color: #008080"> 74</span> <span style="color: #000000"> }
  75. </span><span style="color: #008080"> 75</span> <span style="color: #0000ff">else</span>
  76. <span style="color: #008080"> 76</span> <span style="color: #000000"> {
  77. </span><span style="color: #008080"> 77</span> System.out.println("未匹配到数据库类型!"<span style="color: #000000">);
  78. </span><span style="color: #008080"> 78</span> <span style="color: #0000ff">return</span> <span style="color: #0000ff">false</span><span style="color: #000000">;
  79. </span><span style="color: #008080"> 79</span> <span style="color: #000000"> }
  80. </span><span style="color: #008080"> 80</span>
  81. <span style="color: #008080"> 81</span> <span style="color: #000000"> }
  82. </span><span style="color: #008080"> 82</span> <span style="color: #0000ff">catch</span><span style="color: #000000"> (ClassNotFoundException e)
  83. </span><span style="color: #008080"> 83</span> <span style="color: #000000"> {
  84. </span><span style="color: #008080"> 84</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated catch block</span>
  85. <span style="color: #008080"> 85</span> System.out.println("加载驱动失败!"<span style="color: #000000">);
  86. </span><span style="color: #008080"> 86</span> <span style="color: #000000"> e.printStackTrace();
  87. </span><span style="color: #008080"> 87</span> <span style="color: #0000ff">return</span> <span style="color: #0000ff">false</span><span style="color: #000000">;
  88. </span><span style="color: #008080"> 88</span> <span style="color: #000000"> }
  89. </span><span style="color: #008080"> 89</span> <span style="color: #0000ff">catch</span><span style="color: #000000"> (SQLException e)
  90. </span><span style="color: #008080"> 90</span> <span style="color: #000000"> {
  91. </span><span style="color: #008080"> 91</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated catch block</span>
  92. <span style="color: #008080"> 92</span> System.out.println("创建连接失败..." +<span style="color: #000000"> e.getMessage());
  93. </span><span style="color: #008080"> 93</span> <span style="color: #000000"> e.printStackTrace();
  94. </span><span style="color: #008080"> 94</span> <span style="color: #0000ff">return</span> <span style="color: #0000ff">false</span><span style="color: #000000">;
  95. </span><span style="color: #008080"> 95</span> <span style="color: #000000"> }
  96. </span><span style="color: #008080"> 96</span> <span style="color: #0000ff">return</span> <span style="color: #0000ff">true</span><span style="color: #000000">;
  97. </span><span style="color: #008080"> 97</span> <span style="color: #000000"> }
  98. </span><span style="color: #008080"> 98</span>
  99. <span style="color: #008080"> 99</span> <span style="color: #0000ff">protected</span> <span style="color: #0000ff">void</span><span style="color: #000000"> setInUse()
  100. </span><span style="color: #008080">100</span> <span style="color: #000000"> {
  101. </span><span style="color: #008080">101</span> <span style="color: #008000">/**</span>
  102. <span style="color: #008080">102</span> <span style="color: #008000"> * Record stack information when each connection is get We reassian
  103. </span><span style="color: #008080">103</span> <span style="color: #008000"> * System.err, so Thread.currentThread().dumpStack() can dump stack info
  104. </span><span style="color: #008080">104</span> <span style="color: #008000"> * into our class FilterPrintStream.
  105. </span><span style="color: #008080">105</span> <span style="color: #008000">*/</span>
  106. <span style="color: #008080">106</span> <span style="color: #0000ff">new</span><span style="color: #000000"> Throwable().printStackTrace(m_pw);
  107. </span><span style="color: #008080">107</span>
  108. <span style="color: #008080">108</span> bNotInUse = <span style="color: #0000ff">false</span><span style="color: #000000">;
  109. </span><span style="color: #008080">109</span>
  110. <span style="color: #008080">110</span> <span style="color: #008000">/**</span>
  111. <span style="color: #008080">111</span> <span style="color: #008000"> * record lastest access time
  112. </span><span style="color: #008080">112</span> <span style="color: #008000">*/</span>
  113. <span style="color: #008080">113</span> <span style="color: #000000"> }
  114. </span><span style="color: #008080">114</span>
  115. <span style="color: #008080">115</span> <span style="color: #008000">/*</span><span style="color: #008000"> 下面都是 实现Connection的方法,返回conn的实现 </span><span style="color: #008000">*/</span>
  116. <span style="color: #008080">116</span> <span style="color: #0000ff">public</span> <T> T unwrap(Class<T> iface) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  117. </span><span style="color: #008080">117</span> <span style="color: #000000"> {
  118. </span><span style="color: #008080">118</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  119. <span style="color: #008080">119</span> <span style="color: #0000ff">return</span> con.unwrap(<span style="color: #0000ff">null</span><span style="color: #000000">);
  120. </span><span style="color: #008080">120</span> <span style="color: #000000"> }
  121. </span><span style="color: #008080">121</span>
  122. <span style="color: #008080">122</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">boolean</span> isWrapperFor(Class<?> iface) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  123. </span><span style="color: #008080">123</span> <span style="color: #000000"> {
  124. </span><span style="color: #008080">124</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  125. <span style="color: #008080">125</span> <span style="color: #0000ff">return</span> <span style="color: #0000ff">false</span><span style="color: #000000">;
  126. </span><span style="color: #008080">126</span> <span style="color: #000000"> }
  127. </span><span style="color: #008080">127</span>
  128. <span style="color: #008080">128</span> <span style="color: #0000ff">public</span> Statement createStatement() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  129. </span><span style="color: #008080">129</span> <span style="color: #000000"> {
  130. </span><span style="color: #008080">130</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  131. <span style="color: #008080">131</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.createStatement();
  132. </span><span style="color: #008080">132</span> <span style="color: #000000"> }
  133. </span><span style="color: #008080">133</span>
  134. <span style="color: #008080">134</span> <span style="color: #0000ff">public</span> PreparedStatement prepareStatement(String sql) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  135. </span><span style="color: #008080">135</span> <span style="color: #000000"> {
  136. </span><span style="color: #008080">136</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  137. <span style="color: #008080">137</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareStatement(sql);
  138. </span><span style="color: #008080">138</span> <span style="color: #000000"> }
  139. </span><span style="color: #008080">139</span>
  140. <span style="color: #008080">140</span> <span style="color: #0000ff">public</span> CallableStatement prepareCall(String sql) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  141. </span><span style="color: #008080">141</span> <span style="color: #000000"> {
  142. </span><span style="color: #008080">142</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  143. <span style="color: #008080">143</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareCall(sql);
  144. </span><span style="color: #008080">144</span> <span style="color: #000000"> }
  145. </span><span style="color: #008080">145</span>
  146. <span style="color: #008080">146</span> <span style="color: #0000ff">public</span> String nativeSQL(String sql) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  147. </span><span style="color: #008080">147</span> <span style="color: #000000"> {
  148. </span><span style="color: #008080">148</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  149. <span style="color: #008080">149</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.nativeSQL(sql);
  150. </span><span style="color: #008080">150</span> <span style="color: #000000"> }
  151. </span><span style="color: #008080">151</span>
  152. <span style="color: #008080">152</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setAutoCommit(<span style="color: #0000ff">boolean</span> autoCommit) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  153. </span><span style="color: #008080">153</span> <span style="color: #000000"> {
  154. </span><span style="color: #008080">154</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  155. <span style="color: #008080">155</span> <span style="color: #000000"> con.setAutoCommit(autoCommit);
  156. </span><span style="color: #008080">156</span> <span style="color: #000000"> }
  157. </span><span style="color: #008080">157</span>
  158. <span style="color: #008080">158</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">boolean</span> getAutoCommit() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  159. </span><span style="color: #008080">159</span> <span style="color: #000000"> {
  160. </span><span style="color: #008080">160</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  161. <span style="color: #008080">161</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.getAutoCommit();
  162. </span><span style="color: #008080">162</span> <span style="color: #000000"> }
  163. </span><span style="color: #008080">163</span>
  164. <span style="color: #008080">164</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> commit() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  165. </span><span style="color: #008080">165</span> <span style="color: #000000"> {
  166. </span><span style="color: #008080">166</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  167. <span style="color: #008080">167</span> <span style="color: #000000"> con.commit();
  168. </span><span style="color: #008080">168</span> <span style="color: #000000"> }
  169. </span><span style="color: #008080">169</span>
  170. <span style="color: #008080">170</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> rollback() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  171. </span><span style="color: #008080">171</span> <span style="color: #000000"> {
  172. </span><span style="color: #008080">172</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  173. <span style="color: #008080">173</span> <span style="color: #000000"> con.rollback();
  174. </span><span style="color: #008080">174</span> <span style="color: #000000"> }
  175. </span><span style="color: #008080">175</span>
  176. <span style="color: #008080">176</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> close() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  177. </span><span style="color: #008080">177</span> <span style="color: #000000"> {
  178. </span><span style="color: #008080">178</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  179. <span style="color: #008080">179</span> <span style="color: #000000"> con.close();
  180. </span><span style="color: #008080">180</span> <span style="color: #000000"> }
  181. </span><span style="color: #008080">181</span>
  182. <span style="color: #008080">182</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">boolean</span> isClosed() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  183. </span><span style="color: #008080">183</span> <span style="color: #000000"> {
  184. </span><span style="color: #008080">184</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  185. <span style="color: #008080">185</span>
  186. <span style="color: #008080">186</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.isClosed();
  187. </span><span style="color: #008080">187</span> <span style="color: #000000"> }
  188. </span><span style="color: #008080">188</span>
  189. <span style="color: #008080">189</span> <span style="color: #0000ff">public</span> DatabaseMetaData getMetaData() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  190. </span><span style="color: #008080">190</span> <span style="color: #000000"> {
  191. </span><span style="color: #008080">191</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  192. <span style="color: #008080">192</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.getMetaData();
  193. </span><span style="color: #008080">193</span> <span style="color: #000000"> }
  194. </span><span style="color: #008080">194</span>
  195. <span style="color: #008080">195</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setReadOnly(<span style="color: #0000ff">boolean</span> readOnly) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  196. </span><span style="color: #008080">196</span> <span style="color: #000000"> {
  197. </span><span style="color: #008080">197</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  198. <span style="color: #008080">198</span> <span style="color: #000000"> con.setReadOnly(readOnly);
  199. </span><span style="color: #008080">199</span> <span style="color: #000000"> }
  200. </span><span style="color: #008080">200</span>
  201. <span style="color: #008080">201</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">boolean</span> isReadOnly() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  202. </span><span style="color: #008080">202</span> <span style="color: #000000"> {
  203. </span><span style="color: #008080">203</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  204. <span style="color: #008080">204</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.isReadOnly();
  205. </span><span style="color: #008080">205</span> <span style="color: #000000"> }
  206. </span><span style="color: #008080">206</span>
  207. <span style="color: #008080">207</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setCatalog(String catalog) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  208. </span><span style="color: #008080">208</span> <span style="color: #000000"> {
  209. </span><span style="color: #008080">209</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  210. <span style="color: #008080">210</span> <span style="color: #000000"> con.setCatalog(catalog);
  211. </span><span style="color: #008080">211</span> <span style="color: #000000"> }
  212. </span><span style="color: #008080">212</span>
  213. <span style="color: #008080">213</span> <span style="color: #0000ff">public</span> String getCatalog() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  214. </span><span style="color: #008080">214</span> <span style="color: #000000"> {
  215. </span><span style="color: #008080">215</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  216. <span style="color: #008080">216</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.getCatalog();
  217. </span><span style="color: #008080">217</span> <span style="color: #000000"> }
  218. </span><span style="color: #008080">218</span>
  219. <span style="color: #008080">219</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setTransactionIsolation(<span style="color: #0000ff">int</span> level) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  220. </span><span style="color: #008080">220</span> <span style="color: #000000"> {
  221. </span><span style="color: #008080">221</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  222. <span style="color: #008080">222</span> <span style="color: #000000"> con.setTransactionIsolation(level);
  223. </span><span style="color: #008080">223</span> <span style="color: #000000"> }
  224. </span><span style="color: #008080">224</span>
  225. <span style="color: #008080">225</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> getTransactionIsolation() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  226. </span><span style="color: #008080">226</span> <span style="color: #000000"> {
  227. </span><span style="color: #008080">227</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  228. <span style="color: #008080">228</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.getTransactionIsolation();
  229. </span><span style="color: #008080">229</span> <span style="color: #000000"> }
  230. </span><span style="color: #008080">230</span>
  231. <span style="color: #008080">231</span> <span style="color: #0000ff">public</span> SQLWarning getWarnings() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  232. </span><span style="color: #008080">232</span> <span style="color: #000000"> {
  233. </span><span style="color: #008080">233</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  234. <span style="color: #008080">234</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.getWarnings();
  235. </span><span style="color: #008080">235</span> <span style="color: #000000"> }
  236. </span><span style="color: #008080">236</span>
  237. <span style="color: #008080">237</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> clearWarnings() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  238. </span><span style="color: #008080">238</span> <span style="color: #000000"> {
  239. </span><span style="color: #008080">239</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  240. <span style="color: #008080">240</span> <span style="color: #000000"> con.clearWarnings();
  241. </span><span style="color: #008080">241</span> <span style="color: #000000"> }
  242. </span><span style="color: #008080">242</span>
  243. <span style="color: #008080">243</span> <span style="color: #0000ff">public</span> Statement createStatement(<span style="color: #0000ff">int</span> resultSetType, <span style="color: #0000ff">int</span> resultSetConcurrency) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  244. </span><span style="color: #008080">244</span> <span style="color: #000000"> {
  245. </span><span style="color: #008080">245</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  246. <span style="color: #008080">246</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.createStatement(resultSetType, resultSetConcurrency);
  247. </span><span style="color: #008080">247</span> <span style="color: #000000"> }
  248. </span><span style="color: #008080">248</span>
  249. <span style="color: #008080">249</span> <span style="color: #0000ff">public</span> PreparedStatement prepareStatement(String sql, <span style="color: #0000ff">int</span> resultSetType, <span style="color: #0000ff">int</span><span style="color: #000000"> resultSetConcurrency)
  250. </span><span style="color: #008080">250</span> <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  251. </span><span style="color: #008080">251</span> <span style="color: #000000"> {
  252. </span><span style="color: #008080">252</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  253. <span style="color: #008080">253</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareStatement(sql, resultSetType, resultSetConcurrency);
  254. </span><span style="color: #008080">254</span> <span style="color: #000000"> }
  255. </span><span style="color: #008080">255</span>
  256. <span style="color: #008080">256</span> <span style="color: #0000ff">public</span> CallableStatement prepareCall(String sql, <span style="color: #0000ff">int</span> resultSetType, <span style="color: #0000ff">int</span> resultSetConcurrency) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  257. </span><span style="color: #008080">257</span> <span style="color: #000000"> {
  258. </span><span style="color: #008080">258</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  259. <span style="color: #008080">259</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareCall(sql, resultSetType, resultSetConcurrency);
  260. </span><span style="color: #008080">260</span> <span style="color: #000000"> }
  261. </span><span style="color: #008080">261</span>
  262. <span style="color: #008080">262</span> <span style="color: #0000ff">public</span> Map<String, Class<?>> getTypeMap() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  263. </span><span style="color: #008080">263</span> <span style="color: #000000"> {
  264. </span><span style="color: #008080">264</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  265. <span style="color: #008080">265</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.getTypeMap();
  266. </span><span style="color: #008080">266</span> <span style="color: #000000"> }
  267. </span><span style="color: #008080">267</span>
  268. <span style="color: #008080">268</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setTypeMap(Map<String, Class<?>> map) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  269. </span><span style="color: #008080">269</span> <span style="color: #000000"> {
  270. </span><span style="color: #008080">270</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  271. <span style="color: #008080">271</span> <span style="color: #000000"> con.setTypeMap(map);
  272. </span><span style="color: #008080">272</span> <span style="color: #000000"> }
  273. </span><span style="color: #008080">273</span>
  274. <span style="color: #008080">274</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setHoldability(<span style="color: #0000ff">int</span> holdability) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  275. </span><span style="color: #008080">275</span> <span style="color: #000000"> {
  276. </span><span style="color: #008080">276</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  277. <span style="color: #008080">277</span> <span style="color: #000000"> con.setHoldability(holdability);
  278. </span><span style="color: #008080">278</span> <span style="color: #000000"> }
  279. </span><span style="color: #008080">279</span>
  280. <span style="color: #008080">280</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> getHoldability() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  281. </span><span style="color: #008080">281</span> <span style="color: #000000"> {
  282. </span><span style="color: #008080">282</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  283. <span style="color: #008080">283</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.getHoldability();
  284. </span><span style="color: #008080">284</span> <span style="color: #000000"> }
  285. </span><span style="color: #008080">285</span>
  286. <span style="color: #008080">286</span> <span style="color: #0000ff">public</span> Savepoint setSavepoint() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  287. </span><span style="color: #008080">287</span> <span style="color: #000000"> {
  288. </span><span style="color: #008080">288</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  289. <span style="color: #008080">289</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.setSavepoint();
  290. </span><span style="color: #008080">290</span> <span style="color: #000000"> }
  291. </span><span style="color: #008080">291</span>
  292. <span style="color: #008080">292</span> <span style="color: #0000ff">public</span> Savepoint setSavepoint(String name) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  293. </span><span style="color: #008080">293</span> <span style="color: #000000"> {
  294. </span><span style="color: #008080">294</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  295. <span style="color: #008080">295</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.setSavepoint(name);
  296. </span><span style="color: #008080">296</span> <span style="color: #000000"> }
  297. </span><span style="color: #008080">297</span>
  298. <span style="color: #008080">298</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> rollback(Savepoint savepoint) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  299. </span><span style="color: #008080">299</span> <span style="color: #000000"> {
  300. </span><span style="color: #008080">300</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  301. <span style="color: #008080">301</span> <span style="color: #000000"> con.rollback(savepoint);
  302. </span><span style="color: #008080">302</span> <span style="color: #000000"> }
  303. </span><span style="color: #008080">303</span>
  304. <span style="color: #008080">304</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> releaseSavepoint(Savepoint savepoint) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  305. </span><span style="color: #008080">305</span> <span style="color: #000000"> {
  306. </span><span style="color: #008080">306</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  307. <span style="color: #008080">307</span> <span style="color: #000000"> con.releaseSavepoint(savepoint);
  308. </span><span style="color: #008080">308</span> <span style="color: #000000"> }
  309. </span><span style="color: #008080">309</span>
  310. <span style="color: #008080">310</span> <span style="color: #0000ff">public</span> Statement createStatement(<span style="color: #0000ff">int</span> resultSetType, <span style="color: #0000ff">int</span> resultSetConcurrency, <span style="color: #0000ff">int</span><span style="color: #000000"> resultSetHoldability)
  311. </span><span style="color: #008080">311</span> <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  312. </span><span style="color: #008080">312</span> <span style="color: #000000"> {
  313. </span><span style="color: #008080">313</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  314. <span style="color: #008080">314</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.createStatement(resultSetType, resultSetConcurrency, resultSetHoldability);
  315. </span><span style="color: #008080">315</span> <span style="color: #000000"> }
  316. </span><span style="color: #008080">316</span>
  317. <span style="color: #008080">317</span> <span style="color: #0000ff">public</span> PreparedStatement prepareStatement(String sql, <span style="color: #0000ff">int</span> resultSetType, <span style="color: #0000ff">int</span><span style="color: #000000"> resultSetConcurrency,
  318. </span><span style="color: #008080">318</span> <span style="color: #0000ff">int</span> resultSetHoldability) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  319. </span><span style="color: #008080">319</span> <span style="color: #000000"> {
  320. </span><span style="color: #008080">320</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  321. <span style="color: #008080">321</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareStatement(sql, resultSetType, resultSetConcurrency, resultSetHoldability);
  322. </span><span style="color: #008080">322</span> <span style="color: #000000"> }
  323. </span><span style="color: #008080">323</span>
  324. <span style="color: #008080">324</span> <span style="color: #0000ff">public</span> CallableStatement prepareCall(String sql, <span style="color: #0000ff">int</span> resultSetType, <span style="color: #0000ff">int</span><span style="color: #000000"> resultSetConcurrency,
  325. </span><span style="color: #008080">325</span> <span style="color: #0000ff">int</span> resultSetHoldability) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  326. </span><span style="color: #008080">326</span> <span style="color: #000000"> {
  327. </span><span style="color: #008080">327</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  328. <span style="color: #008080">328</span> <span style="color: #0000ff">return</span> <span style="color: #0000ff">null</span><span style="color: #000000">;
  329. </span><span style="color: #008080">329</span> <span style="color: #000000"> }
  330. </span><span style="color: #008080">330</span>
  331. <span style="color: #008080">331</span> <span style="color: #0000ff">public</span> PreparedStatement prepareStatement(String sql, <span style="color: #0000ff">int</span> autoGeneratedKeys) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  332. </span><span style="color: #008080">332</span> <span style="color: #000000"> {
  333. </span><span style="color: #008080">333</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  334. <span style="color: #008080">334</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareStatement(sql, autoGeneratedKeys);
  335. </span><span style="color: #008080">335</span> <span style="color: #000000"> }
  336. </span><span style="color: #008080">336</span>
  337. <span style="color: #008080">337</span> <span style="color: #0000ff">public</span> PreparedStatement prepareStatement(String sql, <span style="color: #0000ff">int</span>[] columnIndexes) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  338. </span><span style="color: #008080">338</span> <span style="color: #000000"> {
  339. </span><span style="color: #008080">339</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  340. <span style="color: #008080">340</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareStatement(sql, columnIndexes);
  341. </span><span style="color: #008080">341</span> <span style="color: #000000"> }
  342. </span><span style="color: #008080">342</span>
  343. <span style="color: #008080">343</span> <span style="color: #0000ff">public</span> PreparedStatement prepareStatement(String sql, String[] columnNames) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  344. </span><span style="color: #008080">344</span> <span style="color: #000000"> {
  345. </span><span style="color: #008080">345</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  346. <span style="color: #008080">346</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.prepareStatement(sql, columnNames);
  347. </span><span style="color: #008080">347</span> <span style="color: #000000"> }
  348. </span><span style="color: #008080">348</span>
  349. <span style="color: #008080">349</span> <span style="color: #0000ff">public</span> Clob createClob() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  350. </span><span style="color: #008080">350</span> <span style="color: #000000"> {
  351. </span><span style="color: #008080">351</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  352. <span style="color: #008080">352</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.createClob();
  353. </span><span style="color: #008080">353</span> <span style="color: #000000"> }
  354. </span><span style="color: #008080">354</span>
  355. <span style="color: #008080">355</span> <span style="color: #0000ff">public</span> Blob createBlob() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  356. </span><span style="color: #008080">356</span> <span style="color: #000000"> {
  357. </span><span style="color: #008080">357</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  358. <span style="color: #008080">358</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.createBlob();
  359. </span><span style="color: #008080">359</span> <span style="color: #000000"> }
  360. </span><span style="color: #008080">360</span>
  361. <span style="color: #008080">361</span> <span style="color: #0000ff">public</span> NClob createNClob() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  362. </span><span style="color: #008080">362</span> <span style="color: #000000"> {
  363. </span><span style="color: #008080">363</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  364. <span style="color: #008080">364</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.createNClob();
  365. </span><span style="color: #008080">365</span> <span style="color: #000000"> }
  366. </span><span style="color: #008080">366</span>
  367. <span style="color: #008080">367</span> <span style="color: #0000ff">public</span> SQLXML createSQLXML() <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  368. </span><span style="color: #008080">368</span> <span style="color: #000000"> {
  369. </span><span style="color: #008080">369</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  370. <span style="color: #008080">370</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.createSQLXML();
  371. </span><span style="color: #008080">371</span> <span style="color: #000000"> }
  372. </span><span style="color: #008080">372</span>
  373. <span style="color: #008080">373</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">boolean</span> isValid(<span style="color: #0000ff">int</span> timeout) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException
  374. </span><span style="color: #008080">374</span> <span style="color: #000000"> {
  375. </span><span style="color: #008080">375</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  376. <span style="color: #008080">376</span> <span style="color: #0000ff">return</span><span style="color: #000000"> con.isValid(timeout);
  377. </span><span style="color: #008080">377</span> <span style="color: #000000"> }
  378. </span><span style="color: #008080">378</span>
  379. <span style="color: #008080">379</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setClientInfo(String name, String value) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLClientInfoException
  380. </span><span style="color: #008080">380</span> <span style="color: #000000"> {
  381. </span><span style="color: #008080">381</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  382. <span style="color: #008080">382</span> <span style="color: #000000"> con.setClientInfo(name, value);
  383. </span><span style="color: #008080">383</span> <span style="color: #000000"> }
  384. </span><span style="color: #008080">384</span>
  385. <span style="color: #008080">385</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> setClientInfo(Properties properties) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLClientInfoException
  386. </span><span style="color: #008080">386</span> <span style="color: #000000"> {
  387. </span><span style="color: #008080">387</span> <span style="color: #008000">//</span><span style="color: #008000"> TODO Auto-generated method stub</span>
  388. <span style="color: #008080">388</span> <span style="color: #000000"> con.setClientInfo(properties);
  389. </span><span style="color: #008080">389</span> <span style="color: #000000"> }
  390. </span><span style="" <="" div="">
  391. <div class="">
  392. <ul class="m-news-opt fix">
  393. <li class="opt-item">
  394. <a href="/sql_question-421665.html" target="_blank"><p>< 上一篇</p><p class="ellipsis">springJdbc like模糊查询,Spring namedParameterJdbcTemplate like查询</p></a>
  395. </li>
  396. <li class="opt-item ta-r">
  397. <a href="/sql_question-421667.html" target="_blank"><p>下一篇 ></p><p class="ellipsis">Mac电脑 阿里云ECS(ContentOS) Apache+vsftpd+nodejs+mongodb建站过程总结</p></a>
  398. </li>
  399. </ul>
  400. </div>
  401. </span>

人气教程排行