对于数据库的连接,有一些共性的东西;积累了几个方法,可以作为一个可复用的模块.
/********************************************************************/ 【程序编程相关:奇瑞到底是怎样的企业?】 【推荐阅读:Tomcat5集群性能测试!】 类jbfcmsconnect : 【扩展信息:Windows网络编程总结(二)】 import java.io.*; import java.util.*; import java.sql.*; import java.text.*; import java.lang.*;/**
* @author * * to change this generated comment edit the template variable "typecomment": * window>preferences>java>templates. * to enable and disable the creation of type comments go to * window>preferences>java>code generation. */ public class jbfcmsconnect { private string drive = ""; private string dburl = ""; private string prop_server_name = ""; private string prop_db_name = ""; private string dbusername = ""; private string dbuserpassword = ""; private string prop_db_provider; /** * onstructor for dbconnect */public jbfcmsconnect() {
init(); }/**
* method init. */ private void init() { system.out.println("enter init"); properties defaultsettings = new properties(); defaultsettings.put("db_name", "jbmms"); defaultsettings.put("db_provider","db2"); defaultsettings.put("username", "root"); defaultsettings.put("passwerd", " "); defaultsettings.put("driver_type", "net"); system.out.println("put default settings"); string prop_driver_type = defaultsettings.getproperty("driver_type"); prop_db_name = defaultsettings.getproperty("db_name"); prop_db_provider=defaultsettings.getproperty("db_provider"); dbusername = defaultsettings.getproperty("username"); dbuserpassword = defaultsettings.getproperty("password"); system.out.println("set default settings"); properties settings = new properties(); try { system.out.println("start search properties file"); fileinputstream sf = new fileinputstream("c:\\jbfcmsconnect.prop"); settings.load(sf); prop_driver_type = settings.getproperty("driver_type"); prop_db_name = settings.getproperty("db_name"); prop_db_provider=settings.getproperty("db_provider"); ... 下一页