package?kechengsheji.com.dh.db;
import?java.sql.Connection;

import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.Properties;
import?java.util.Map.Entry;

public?class?DBOper?{
	Connection?conn?=?null;
	PreparedStatement?pstmt?=?null;
	ResultSet?rs?=?null;

	/**
	?*?得到數(shù)據(jù)庫連接
	?*/
	public?Connection?getConn（String?server?String?dbname?String?user
			String?pwd）?throws?ClassNotFoundException?SQLException
			InstantiationException?IllegalAccessException?{
		String?DRIVER?=?“com.mysql.jdbc.Driver“;
		String?URL?=?“jdbc:mysql://“?+?server?+?“:3306/“?+?dbname?+?“?user=“
				+?user?+?“&password=“?+?pwd+“&useUnicode=true&characterEncoding=utf8“;
		//?注冊驅動
		Class.forName（DRIVER）;?
		?//?獲得數(shù)據(jù)庫連接
		conn?=?DriverManager.getConnection（URL）;
		//?返回連接
		return?conn;?
	}

	/**
	?*?釋放資源
	?*/
	public?void?closeAll（）?{
		try?{
			if（rs?!=?null）?{
				rs.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			try?{
				if（pstmt?!=?null）?{
					pstmt.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}?finally?{
				try?{
					if（conn?!=?null）?{
						conn.close（）;
					}
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
		}
	}

	/**
	?*?執(zhí)行SQL語句，可以進行查詢
	?*/
	public?ResultSet?executeQuery（String?preparedSql?String[]?param）?{
		//處理SQL執(zhí)行SQL?
		try?{
			?//?得到PreparedStatement對象
			pstmt?=?conn.prepareStatement（preparedSql）;
			if?（param?!=?null）?{
				for?（int?i?=?0;?i?					//?為預編譯sql設置參數(shù)
					pstmt.setString（i?+?1?param[i]）;?
				}
			}
			//?執(zhí)行SQL語句
			rs?=?pstmt.executeQuery（）;?
		}?catch?（SQLException?e）?{
			//?處理SQLException異常
			e.printStackTrace（）;?
		}
		return?rs;
	}

	/**
	?*?執(zhí)行SQL語句，可以進行增、刪、改的操作，不能執(zhí)行查詢
	?*/
	public?int?executeUpdate（String?preparedSql?String[]?param）?{

		int?num?=?0;

	????//處理SQL執(zhí)行SQL?
		try?{
			?//?得到PreparedStatement對象
			pstmt?=?conn.prepareStatement（preparedSql）;
			if?（param?!=?null）?{
				for?（int?i?=?0;?i?					?//?為預編譯sql設置參數(shù)
					pstmt.setString（i?+?1?param[i]）;
				}
			}
			//?執(zhí)行SQL語句
			num?=?pstmt.executeUpdate（）;?
		}?catch?（SQLException?e）?{
			//?處理SQLException異常
			e.printStackTrace（）;?
		}?
		return?num;
	}
	public?static?void?main（String[]?args）?{
		Properties?p?=?System.getProperties（）;
	???for（Entryject?object>?e:p.entrySet（））{
		???System.out.println（e.getKey（）+“=?“+e.getValue（））;
	???}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-11-28?14:25??kechengsheji\
?????文件????????1154??2019-11-29?16:02??kechengsheji\.classpath
?????文件?????????912??2019-11-28?14:25??kechengsheji\.project
?????目錄???????????0??2019-11-28?14:25??kechengsheji\.settings\
?????文件?????????567??2019-11-28?14:25??kechengsheji\.settings\.jsdtscope
?????文件?????????364??2019-11-28?14:25??kechengsheji\.settings\org.eclipse.jdt.core.prefs
?????文件?????????488??2019-11-28?14:25??kechengsheji\.settings\org.eclipse.wst.common.component
?????文件?????????345??2019-11-28?14:25??kechengsheji\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2019-11-28?14:25??kechengsheji\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-11-28?14:25??kechengsheji\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-11-28?14:25??kechengsheji\build\
?????目錄???????????0??2019-11-29?16:02??kechengsheji\build\classes\
?????目錄???????????0??2019-11-29?16:02??kechengsheji\build\classes\kechengsheji\
?????目錄???????????0??2019-11-29?16:02??kechengsheji\build\classes\kechengsheji\com\
?????目錄???????????0??2019-12-02?19:13??kechengsheji\build\classes\kechengsheji\com\dh\
?????目錄???????????0??2019-11-29?16:02??kechengsheji\build\classes\kechengsheji\com\dh\db\
?????文件????????4666??2019-11-29?16:02??kechengsheji\build\classes\kechengsheji\com\dh\db\DBOper.class
?????文件????????6192??2019-12-03?21:42??kechengsheji\build\classes\kechengsheji\com\dh\db\FlowerDao.class
?????文件????????4082??2019-11-29?16:02??kechengsheji\build\classes\kechengsheji\com\dh\db\UserDao.class
?????目錄???????????0??2019-11-29?16:02??kechengsheji\build\classes\kechengsheji\com\dh\entity\
?????文件????????1554??2019-11-29?16:07??kechengsheji\build\classes\kechengsheji\com\dh\entity\Flower.class
?????文件????????1738??2019-11-29?16:02??kechengsheji\build\classes\kechengsheji\com\dh\entity\User.class
?????目錄???????????0??2019-12-02?19:13??kechengsheji\build\classes\kechengsheji\com\dh\filter\
?????文件????????2260??2019-12-02?19:14??kechengsheji\build\classes\kechengsheji\com\dh\filter\CheckUserFilter.class
?????目錄???????????0??2019-12-02?19:09??kechengsheji\build\classes\kechengsheji\com\dh\listener\
?????文件????????1451??2019-12-02?19:10??kechengsheji\build\classes\kechengsheji\com\dh\listener\ListenLognum.class
?????目錄???????????0??2019-11-29?17:10??kechengsheji\build\classes\kechengsheji\com\dh\Servlet\
?????目錄???????????0??2019-11-30?22:54??kechengsheji\build\classes\kechengsheji\com\dh\Servlet\admin\
?????文件????????3361??2019-11-29?16:17??kechengsheji\build\classes\kechengsheji\com\dh\Servlet\admin\AddFlowerServlet.class
?????文件????????2894??2019-11-30?20:44??kechengsheji\build\classes\kechengsheji\com\dh\Servlet\admin\AddUserServlet.class
?????文件????????3067??2019-11-30?20:44??kechengsheji\build\classes\kechengsheji\com\dh\Servlet\admin\AdminLoginServlet.class
............此處省略70個文件信息