day04学习总结

JDBC的使用

//单例设计模式
public class ConfigUtils {
//私有的属性
private static ConfigUtils configUtils;
//用于读取properties为后缀的文件
private static Properties pro;
//私有的构造方法
private ConfigUtils(){
try {
//获取文件的地址
String fileName=“database.properties”;
pro=new Properties();
//把文件的信息读取到输入流里(通过class类的类加载器获取地址)
InputStream is=ConfigUtils.class.getClassLoader().getResourceAsStream(fileName);
//把读取到流的信息放入Properties对象里
pro.load(is);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
//对外的接口
//用双重锁来保证多线程的安全方法
public static synchronized ConfigUtils singletonConfigUtils(){
	if(configUtils==null){
		//锁类
		synchronized (ConfigUtils.class){
			if(configUtils==null){
				configUtils=new ConfigUtils();
			}
		}
	}
	return configUtils;
}


//通过键获取对象
public String getValue(String key){
	return pro.getProperty(key);
}

}
//封装BaseDao工具类
public class BaseDao {
//只要获取连接的方法
public static Connection getConnection(){
Connection con=null;
//通过反射加载驱动
try {
Class.forName(ConfigUtils.singletonConfigUtils().getValue(“driver”));
con=DriverManager.getConnection(ConfigUtils.singletonConfigUtils().getValue(“url”),
//获取数据库用户名
ConfigUtils.singletonConfigUtils().getValue(“user”),
//获取用户名密码
ConfigUtils.singletonConfigUtils().getValue(“password”));
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
}

//创建对应数据库表的类
public class User implements Serializable {
private int uid;
private int usex;
private String uphone;
private String uaccount;
private String upassword;
private String uimgurl;
public User(){};

public User(int uid, int usex, String uphone, String uaccount,
		String upassword, String uimgurl) {
	super();
	this.uid = uid;
	this.usex = usex;
	this.uphone = uphone;
	this.uaccount = uaccount;
	this.upassword = upassword;
	this.uimgurl = uimgurl;
}

public String getUphone() {
	return uphone;
}
public void setUphone(String uphone) {
	this.uphone = uphone;
}
public String getUpassword() {
	return upassword;
}
public void setUpassword(String upassword) {
	this.upassword = upassword;
}




public int getUid() {
	return uid;
}

public void setUid(int uid) {
	this.uid = uid;
}

public int getUsex() {
	return usex;
}

public void setUsex(int usex) {
	this.usex = usex;
}


public String getUaccount() {
	return uaccount;
}

public void setUaccount(String uaccount) {
	this.uaccount = uaccount;
}

public String getUimgurl() {
	return uimgurl;
}

public void setUimgurl(String uimgurl) {
	this.uimgurl = uimgurl;
}

@Override
public String toString() {
	return "User [uid=" + uid + ", usex=" + usex + ", uphone=" + uphone
			+ ",  uaccount=" + uaccount
			+ ", upassword=" + upassword + ", uimgurl=" + uimgurl + "]";
}

}

以上内容不全，只供参考，详情请留言