|
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.examples;
|
|
|
24
|
|
|
25 import java.sql.ResultSet;
|
|
|
26 import java.sql.SQLException;
|
|
|
27 import fschmidt.db.DbObject;
|
|
|
28 import fschmidt.db.DbRecord;
|
|
|
29 import fschmidt.db.DbKey;
|
|
|
30 import fschmidt.db.LongKey;
|
|
|
31 import fschmidt.db.DbFinder;
|
|
|
32 import fschmidt.db.DbDatabase;
|
|
|
33 import fschmidt.db.DbTable;
|
|
|
34 import fschmidt.db.DbObjectFactory;
|
|
|
35
|
|
|
36
|
|
|
37 public class Example implements DbObject<LongKey,Example> {
|
|
|
38 static final String url = "jdbc:mysql://localhost/talk";
|
|
|
39 static final String user = "";
|
|
|
40 static final String password = "";
|
|
|
41 static DbDatabase db = DbFinder.getDatabase(url,user,password);
|
|
|
42
|
|
|
43 private final DbRecord<LongKey,Example> record;
|
|
|
44 private String text;
|
|
|
45
|
|
|
46 private Example(LongKey key,ResultSet rs)
|
|
|
47 throws SQLException
|
|
|
48 {
|
|
|
49 record = table.newRecord(this,key);
|
|
|
50 text = rs.getString("text");
|
|
|
51 }
|
|
|
52
|
|
|
53 public Example(String text) {
|
|
|
54 record = table.newRecord(this);
|
|
|
55 this.text = text;
|
|
|
56 }
|
|
|
57
|
|
|
58 public DbRecord<LongKey,Example> getDbRecord() {
|
|
|
59 return record;
|
|
|
60 }
|
|
|
61
|
|
|
62 public long getId() {
|
|
|
63 return record.getPrimaryKey().value();
|
|
|
64 }
|
|
|
65
|
|
|
66 public String getText() {
|
|
|
67 return text;
|
|
|
68 }
|
|
|
69
|
|
|
70 public void setText(String text) {
|
|
|
71 this.text = text;
|
|
|
72 record.fields().put("text",text);
|
|
|
73 }
|
|
|
74
|
|
|
75 static DbTable<LongKey,Example> table = db.newTable( "example", db.newIdentityLongKeySetter("example_id"),
|
|
|
76 new DbObjectFactory<LongKey,Example>() {
|
|
|
77 public Example makeDbObject(LongKey key,ResultSet rs,String tableName)
|
|
|
78 throws SQLException
|
|
|
79 {
|
|
|
80 return new Example(key,rs);
|
|
|
81 }
|
|
|
82 }
|
|
|
83 );
|
|
|
84
|
|
|
85 public static Example findExample(long id) {
|
|
|
86 return table.findByPrimaryKey(new LongKey(id));
|
|
|
87 }
|
|
|
88
|
|
|
89 public static void main(String[] args) throws Exception {
|
|
|
90 Example example = new Example("hello world");
|
|
|
91 example.getDbRecord().insert();
|
|
|
92 long id = example.getId();
|
|
|
93
|
|
|
94 example = findExample(id);
|
|
|
95 System.out.println(example.getText());
|
|
|
96 }
|
|
|
97 }
|
