98 |
pm = PMF.get().getPersistenceManager(); |
pm = PMF.get().getPersistenceManager(); |
99 |
|
|
100 |
|
|
101 |
|
|
102 |
|
|
103 |
|
JdoStationBean b = new JdoStationBean(); |
104 |
|
b.setId(1000); |
105 |
|
b.setName("TestStation"); |
106 |
|
b.setNameLower( b.getName().toLowerCase() ); |
107 |
|
b.setMetro("12"); |
108 |
|
pm.makePersistent(b); |
109 |
|
|
110 |
|
|
111 |
|
JdoStationBean b2 = new JdoStationBean(); |
112 |
|
b2.setId(1001); |
113 |
|
b2.setName("teststation 2"); |
114 |
|
b2.setNameLower( b2.getName().toLowerCase() ); |
115 |
|
b2.setMetro("12"); |
116 |
|
pm.makePersistent(b2); |
117 |
|
|
118 |
|
JdoStationBean b3 = new JdoStationBean(); |
119 |
|
b3.setId(1002); |
120 |
|
b3.setName("Horsens"); |
121 |
|
b3.setNameLower( b3.getName().toLowerCase() ); |
122 |
|
b3.setMetro("13"); |
123 |
|
pm.makePersistent(b3); |
124 |
|
|
125 |
|
|
126 |
|
|
127 |
|
|
128 |
|
//String query = "select from " + JdoStationBean.class.getName();// + " where nameLower.startsWith('test')"; |
129 |
|
|
130 |
String query = "select from " + JdoStationBean.class.getName() + " where name.matches('Test.*')"; |
String query = "select from " + JdoStationBean.class.getName() + " where (id == 1001 || id == 1002) "; |
131 |
List<JdoStationBean> stations = (List<JdoStationBean>) pm.newQuery(query).execute(); |
|
132 |
|
List<JdoStationBean> stations = (List<JdoStationBean>) pm.newQuery( query ).execute(); |
133 |
|
|
134 |
logger.info("size=" + stations.size() ); |
logger.info("size=" + stations.size() ); |
135 |
for(JdoStationBean bean : stations) { |
for(JdoStationBean bean : stations) { |
136 |
logger.info("Station: " + bean.getId() + "/" + bean.getName()); |
logger.info("Station: " + bean.getId() + "/" + bean.getName()); |
137 |
} |
} |
138 |
|
|
|
/*if (stations.size() == 0) { |
|
|
JdoStationBean b = new JdoStationBean(); |
|
|
b.setId(1000); |
|
|
b.setName("TestStation"); |
|
|
b.setMetro("12"); |
|
|
pm.makePersistent(b); |
|
|
|
|
|
JdoStationBean b2 = new JdoStationBean(); |
|
|
b2.setId(1001); |
|
|
b2.setName("teststation 2"); |
|
|
b2.setMetro("12"); |
|
|
pm.makePersistent(b2); |
|
|
}*/ |
|
139 |
|
|
140 |
|
|
141 |
|
|