|
68
|
1 /*
|
|
|
2 Copyright (c) 2008 Franklin Schmidt <fschmidt@gmail.com>
|
|
|
3
|
|
|
4 Permission is hereby granted, free of charge, to any person obtaining a copy
|
|
|
5 of this software and associated documentation files (the "Software"), to deal
|
|
|
6 in the Software without restriction, including without limitation the rights
|
|
|
7 to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
|
|
|
8 copies of the Software, and to permit persons to whom the Software is
|
|
|
9 furnished to do so, subject to the following conditions:
|
|
|
10
|
|
|
11 The above copyright notice and this permission notice shall be included in
|
|
|
12 all copies or substantial portions of the Software.
|
|
|
13
|
|
|
14 THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
|
|
|
15 IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
|
|
|
16 FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
|
|
|
17 AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
|
|
|
18 LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
|
|
|
19 OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
|
|
|
20 THE SOFTWARE.
|
|
|
21 */
|
|
|
22
|
|
|
23 package fschmidt.db.mysql;
|
|
|
24
|
|
|
25 import java.sql.PreparedStatement;
|
|
|
26 import java.sql.SQLException;
|
|
|
27 import fschmidt.db.DbArcana;
|
|
|
28
|
|
|
29
|
|
|
30 public final class DbDatabaseImpl extends fschmidt.db.base.DbDatabaseImpl implements DbArcana {
|
|
|
31
|
|
|
32 public DbDatabaseImpl(String url,String user,String password) {
|
|
|
33 super(url,user,password);
|
|
|
34 try {
|
|
|
35 Class.forName("com.mysql.jdbc.Driver");
|
|
|
36 } catch(ClassNotFoundException e) {
|
|
|
37 throw new RuntimeException(e);
|
|
|
38 }
|
|
|
39 setProperty("useUnicode","true");
|
|
|
40 setProperty("characterEncoding","UTF-8");
|
|
|
41 setProperty("jdbcCompliantTruncation","false");
|
|
|
42 setProperty("cacheResultSetMetadata","true");
|
|
|
43 setProperty("useCursorFetch","true");
|
|
|
44 }
|
|
|
45
|
|
|
46 public DbArcana arcana() {
|
|
|
47 return this;
|
|
|
48 }
|
|
|
49
|
|
|
50 public String quoteIdentifier(String identifier) {
|
|
|
51 return "`" + identifier + "`";
|
|
|
52 }
|
|
|
53
|
|
|
54 public String getLastSeqValFn() {
|
|
|
55 return "last_insert_id()";
|
|
|
56 }
|
|
|
57
|
|
|
58 public String dateSub(String date,int n,String units) {
|
|
|
59 return "date_sub(" + date + ",interval " + n + " " + units + ")";
|
|
|
60 }
|
|
|
61
|
|
|
62 public void setValue(PreparedStatement stmt,int idx,Object value)
|
|
|
63 throws SQLException
|
|
|
64 {
|
|
|
65 if( value instanceof Boolean ) {
|
|
|
66 stmt.setString( idx, ((Boolean)value).booleanValue() ? "t" : "f" );
|
|
|
67 } else {
|
|
|
68 super.setValue(stmt,idx,value);
|
|
|
69 }
|
|
|
70 }
|
|
|
71
|
|
|
72 }
|
