package?com.oristand.demo;

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

public?class?baseConnection?{

	public?static?final?String?DRIVER?=?“com.mysql.jdbc.Driver“;
	public?static?final?String?URL?=?“jdbc:mysql://localhost:3306/new2“;
	public?static?final?String?USERNAME?=?“root“;
	public?static?final?String?PASSWORD?=?“root“;

	//?create?Connected
	public?Connection?getCon（）?throws?ClassNotFoundException?SQLException?{
		Class.forName（DRIVER）;
		Connection?con?=?DriverManager.getConnection（URL?USERNAME?PASSWORD）;
		return?con;
	}
	
	//insert?update?delete?method
????public?int?executeSql（String?sqlint[]?parms）{
????????int?n=0;
????????Connection?con=null;
????????PreparedStatement?pstmt=null;
????????try?{
????????????con=getCon（）;
????????????pstmt=con.prepareStatement（sql）;
????????????if（parms!=null）{
????????????????for（int?i=0;i????????????????????pstmt.setInt（i+1parms[i]）;
????????????????}
????????????}
????????????n=pstmt.executeUpdate（）;
????????
????????}?catch?（ClassNotFoundException?e）?{
????????????//?TODO?Auto-generated?catch?block
????????????e.printStackTrace（）;
????????}?catch?（SQLException?e）?{
????????????//?TODO?Auto-generated?catch?block
????????????e.printStackTrace（）;
????????}finally{
????????closeAll（conpstmtnull）;
????????}
????????return?n;
????}
	
	//insert?update?delete?method
	public?int?executeSql（String?sqlString[]?parms）{
		int?n=0;
		Connection?con=null;
		PreparedStatement?pstmt=null;
		try?{
			con=getCon（）;
			pstmt=con.prepareStatement（sql）;
			if（parms!=null）{
				for（int?i=0;i					pstmt.setString（i+1parms[i]）;
				}
			}
			n=pstmt.executeUpdate（）;
		
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
		closeAll（conpstmtnull）;
		}
		return?n;
	}

	//?close?All?objects?or?interfaces
	public?void?closeAll（Connection?con?PreparedStatement?pstmt?ResultSet?rs）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if?（pstmt?!=?null）?{
			try?{
				pstmt.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		try?{
			if?（con?!=?null?&&?!con.isClosed（））?{
				con.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1007??2016-05-20?14:27??myNews\.classpath

?????文件????????291??2016-05-20?14:27??myNews\.mymetadata

?????文件???????1749??2016-05-20?14:27??myNews\.project

?????文件????????500??2016-05-20?14:27??myNews\.settings\.jsdtscope

?????文件????????382??2016-05-20?14:27??myNews\.settings\com.genuitec.eclipse.migration.prefs

?????文件????????364??2016-05-20?14:27??myNews\.settings\org.eclipse.jdt.core.prefs

?????文件????????544??2016-05-20?14:27??myNews\.settings\org.eclipse.wst.common.component

?????文件????????412??2016-05-20?14:27??myNews\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-05-20?14:27??myNews\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-05-20?14:27??myNews\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2723??2016-05-20?14:27??myNews\src\com\oristand\demo\baseConnection.java

?????文件???????3085??2016-05-20?14:27??myNews\src\com\oristand\demo\dao\FirstLevelDao.java

?????文件????????967??2016-05-20?14:27??myNews\src\com\oristand\demo\dao\UserInfoDao.java

?????文件????????974??2016-05-20?14:27??myNews\src\com\oristand\demo\entity\FirstLevel.java

?????文件????????543??2016-05-20?14:27??myNews\src\com\oristand\demo\entity\UserInfo.java

?????文件?????????25??2016-05-20?14:27??myNews\src\meta-INF\MANIFEST.MF

?????文件???????1674??2016-05-20?14:27??myNews\WebRoot\addFirst.jsp

?????文件???????1058??2016-05-20?14:27??myNews\WebRoot\adminIndex.jsp

?????文件????????239??2016-05-20?14:27??myNews\WebRoot\checkLogin.jsp

?????文件???????1231??2016-05-20?14:27??myNews\WebRoot\count.jsp

?????文件????????696??2016-05-20?14:27??myNews\WebRoot\doAddFirst.jsp

?????文件????????607??2016-05-20?14:27??myNews\WebRoot\doDelFirst.jsp

?????文件???????1329??2016-05-20?14:27??myNews\WebRoot\doLogin.jsp

?????文件????????188??2016-05-20?14:27??myNews\WebRoot\doLoginout.jsp

?????文件????????747??2016-05-20?14:27??myNews\WebRoot\doUpdateFirst.jsp

?????文件???????1341??2016-05-20?14:27??myNews\WebRoot\editFirst.jsp

?????文件????????516??2016-05-20?14:27??myNews\WebRoot\error.html

?????文件????????833??2016-05-20?14:27??myNews\WebRoot\firstBack.jsp

?????文件??????20220??2016-05-20?14:27??myNews\WebRoot\images\banner.jpg

?????文件??????41410??2016-05-20?14:27??myNews\WebRoot\images\head.gif

............此處省略44個(gè)文件信息