package?com.curd.util;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

/**
?*package_name?com.curd.util?file_name?DB.java?author?zbw?date
?*?2011-12-27下午12:09:22
?*/
public?class?DB?{

	private?static?final?String?DRIVER_NAME?=?“com.mysql.jdbc.Driver“;
	private?static?final?String?URL?=?“jdbc:mysql://127.0.0.1:3306/zbw_message“;
	private?static?final?String?USERNAME?=?“root“;
	private?static?final?String?PASSWORD?=?“mysql“;

	private?static?DB?instance?=?new?DB（）;

	private?DB（）?{
		System.out.println（“created?instance!“）;
	}

	public?static?DB?getInstance（）?{
		return?instance;
	}

	public?Connection?createConnection（）?{
		Connection?connection?=?null;
		try?{
			Class.forName（DB.DRIVER_NAME）;
		}?catch?（ClassNotFoundException?e）?{
			System.out.println（“not?found?the?driver!?“?+?DB.DRIVER_NAME）;
		}
		try?{
			connection?=?DriverManager.getConnection（DB.URL?DB.USERNAME
					DB.PASSWORD）;
			System.out.println（“connection?is?ok!“）;
		}?catch?（SQLException?e）?{
			System.out.println（“getConnection?fail!“）;
		}
		return?connection;
	}

	public?PreparedStatement?prepare（String?sql）?{
		PreparedStatement?ps?=?null;
		try?{
			ps?=?DB.getInstance（）.createConnection（）.prepareStatement（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?ps;

	}

	public?void?close（PreparedStatement?ps）?{
		if?（null?!=?ps）?{
			try?{
				ps.close（）;
			}?catch?（SQLException?e）?{
				System.out.println（“ps?close?exception!“）;
			}
		}
	}

	public?void?close（ResultSet?rs）?{
		if?（null?!=?rs）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				System.out.println（“rs?close?exception!“）;
			}
		}
	}

	public?void?close（Connection?connection）?{
		if?（null?!=?connection）?{
			try?{
				connection.close（）;
			}?catch?（SQLException?e）?{
				System.out.println（“connection?close?exception!“）;
			}
		}

	}

	public?static?void?main（String[]?args）?{
		DB.getInstance（）.createConnection（）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????2121??2012-01-11?13:56??DB.java