package?com.dao;

import?java.sql.SQLException;

import?com.mysql.jdbc.Connection;
import?com.util.DBConnection;

public?class?AddDAO?{
	/**
	?*?添加聯系人
	?*?@param?name?姓名
	?*?@param?telePhone?手機號
	?*?@param?homePhone?座機
	?*?@param?addr?家庭住址
	?*?@param?email?郵箱
	?*?@param?remark?備注
	?*?@return?flag?判斷是否成功執(zhí)行查詢語句的標志
	?*/
	public?int??Add（String?nameString?telePhoneString?homePhoneString?addrString?emailString?remark）?{
		//?創(chuàng)建SQL語句
		String?sql?=?“insert?into?CONTACT（nametelePhonehomePhoneaddremailremark）?values（??????）“;
		System.out.println（sql）;
		Connection?conn?=?null;
		java.sql.PreparedStatement?st?=?null;
		int?flag?=??0;
		try?{
			//?建立數據庫連接
			conn?=?（Connection）?DBConnection.getConnection（）;
			//?創(chuàng)建一個查詢語句對象
			st?=?conn.prepareStatement（sql）;
			st.setString（1?name）;
			st.setString（2?telePhone）;
			st.setString（3?homePhone）;
			st.setString（4?addr）;
			st.setString（5?email）;
			st.setString（6?remark）;
			//?執(zhí)行SQL語句
			flag?=?st.executeUpdate（）;

		}?catch?（SQLException?se）?{
			se.printStackTrace（）;

		}finally{
			//新增操作不涉及結果集，將resultSet參數設置為null
			DBConnection.closeStatement（st）;
			DBConnection.closeConnection（conn）;
		}
		return?flag;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????764??2012-04-20?01:16??ContactJWPro\.classpath

?????文件???????1045??2012-04-19?13:24??ContactJWPro\.project

?????文件????????503??2012-04-19?13:24??ContactJWPro\.settings\.jsdtscope

?????文件????????106??2012-04-19?14:55??ContactJWPro\.settings\org.eclipse.core.resources.prefs

?????文件????????401??2012-04-19?13:24??ContactJWPro\.settings\org.eclipse.jdt.core.prefs

?????文件????????490??2012-04-19?13:24??ContactJWPro\.settings\org.eclipse.wst.common.component

?????文件????????345??2012-04-19?13:24??ContactJWPro\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2012-04-19?13:24??ContactJWPro\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-04-19?13:24??ContactJWPro\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1814??2012-04-22?13:28??ContactJWPro\build\classes\com\dao\AddDAO.class

?????文件???????1373??2012-04-22?13:28??ContactJWPro\build\classes\com\dao\DeleteDAO.class

?????文件???????2074??2012-04-22?13:29??ContactJWPro\build\classes\com\dao\DetailDAO.class

?????文件???????2426??2012-04-22?13:08??ContactJWPro\build\classes\com\dao\QueryByNameDAO.class

?????文件???????2277??2012-04-22?13:10??ContactJWPro\build\classes\com\dao\QueryDAO.class

?????文件???????1765??2012-04-22?13:12??ContactJWPro\build\classes\com\model\Contact.class

?????文件???????3452??2012-04-22?13:35??ContactJWPro\build\classes\com\servlet\AddServlet.class

?????文件???????2321??2012-04-22?13:20??ContactJWPro\build\classes\com\servlet\DeleServlet.class

?????文件???????2118??2012-04-22?13:20??ContactJWPro\build\classes\com\servlet\DetailServlet.class

?????文件???????2196??2012-04-22?13:22??ContactJWPro\build\classes\com\servlet\QueryByNameServlet.class

?????文件???????1963??2012-04-22?13:24??ContactJWPro\build\classes\com\servlet\QueryServlet.class

?????文件???????2031??2012-04-22?13:26??ContactJWPro\build\classes\com\util\DBConnection.class

?????文件????????841??2012-04-22?12:18??ContactJWPro\DB\db_contract.sql

?????文件???????1321??2012-04-22?13:28??ContactJWPro\src\com\dao\AddDAO.java

?????文件????????878??2012-04-22?13:28??ContactJWPro\src\com\dao\DeleteDAO.java

?????文件???????1495??2012-04-22?13:29??ContactJWPro\src\com\dao\DetailDAO.java

?????文件???????1644??2012-04-22?13:08??ContactJWPro\src\com\dao\QueryByNameDAO.java

?????文件???????1563??2012-04-22?13:10??ContactJWPro\src\com\dao\QueryDAO.java

?????文件???????1277??2012-04-29?11:01??ContactJWPro\src\com\model\Contact.java

?????文件???????2598??2012-04-29?11:02??ContactJWPro\src\com\servlet\AddServlet.java

?????文件???????1393??2012-04-22?13:20??ContactJWPro\src\com\servlet\DeleServlet.java

............此處省略34個文件信息