package?com.java.gzmu.dao;

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

public?class?DatabaseDao?{
	
	//連接數據庫
	public?Connection?getCon（）{
		Connection?conn=null;
		String?JDBCName=“com.mysql.jdbc.Driver“;
		String?url=“jdbc:mysql://localhost/db_goodsmanagesys?user=root&password=111111“;
		try?{
			Class.forName（JDBCName）;
			conn?=DriverManager.getConnection（url）;
			//System.out.println（“數據庫連接成功！“）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
	
	//關閉數據庫
	public?void?closeCon（ResultSet?rsStatement?stmtPreparedStatement?ps?Connection?conn）?throws?SQLException{
		if（rs!=null）{
			rs.close（）;
		}
		if（stmt!=null）{
			stmt.close（）;
		}
		if（ps!=null）{
			ps.close（）;
		}
		if（conn!=null）{
			conn.close（）;
		}
	}
//	
//	public?static?void?main（String[]?args）?{
//		DatabaseDao?dbd=new?DatabaseDao（）;
//		dbd.getCon（）;
//	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????417??2015-07-29?11:49??goodsMS\.classpath
?????文件?????????383??2015-08-23?10:46??goodsMS\.project
?????目錄???????????0??2015-08-23?10:52??goodsMS\.settings\
?????文件??????????89??2015-08-23?10:46??goodsMS\.settings\com.genuitec.jboss.ide.eclipse.xdoclet.run.prefs
?????文件?????????629??2015-07-29?09:20??goodsMS\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\gzmu\
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\gzmu\dao\
?????文件????????1656??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\dao\DatabaseDao.class
?????文件????????7272??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\dao\GoodsDao.class
?????文件????????2250??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\dao\UserDao.class
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\gzmu\exception\
?????文件?????????524??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\exception\AuthException.class
?????文件?????????551??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\exception\InputMismatchException.class
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\gzmu\model\
?????文件????????1325??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\model\Goods.class
?????文件?????????938??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\model\User.class
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\gzmu\service\
?????文件????????1494??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\service\GoodsService.class
?????文件?????????933??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\service\UserService.class
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\gzmu\util\
?????文件?????????749??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\util\Space.class
?????目錄???????????0??2015-08-23?10:52??goodsMS\bin\com\java\gzmu\view\
?????文件???????10958??2015-08-23?10:46??goodsMS\bin\com\java\gzmu\view\LoginStart.class
?????目錄???????????0??2015-08-23?10:52??goodsMS\db\
?????文件????????2307??2015-08-23?10:50??goodsMS\db\db_goodsMS.sql
?????目錄???????????0??2015-08-23?10:52??goodsMS\lib\
?????文件??????972009??2015-07-19?10:11??goodsMS\lib\mysql-connector-java-5.1.36-bin.jar
?????目錄???????????0??2015-08-23?10:52??goodsMS\src\
............此處省略20個文件信息