@Test
public void testBean() {
DbUtils db = new DbUtils();
List<Student> list = db.query("select * from student", Student.class);
for (Student s : list) {
System.out.println(s);
}
}
public long insertFoto(String name) {
Escenario escenario = Escenario.getInstance();
Terreno terreno = escenario.getTerreno();
ContentValues values = new ContentValues();
values.put(COL_NAME, name);
values.put(COL_DATE, prepareDate());
values.put(COL_CASILLAS, DbUtils.getStringCasillas(terreno));
values.put(COL_MOVILES, DbUtils.getStringMoviles(terreno));
return db.insert(TABLE_FOTOS, null, values);
}
public int updateFoto(long id) {
Escenario escenario = Escenario.getInstance();
Terreno terreno = escenario.getTerreno();
ContentValues values = new ContentValues();
values.put(COL_DATE, prepareDate());
values.put(COL_CASILLAS, DbUtils.getStringCasillas(terreno));
values.put(COL_MOVILES, DbUtils.getStringMoviles(terreno));
String table = TABLE_FOTOS;
String selection = COL_ID + "= ?";
String[] selectionArgs = {String.valueOf(id)};
return db.update(table, values, selection, selectionArgs);
}
public static void createPartner(Partner partner) throws SQLException {
Connection connection = DbUtils.getConnection();
partner.setId(DbUtils.getNextValue());
String sql = "INSERT INTO partner(partner_id, fio, phone, email) VALUES(?,?,?,?)";
try (PreparedStatement statement = connection.prepareStatement(sql)) {
statement.setInt(1, partner.getId());
statement.setString(2, partner.getFio());
statement.setString(3, partner.getPhone());
statement.setString(4, partner.getEmail());
statement.executeUpdate();
}
connection.commit();
}
@NonNull
public static Drawable getDrawable(long authorId, Cursor cursor) {
Drawable drawable = null;
if (MyPreferences.getShowAvatars()) {
String avatarFilename = DbUtils.getString(cursor, DownloadTable.AVATAR_FILE_NAME);
AvatarFile avatarFile = new AvatarFile(authorId, avatarFilename);
drawable = avatarFile.getDrawable();
}
if (drawable == null) {
drawable = getDefaultDrawable();
}
return drawable;
}
@BeforeClass
public static void setupBeforeClass() throws IOException, DatabaseException {
settings = org.syphr.mythtv.test.Settings.createSettings();
logger = LoggerFactory.getLogger(DbSchemaIT.class);
factory =
DbUtils.createEntityManagerFactory(
settings.getEnumProperty(org.syphr.mythtv.test.Settings.DB_SCHEMA, SchemaVersion.class),
settings.getProperty(org.syphr.mythtv.test.Settings.DB_HOST),
settings.getIntegerProperty(org.syphr.mythtv.test.Settings.DB_PORT),
settings.getProperty(org.syphr.mythtv.test.Settings.DB_INSTANCE),
settings.getProperty(org.syphr.mythtv.test.Settings.DB_USER),
settings.getProperty(org.syphr.mythtv.test.Settings.DB_PASSWORD));
}
// 存储老师到内存和数据库中
// 第一次使用httpdata获取老师列表时，直接存入数据库，然后从数据库中读出前100条
private void storeTeachers(Elements elements) {
try {
Teacher teacher;
SQLiteDatabase writeData = dbUtils.getWriteData();
String add_sql = "insert into teachers(id,name) values(?,?);";
for (Element element : elements) {
teacher = new Teacher();
teacher.setId(element.attr("value").trim());
teacher.setName(element.text().trim());
// 保存到数据库中
writeData.execSQL(add_sql, new String[] {teacher.getId(), teacher.getName()});
}
} catch (Exception e) {
e.printStackTrace();
}
}
public static void updatePartner(Partner partner) throws SQLException {
Connection connection = DbUtils.getConnection();
String sql = "UPDATE partner SET fio = ?, phone = ?, email = ? WHERE partner_id = ?";
try (PreparedStatement statement = connection.prepareStatement(sql)) {
statement.setString(1, partner.getFio());
statement.setString(2, partner.getPhone());
statement.setString(3, partner.getEmail());
statement.setInt(4, partner.getId());
statement.executeUpdate();
connection.commit();
} catch (SQLException ex) {
connection.rollback();
throw ex;
}
}
public static void updateDeleted(Partner partner, boolean deleted) throws SQLException {
Connection connection = DbUtils.getConnection();
String sql;
try (Statement statement = connection.createStatement()) {
sql =
String.format(
"UPDATE partner SET deleted = %1$s WHERE partner_id = %2$d",
deleted ? "TRUE" : "FALSE", partner.getId());
statement.executeUpdate(sql);
connection.commit();
} catch (SQLException ex) {
connection.rollback();
throw ex;
}
}
private static ArrayList<Partner> readPartner(String SQL) throws SQLException {
Connection connection = DbUtils.getConnection();
ArrayList<Partner> partners = new ArrayList<>();
try (Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(SQL)) {
while (rs.next()) {
Partner partner = new Partner();
partner.setId(rs.getInt("partner_id"));
partner.setFio(rs.getString("fio"));
partner.setPhone(rs.getString("phone"));
partner.setEmail(rs.getString("email"));
partners.add(partner);
}
return partners;
}
}
@Test
public void testMap() {
DbUtils db = new DbUtils();
List<Map<String, Object>> list = db.query("select * from stud");
System.err.println(list);
}
