package?org.common;

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

/**
?*?@author?dalin
?*
?*/
public?class?Conn?{
	Connection?conn=null;
	Statement?stmt=null;
	ResultSet?rs=null;
	/**
	?*???????
	?*/
	public?Conn（）{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	/**
	?*?@param?sql
	?*?@return?
	?*/
	public?ResultSet?executeQuery（String?sql）{
		try{
		conn=DriverManager.getConnection（“jdbc:mysql://localhost:3306/novel?useUnicode=true&characterEncoding=utf-8““root““1011“）;
		stmt=conn.createStatement（）;
		rs=stmt.executeQuery（sql）;
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}
		return?rs;
	}
	/**
	?*?@param?sql
	?*?@return?
	?*/
	public?int?executeUpdate（String?sql）{
		int?result=0;
		try?{
			conn=DriverManager.getConnection（“jdbc:mysql://localhost:3306/novel?useUnicode=true&characterEncoding=utf-8““root““1011“）;
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			result=stmt.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			result=0;
		}
		return?result;	
	}
	
	public?void?close（）{
		if（rs!=null）
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		if（stmt!=null）
			try?{
				stmt.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		if（conn!=null）
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-01-04?17:06??novel\
?????文件????????1027??2016-12-28?08:52??novel\.classpath
?????文件????????1330??2016-12-22?11:12??novel\.project
?????目錄???????????0??2017-01-04?17:06??novel\.settings\
?????文件?????????522??2016-12-21?22:48??novel\.settings\.jsdtscope
?????文件??????????83??2016-12-29?22:45??novel\.settings\com.genuitec.eclipse.core.prefs
?????文件?????????364??2016-12-21?22:48??novel\.settings\org.eclipse.jdt.core.prefs
?????文件?????????474??2016-12-21?22:48??novel\.settings\org.eclipse.wst.common.component
?????文件?????????414??2016-12-21?22:48??novel\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-12-21?22:48??novel\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-12-21?22:48??novel\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-01-04?17:06??novel\src\
?????目錄???????????0??2017-01-04?17:06??novel\src\org\
?????目錄???????????0??2017-01-04?17:06??novel\src\org\common\
?????文件????????1829??2016-12-25?14:31??novel\src\org\common\Conn.java
?????文件????????1491??2016-12-25?14:32??novel\src\org\common\DataConverter.java
?????文件?????????528??2016-12-25?14:32??novel\src\org\common\DataValidator.java
?????文件????????2206??2016-12-30?14:27??novel\src\org\common\Utilty.java
?????目錄???????????0??2017-01-04?17:06??novel\src\org\dal\
?????文件?????????831??2016-12-25?14:33??novel\src\org\dal\Admin.java
?????文件????????3277??2016-12-30?14:17??novel\src\org\dal\Author.java
?????文件????????3274??2016-12-30?20:49??novel\src\org\dal\Comment.java
?????文件????????1949??2016-12-25?14:38??novel\src\org\dal\Genre.java
?????文件????????3964??2016-12-25?14:40??novel\src\org\dal\Novel.java
?????文件????????4404??2016-12-30?14:18??novel\src\org\dal\Reader.java
?????目錄???????????0??2017-01-04?17:06??novel\src\org\model\
?????文件?????????420??2016-12-25?14:41??novel\src\org\model\AdminInfo.java
?????文件?????????730??2016-12-25?14:41??novel\src\org\model\AuthorInfo.java
?????文件?????????844??2016-12-25?14:41??novel\src\org\model\CommentInfo.java
?????文件?????????423??2016-12-25?14:41??novel\src\org\model\GenreInfo.java
?????文件????????1142??2016-12-25?14:41??novel\src\org\model\NovelInfo.java
............此處省略116個文件信息