package?com.szx.jnmc;

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

public?class?DBOper?{

	public?Connection?conn?=?null;
	public?PreparedStatement?ps?=?null;
	public?ResultSet?rs?=?null;
	/**
	?*?連接數據庫
	?*?@param?server
	?*?@param?dbname
	?*?@param?dbuser
	?*?@param?dbpwd
	?*?@return
	?*?@throws?SQLException
	?*?@throws?ClassNotFoundException
	?*/
	public?Connection?getConn（String?serverString?dbnameString?dbuserString?dbpwd）?throws?SQLException?ClassNotFoundException{		
		String?DRIVER?=?“com.mysql.jdbc.Driver“;
		String?URL?=?“jdbc:mysql://“?+?server?+?“:3306/“?+?dbname?+?“?user=“
				+?dbuser?+?“&password=“?+dbpwd+“&useUnicode=true&characterEncoding=utf8“;
		Class.forName（DRIVER）;
		conn?=?DriverManager.getConnection（URL）;		
		return?conn;
	}
	/**
	?*?關閉數據庫連接
	?*/
	public?void?closeAll（）{
		try{
			if（rs?!=?null）{
				rs.close（）;
			}
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}finally{
			try{
				if（ps?!=?null）{
					ps.close（）;
				}
			}catch（SQLException?e）{
				e.printStackTrace（）;				
			}finally{
				try{
					if（conn?!=?null）{
						conn.close（）;
					}
				}catch（SQLException?e）{
					e.printStackTrace（）;					
				}
			}
		}
	}
	/**
	?*?執行SQL語句，只進行查詢，不進行增刪改
	?*?@param?preparedsql
	?*?@param?param
	?*?@return
	?*/
	public?ResultSet?executeQuery（String?preparedsqlString[]param）{
		try{
			ps?=?conn.prepareStatement（preparedsql）;
			if（param?!=?null）{
				for?（int?i?=?0;?i?					ps.setString（i?+?1?param[i]）;
				}
			}
			rs?=?ps.executeQuery（）;
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}
		return?rs;
	}
	/**
	?*?執行sql語句，進行增刪改，不進行查詢
	?*?@param?preparedsql
	?*?@param?param
	?*?@return
	?*/
	public?int?executeUpdate（String?preparedsqlString[]param）{
		int?num?=?0;
		try{
			ps?=?conn.prepareStatement（preparedsql）;
			if（param?!=?null）{
				for?（int?i?=?0;?i?					ps.setString（i?+?1?param[i]）;
				}
			}
			num?=?ps.executeUpdate（）;
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}
		return?num;
		
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-05?01:33??leftWords\
?????文件?????????842??2017-06-05?01:33??leftWords\.classpath
?????文件????????1042??2017-06-05?01:33??leftWords\.project
?????目錄???????????0??2017-06-05?01:33??leftWords\.settings\
?????文件?????????503??2017-06-05?01:33??leftWords\.settings\.jsdtscope
?????文件?????????364??2017-06-05?01:33??leftWords\.settings\org.eclipse.jdt.core.prefs
?????文件?????????479??2017-06-05?01:33??leftWords\.settings\org.eclipse.wst.common.component
?????文件?????????345??2017-06-05?01:33??leftWords\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-06-05?01:33??leftWords\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-06-05?01:33??leftWords\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-06-05?01:33??leftWords\build\
?????目錄???????????0??2017-06-05?01:33??leftWords\build\classes\
?????目錄???????????0??2017-06-05?01:33??leftWords\build\classes\com\
?????目錄???????????0??2017-06-05?01:33??leftWords\build\classes\com\szx\
?????目錄???????????0??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\
?????文件????????3597??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\DBOper.class
?????文件????????1315??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\Message.class
?????文件????????3719??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\MsgDao.class
?????文件?????????739??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\Reply.class
?????文件????????2186??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\ReplyDao.class
?????文件????????1282??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\User.class
?????文件????????2481??2017-06-05?01:33??leftWords\build\classes\com\szx\jnmc\UserDao.class
?????目錄???????????0??2017-06-05?01:33??leftWords\src\
?????目錄???????????0??2017-06-05?01:33??leftWords\src\com\
?????目錄???????????0??2017-06-05?01:33??leftWords\src\com\szx\
?????目錄???????????0??2017-06-05?01:33??leftWords\src\com\szx\jnmc\
?????文件????????2275??2017-06-05?01:33??leftWords\src\com\szx\jnmc\DBOper.java
?????文件?????????822??2017-06-05?01:33??leftWords\src\com\szx\jnmc\Message.java
?????文件????????2784??2017-06-05?01:33??leftWords\src\com\szx\jnmc\MsgDao.java
?????文件?????????366??2017-06-05?01:33??leftWords\src\com\szx\jnmc\Reply.java
?????文件????????1122??2017-06-05?01:33??leftWords\src\com\szx\jnmc\ReplyDao.java
............此處省略26個文件信息