Br.API.Data.DatabaseSerializable Maven / Gradle / Ivy
/*
* 开发者:Bryan_lzh
* QQ:390807154
* 保留一切所有权
* 若为Bukkit插件 请前往plugin.yml查看剩余协议
*/
package Br.API.Data;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;
import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Optional;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
* 使用该接口，可以超快捷实现对象在数据库中的序列化与反序列化
*
* @author Bryan_lzh
*/
public interface DatabaseSerializable {
// private long last = 0;
//
// @Override
// public long getLastLoad() {
// return last;
// }
//
// @Override
// public void setLastLoad(long l) {
// this.last = l;
// } 请确保此处按这样编写方法
long getLastLoad();
void setLastLoad(long l);
static class PreparedStatements {
static Map, Connection> Connections = new HashMap<>();
static Map, Statement> Statements = new HashMap<>();
static Map, PreparedStatement> UpdateCheckPreparedStatements = new HashMap<>();
static Map, PreparedStatement> UpdatePreparedStatements = new HashMap<>();
static Map, PreparedStatement> InsertPreparedStatements = new HashMap<>();
static Map, PreparedStatement> UpdateTimePreparedStatements = new HashMap<>();
static Map, PreparedStatement> InsertTimePreparedStatements = new HashMap<>();
static Map, PreparedStatement> PreparedStatementPreparedStatement = new HashMap<>();
static Map, PreparedStatement> PreparedTimeStatementPreparedStatement = new HashMap<>();
static Map, PreparedStatement> DataPreparedStatements = new HashMap<>();
static Map, Field> Keys = new HashMap<>();
private PreparedStatements() {
}
public static void Close() {
for (Connection c : Connections.values()) {
try {
c.close();
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
}
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.FIELD)
public @interface Config {
public String Name() default "";
public boolean Key() default false;
public String DataType();
public boolean NotNull() default false;
}
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.TYPE)
public @interface Database {
public String TableName() default "";
public boolean UpdateCheck() default false;
}
default void DeleteTable() {
Statement s = PreparedStatements.Statements.get(this.getClass());
try {
s.execute("drop table " + this.getTableName());
if (this.getClass().isAnnotationPresent(Database.class)) {
Database db = this.getClass().getAnnotation(Database.class);
if (db.UpdateCheck()) {
s.execute("drop table " + this.getTableName() + "_Update");
}
}
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
default void RecrateTable() {
this.DeleteTable();
try {
DatabaseSerializable.CreateTables(this.getClass());
} catch (TooMuchKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static void Register(Class cls, String url)
throws InstantiationException, ClassNotFoundException, IllegalAccessException,
SQLException, NullDatabaseNameException, TooMuchKeyException, NullKeyException {
if (cls.isAnonymousClass()) {
if (!cls.isAnnotationPresent(Database.class)) {
throw new NullDatabaseNameException(cls);
}
Database db = cls.getAnnotation(Database.class);
if (db.TableName() == null || db.TableName().isEmpty()) {
throw new NullDatabaseNameException(cls);
}
}
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection(url);
PreparedStatements.Connections.put(cls, conn);
Statement s = conn.createStatement();
PreparedStatements.Statements.put(cls, s);
CreateTables(cls);
}
public default void UpdateData() {
if (this.getClass().isAnnotationPresent(Database.class)) {
Database db = this.getClass().getAnnotation(Database.class);
if (db.UpdateCheck()) {
if (!PreparedStatements.UpdateCheckPreparedStatements.containsKey(this.getClass())) {
try {
PreparedStatement ps = PreparedStatements.Connections.get(this.getClass()).prepareStatement("select Time from " + this.getTableName() + "_Update where KeyValue = ?");
PreparedStatements.UpdateCheckPreparedStatements.put(this.getClass(), ps);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
PreparedStatement ps = PreparedStatements.UpdateCheckPreparedStatements.get(this.getClass());
try {
ps.setObject(1, this.getKey().get(this));
ResultSet sr = ps.executeQuery();
if (sr.next()) {
long time = sr.getLong(1);
if (this.getLastLoad() >= time) {
return;
}
this.setLastLoad(time);
}
} catch (IllegalArgumentException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
DatabaseSerializable t = this;
if (!PreparedStatements.DataPreparedStatements.containsKey(t.getClass())) {
try {
PreparedStatement ps = PreparedStatements.Connections.get(t.getClass()).prepareCall("select * from " + t.getTableName()
+ " where " + t.getKeyName()
+ " = ?");
PreparedStatements.DataPreparedStatements.put(t.getClass(), ps);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
PreparedStatement ps = PreparedStatements.DataPreparedStatements.get(t.getClass());
try {
ps.setObject(1, t.getKey().get(t));
ResultSet sr = ps.executeQuery();
if (!sr.next()) {
return;
}
for (Field f : t.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (c.DataType().toUpperCase().contains("BLOB")) {
String s = c.Name().isEmpty() ? f.getName() : c.Name();
f.set(t, Bytes2Object(sr.getBytes(s), f.getType()));
continue;
}
String s = c.Name().isEmpty() ? f.getName() : c.Name();
Object obj = sr.getObject(s);
try {
f.set(t, obj);
} catch (IllegalArgumentException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalArgumentException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IOException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
/**
* 储存对象 现已使用PreparedStatement
*
* @throws IllegalArgumentException
* @throws IllegalAccessException
* @throws NullKeyException
* @throws SQLException
*/
public default void Save() throws IllegalArgumentException, IllegalAccessException, NullKeyException, SQLException {
String sql = null;
if (this.isExists()) {
if (!PreparedStatements.UpdatePreparedStatements.containsKey(this.getClass())) {
sql = "UPDATE " + this.getTableName() + " set ";
boolean first = true;
for (Field f : this.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (!first) {
sql += ",";
}
first = false;
sql += (c.Name().isEmpty() ? f.getName() : c.Name()) + " = ?";
}
}
sql += "where " + this.getKeyName() + " = ?";
PreparedStatement ps = PreparedStatements.Connections.get(this.getClass()).prepareStatement(sql);
PreparedStatements.UpdatePreparedStatements.put(this.getClass(), ps);
}
PreparedStatement ps = PreparedStatements.UpdatePreparedStatements.get(this.getClass());
int i = 1;
for (Field f : this.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (!f.isAnnotationPresent(Config.class)) {
continue;
}
Config c = f.getAnnotation(Config.class);
ps.setObject(i++, f.get(this));
}
ps.setObject(i, this.getKey().get(this));
ps.execute();
if (this.getClass().isAnnotationPresent(Database.class)) {
Database db = this.getClass().getAnnotation(Database.class);
if (db.UpdateCheck()) {
if (!PreparedStatements.UpdateTimePreparedStatements.containsKey(this.getClass())) {
Connection conn = PreparedStatements.Connections.get(this.getClass());
PreparedStatement ps2 = conn.prepareStatement("UPDATE " + this.getTableName() + "_Update set Time = ? where KeyValue = ?");
PreparedStatements.UpdateTimePreparedStatements.put(this.getClass(), ps2);
}
PreparedStatement ps2 = PreparedStatements.UpdateTimePreparedStatements.get(this.getClass());
ps2.setLong(1, System.currentTimeMillis());
ps2.setObject(2, this.getKey().get(this));
ps2.execute();
}
}
} else {
if (!PreparedStatements.InsertPreparedStatements.containsKey(this.getClass())) {
sql = "INSERT INTO " + this.getTableName() + " ";
String key = "(";
String value = "(";
boolean first = true;
for (Field f : this.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (!first) {
key += ",";
value += ",";
}
first = false;
key += c.Name().isEmpty() ? f.getName() : c.Name();
value += "?";
}
}
key += ")";
value += ")";
sql += key + " VALUES " + value;
PreparedStatement ps = PreparedStatements.Connections.get(this.getClass()).prepareStatement(sql);
PreparedStatements.InsertPreparedStatements.put(this.getClass(), ps);
}
PreparedStatement ps = PreparedStatements.InsertPreparedStatements.get(this.getClass());
int i = 1;
for (Field f : this.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (!f.isAnnotationPresent(Config.class)) {
continue;
}
Config c = f.getAnnotation(Config.class);
ps.setObject(i++, f.get(this));
}
ps.execute();
if (this.getClass().isAnnotationPresent(Database.class)) {
Database db = this.getClass().getAnnotation(Database.class);
if (db.UpdateCheck()) {
if (!PreparedStatements.InsertTimePreparedStatements.containsKey(this.getClass())) {
PreparedStatement ps2 = PreparedStatements.Connections.get(this.getClass()).prepareStatement("INSERT INTO " + this.getTableName() + "_Update VALUES (?,?)");
PreparedStatements.InsertTimePreparedStatements.put(this.getClass(), ps2);
}
PreparedStatement ps2 = PreparedStatements.InsertTimePreparedStatements.get(this.getClass());
ps2.setObject(1, this.getKey().get(this));
ps2.setLong(2, System.currentTimeMillis());
ps2.execute();
}
}
}
}
public default boolean isExists() throws IllegalArgumentException, IllegalAccessException {
if (!PreparedStatements.DataPreparedStatements.containsKey(this.getClass())) {
try {
PreparedStatement ps = PreparedStatements.Connections.get(this.getClass()).prepareCall("select * from " + this.getTableName()
+ " where " + this.getKeyName()
+ " = ?");
PreparedStatements.DataPreparedStatements.put(this.getClass(), ps);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
PreparedStatement ps = PreparedStatements.DataPreparedStatements.get(this.getClass());
try {
ps.setObject(1, this.getKey().get(this));
ResultSet sr = ps.executeQuery();
return sr.next();
} catch (NullKeyException ex) {
} catch (SQLException ex) {
}
return false;
}
public default String getTableName() {
String tablename = null;
if (this.getClass().isAnnotationPresent(Database.class)) {
Database db = this.getClass().getAnnotation(Database.class);
if (db.TableName() != null && !db.TableName().isEmpty()) {
tablename = db.TableName();
}
}
if (tablename == null) {
tablename = this.getClass().getSimpleName();
}
return tablename;
}
public default String getKeyName() throws NullKeyException {
for (Field f : this.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (c.Key()) {
return c.Name().isEmpty() ? f.getName() : c.Name();
}
}
}
throw new NullKeyException(this.getClass());
}
public default Field getKey() throws NullKeyException {
if (!PreparedStatements.Keys.containsKey(this.getClass())) {
boolean b = true;
for (Field f : this.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (c.Key()) {
PreparedStatements.Keys.put(this.getClass(), f);
b = false;
break;
}
}
}
if (b) {
throw new NullKeyException(this.getClass());
}
}
return PreparedStatements.Keys.get(this.getClass());
}
public static Field getKey(Class cls) throws NullKeyException {
for (Field f : cls.getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (c.Key()) {
return f;
}
}
}
throw new NullKeyException(cls);
}
static void CreateTables(Class cls) throws TooMuchKeyException, SQLException, NullKeyException {
Statement SQL = PreparedStatements.Statements.get(cls);
String tablename = null;
boolean UpdateCheck = false;
if (cls.isAnnotationPresent(Database.class)) {
Database db = cls.getAnnotation(Database.class);
if (db.TableName() != null && !db.TableName().isEmpty()) {
tablename = db.TableName();
}
UpdateCheck = db.UpdateCheck();
}
if (tablename == null) {
tablename = cls.getSimpleName();
}
String sql = "CREATE TABLE IF NOT EXISTS " + tablename + " (";
boolean first = true;
Field key = null;
for (Field f : cls.getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
String temp = c.Name().isEmpty() ? f.getName() : c.Name();
temp = temp + " " + c.DataType();
if (c.NotNull()) {
temp += " NOT NULL ";
}
if (!first) {
temp = "," + temp;
}
first = false;
sql += temp;
if (c.Key()) {
if (key != null) {
throw new TooMuchKeyException(cls);
}
key = f;
}
}
}
if (key != null) {
Config c = key.getAnnotation(Config.class);
sql += ",PRIMARY KEY(`" + (c.Name().isEmpty() ? key.getName() : c.Name())
+ "`)";
} else {
throw new NullKeyException(cls);
}
sql += ")";
SQL.execute(sql);
if (UpdateCheck) {
Config c = key.getAnnotation(Config.class);
sql = "CREATE TABLE IF NOT EXISTS " + tablename + "_Update (KeyValue "
+ c.DataType() + " NOT NULL ,Time BIGINT ,PRIMARY KEY(`KeyValue`))";
SQL.execute(sql);
}
}
public static List DeserializeAll(Class cls) throws SQLException, InstantiationException, IllegalAccessException {
String tn;
if (cls.isAnnotationPresent(Database.class)) {
Database db = cls.getAnnotation(Database.class);
tn = db.TableName().isEmpty() ? cls.getSimpleName() : db.TableName();
} else {
tn = cls.getSimpleName();
}
if (!PreparedStatements.PreparedStatementPreparedStatement.containsKey(cls)) {
PreparedStatements.PreparedStatementPreparedStatement.put(cls, PreparedStatements.Connections.get(cls).prepareStatement("select * from " + tn));
}
if (!PreparedStatements.PreparedTimeStatementPreparedStatement.containsKey(cls)) {
PreparedStatements.PreparedTimeStatementPreparedStatement.put(cls, PreparedStatements.Connections.get(cls).prepareStatement("select Time from " + tn + "_Update where KeyValue = ?"));
}
PreparedStatement ps = PreparedStatements.PreparedStatementPreparedStatement.get(cls);
ResultSet sr = ps.executeQuery();
PreparedStatement ps2 = PreparedStatements.PreparedTimeStatementPreparedStatement.get(cls);
List list = new ArrayList<>();
boolean up = false;
if (cls.isAnnotationPresent(Database.class)) {
Database db = cls.getAnnotation(Database.class);
up = db.UpdateCheck();
}
while (sr.next()) {
T t = cls.newInstance();
for (Field f : t.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (c.DataType().toUpperCase().contains("BLOB")) {
String s = c.Name().isEmpty() ? f.getName() : c.Name();
f.set(t, getObject(sr, s, f.getType()));
continue;
}
String s = c.Name().isEmpty() ? f.getName() : c.Name();
Object obj = sr.getObject(s);
try {
f.set(t, obj);
} catch (IllegalArgumentException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
if (up) {
try {
ps2.setObject(1, t.getKey().get(t));
ResultSet sr2 = ps2.executeQuery();
if (sr2.next()) {
t.setLastLoad(sr2.getLong(1));
}
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
list.add(t);
}
return list;
}
public static Optional Deserialize(Object key, Class cls) {
T t;
try {
t = cls.newInstance();
} catch (InstantiationException | IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
return Optional.empty();
}
if (!PreparedStatements.DataPreparedStatements.containsKey(t.getClass())) {
try {
PreparedStatement ps = PreparedStatements.Connections.get(t.getClass()).prepareCall("select * from " + t.getTableName()
+ " where " + t.getKeyName()
+ " = ?");
PreparedStatements.DataPreparedStatements.put(t.getClass(), ps);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
PreparedStatement ps = PreparedStatements.DataPreparedStatements.get(t.getClass());
try {
ps.setObject(1, key);
ResultSet sr = ps.executeQuery();
if (!sr.next()) {
return Optional.empty();
}
for (Field f : t.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (c.DataType().toUpperCase().contains("BLOB")) {
String s = c.Name().isEmpty() ? f.getName() : c.Name();
f.set(t, getObject(sr, s, f.getType()));
continue;
}
String s = c.Name().isEmpty() ? f.getName() : c.Name();
Object obj = sr.getObject(s);
try {
f.set(t, obj);
} catch (IllegalArgumentException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
if (!PreparedStatements.PreparedTimeStatementPreparedStatement.containsKey(cls) && cls.isAnnotationPresent(Database.class)) {
Database db = cls.getAnnotation(Database.class);
if (db.UpdateCheck()) {
try {
PreparedStatements.PreparedTimeStatementPreparedStatement.put(cls, PreparedStatements.Connections.get(cls).prepareStatement("select Time from " + t.getTableName() + "_Update where KeyValue = ?"));
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
PreparedStatement ps2 = PreparedStatements.PreparedTimeStatementPreparedStatement.get(cls);
if (ps2 == null) {
return Optional.of(t);
}
ps2.setObject(1, key);
ResultSet sr2 = ps2.executeQuery();
if (sr2.next()) {
t.setLastLoad(sr2.getLong(1));
}
} catch (IllegalArgumentException | IllegalAccessException | SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
return Optional.of(t);
}
@Deprecated
public static Optional Deserialize(Object key, T t) {
if (!PreparedStatements.DataPreparedStatements.containsKey(t.getClass())) {
try {
PreparedStatement ps = PreparedStatements.Connections.get(t.getClass()).prepareCall("select * from " + t.getTableName()
+ " where " + t.getKeyName()
+ " = ?");
PreparedStatements.DataPreparedStatements.put(t.getClass(), ps);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
PreparedStatement ps = PreparedStatements.DataPreparedStatements.get(t.getClass());
try {
ps.setObject(1, key);
ResultSet sr = ps.executeQuery();
if (!sr.next()) {
return Optional.empty();
}
for (Field f : t.getClass().getDeclaredFields()) {
f.setAccessible(true);
if (f.isAnnotationPresent(Config.class)) {
Config c = f.getAnnotation(Config.class);
if (c.DataType().toUpperCase().contains("BLOB")) {
String s = c.Name().isEmpty() ? f.getName() : c.Name();
f.set(t, getObject(sr, s, f.getType()));
continue;
}
String s = c.Name().isEmpty() ? f.getName() : c.Name();
Object obj = sr.getObject(s);
try {
f.set(t, obj);
} catch (IllegalArgumentException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
Class cls = t.getClass();
if (!PreparedStatements.PreparedTimeStatementPreparedStatement.containsKey(cls) && cls.isAnnotationPresent(Database.class)) {
Database db = cls.getAnnotation(Database.class);
if (db.UpdateCheck()) {
try {
PreparedStatements.PreparedTimeStatementPreparedStatement.put(cls, PreparedStatements.Connections.get(cls).prepareStatement("select Time from " + t.getTableName() + "_Update where KeyValue = ?"));
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
PreparedStatement ps2 = PreparedStatements.PreparedTimeStatementPreparedStatement.get(cls);
if (ps2 == null) {
return Optional.of(t);
}
ps2.setObject(1, key);
ResultSet sr2 = ps2.executeQuery();
if (sr2.next()) {
t.setLastLoad(sr2.getLong(1));
}
} catch (IllegalArgumentException | IllegalAccessException | SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
return Optional.of(t);
}
default void Delete() {
try {
String sql = "DELETE FROM " + this.getTableName() + " where " + this.getKeyName() + " = '" + this.getKey().get(this) + "'";
DatabaseSerializable.PreparedStatements.Statements.get(this.getClass()).execute(sql);
} catch (NullKeyException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalArgumentException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static byte[] Object2Bytes(Object obj) throws IOException {
ByteArrayOutputStream baos = new ByteArrayOutputStream();
ObjectOutputStream oos = new ObjectOutputStream(baos);
oos.writeObject(obj);
return baos.toByteArray();
}
// 将字节数组转换成为对象
public static T Bytes2Object(byte[] b, Class cls) throws IOException,
ClassNotFoundException {
ByteArrayInputStream bais = new ByteArrayInputStream(b);
ObjectInputStream ois = new ObjectInputStream(bais);
Object obj = ois.readObject();
return cls.cast(obj);
}
public static T getObject(ResultSet sr, String index, Class cls) throws SQLException {
try {
return Bytes2Object(sr.getBytes(index), cls);
} catch (SQLException | IOException | ClassNotFoundException ex) {
}
return sr.getObject(index, cls);
}
public static T getObject(ResultSet sr, int index, Class cls) throws SQLException {
try {
return Bytes2Object(sr.getBytes(index), cls);
} catch (SQLException | IOException | ClassNotFoundException ex) {
}
return sr.getObject(index, cls);
}
//
// enum TA {
// A;
// }
//
// @Database(UpdateCheck = true)
// class Test implements DatabaseSerializable {
//
// public Test() {
// }
//
// public Test(String s, int i) {
// this.Name = s;
// this.ID = i;
// }
//
// @Config(Key = true, DataType = "varchar(255)", NotNull = true)
// private String Name;
// @Config(DataType = "int", NotNull = true)
// private int ID;
// @Config(DataType = "LONGBLOB")
// public List test = new ArrayList<>();
//
// @Config(DataType = "LONGBLOB")
// public Map test2 = new HashMap<>();
//
// @Override
// public String toString() {
// return "Test{" + "Name=" + Name + ", ID=" + ID + ", test=" + test + ", test2=" + test2 + ", l=" + l + '}';
// }
//
//
// private long l = 0;
//
// @Override
// public long getLastLoad() {
// return l;
// }
//
// @Override
// public void setLastLoad(long l) {
// this.l = l;
// }
//
// }
//
// public static void main(String args[]) {
// try {
// DatabaseSerializable.Register(Test.class, "jdbc:mysql://127.0.0.1:3306/Password?user=root&password=123456&useUnicode=true&characterEncoding=utf8&autoReconnect=true&autoDeserialize=true");
// } catch (InstantiationException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (ClassNotFoundException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (IllegalAccessException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (SQLException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (NullDatabaseNameException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (TooMuchKeyException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (NullKeyException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// }
// try {
// List result = DatabaseSerializable.DeserializeAll(Test.class);
// for (Test t : result) {
// System.out.println(t.toString());
// }
// } catch (SQLException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (InstantiationException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// } catch (IllegalAccessException ex) {
// Logger.getLogger(DatabaseSerializable.class.getName()).log(Level.SEVERE, null, ex);
// }
//
// }
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy