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