桌面程序也要用到数据库的,derby自然是首选,这个资料很多,官方的就够用,但是。。。太多了,搞的都不知道那个文档有用。。。 ,研究了一天,终于可以用来,其实很简单。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
/**
*
* @author lan
*/
public class Connector {
private static final Log log = LogFactory.getLog(Connector.class);
private static final String DB_NAME = "jdbc:derby:data;user=uname;password=pwd";//没啥说的,jdbc都知道
private static final String BOOT_PWD = "bootPassword=DBpassword";//数据库加密的密码
static {
try {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");//这个就是嵌入式的driver了,注意导入derbytools包
} catch (ClassNotFoundException ex) {
log.error(ex.getMessage(), ex);
}
}
public static Connection getConnection() {
try {
return DriverManager.getConnection(DB_NAME + ";" + BOOT_PWD);//连接数据库
} catch (SQLException ex) {
log.error(ex.getMessage(), ex);
}
return null;
}
public static void init() {//创建数据库和表
try {
PropertiesConfiguration config = new PropertiesConfiguration();
config.setListDelimiter((char) 0);//commons configuration包
config.load(Connector.class.getResourceAsStream("tables.properties"));//保存表创建语句的文件,当然可以是其他类型的,我这里都简单,所以放这里
Connection con = DriverManager.getConnection(DB_NAME + ";create=true;dataEncryption=true;" + BOOT_PWD);//没有就创建,并且加密,默认的加密方式,也可以自定义
con.setAutoCommit(false);
Statement st = con.createStatement();
for (Iterator it = config.getKeys(); it.hasNext();) {
String key = (String) it.next();
String sql = config.getString(key);
if (sql != null) {
st.execute(sql);
log.info("table " + key + " create finish.");
}
}
con.commit();
con.setAutoCommit(true);
con.close();
log.info("db init finish");
} catch (ConfigurationException ex) {
log.error(ex.getMessage(), ex);
} catch (SQLException ex) {
log.error(ex.getMessage(), ex);
}
}
public static boolean closeDB() {
try {
DriverManager.getConnection(DB_NAME + ";shutdown=true");//关闭数据库,很别致啊
return true;
} catch (SQLException ex) {
log.error(ex.getMessage(), ex);
}
return false;
}