package?com.cn;

import?java.sql.*;

public?class?lkdb?{
	?private?Connection?conn=null;?
	?private?ResultSet?rs=null;
	????/**連接數據庫的URL*/??
	????private?final?String?url=“jdbc:mysql://localhost:3306/chatroom“;??
	????/**指定數據的用戶名和密碼*/??
	????private?final?String?username=“root“;??
	????private?final?String?password=“root“;??
	
	??//??private?ResultSet?resultSet=null;??
	??//??private?PreparedStatement?pstmt=null;??
	?
	????/**?
	?????*?建立數據的連接?
	?????*?@exception?SQLException?ClassNotFoundException?
	?????*/??
	????@SuppressWarnings（“finally“）??
	????public?Connection?setconnection（）{??
	????????try{??
	????????????Class.forName（“com.mysql.jdbc.Driver“）;??
	????????????conn=DriverManager.getConnection（urlusernamepassword）;??
	????????????System.out.println（“連接數據庫成功“）;??
	????????}catch（Exception?e）{??
	????????????e.printStackTrace（）;??
	????????????System.out.println（“建立數據庫發(fā)生錯誤！“）;??
	????????}finally{??
	????????????return?conn;??
	????????}??
	????}?
	????
	??//返回查詢結果集?	
	????public?ResultSet?executeQuery（String?sqlConnection?con）{
	????	
	????	try{
	????	Statement?stm=con.createStatement（）;
	????
	????rs=stm.executeQuery（sql）;
	???
	???System.out.println（“查詢成功“）;
	????	}?	
	????		catch（Exception?e）{
	????			System.out.println（“查詢失敗“）;
	????			
	????			}
???????return?rs;

	?}
	????
	??//返回更新影響行數
	????public?int?executeUpdate（String?sqlConnection?con）{
	????	int?count=0;
	????	Statement?stm=null;
	????	try{
	????		stm=con.createStatement（）;
	????		count=stm.executeUpdate（sql）;
	????		System.out.println（“注冊成功“）;???		
	????		}
	????		catch（Exception?e）{
	????			System.out.println（“修改失敗“）;
	????			}
	????	???finally{
	????				try{
	????					if（stm!=null）
	????				????stm.close（）;
????????????????????????????}catch（SQLException?e）
	????					{
	????					System.out.println（“釋放資源失敗“）;
	????					}
	????	??????????}??
	????	??????????	return?count;
	????????}
	????
	????
	????public?void?freers（ResultSet?rs）{
	?????	try
	?????	{
	?????		if（rs!=null）{
	?????			rs.close（）;
	?????			System.out.println（“rs關閉成功“）;
	?????			}
	?????		}catch（Exception?e）{
	?????			System.out.println（“關閉結果集失敗“）;
	?????			}
	?????	
	?????	}?
	????
	?????public?void?freerc（Connection?con）{
	????	?
	????	?try{
	????		?if（con!=null）{
	????			?con.close（）;
	????			?System.out.println（“con關閉“）;
	????		?}
	????		?}catch（Exception?e）{
	????			?
	????			?System.out.println（“關閉con失敗“）;
	????		?}
	?}
	?????
	/*public?static?void?main（String[]?args）?throws?SQLException?{
		//?TODO?Auto-generated?method?stub
	?lkdb?lk=new?lkdb（）;
	?Connection?con=lk.setconnection（）;
	?String?sql=“select?*?from?userinfo“;
	?String?sql1=“insert?into?userinfo（unameupass）?VALUES（‘mark‘‘0721‘）“;
	?lk.executeUpdate（sql1?con）;
	?ResultSet?rs=lk.executeQuery（sql?con）;
	
	?while?（rs.next（））?{
		????int?id?=?rs.getInt（1）;
		????String?name?=?rs.getString（2）;
		????System.out.println（id）;
		????System.out.println（name）;
		}
	?lk.freerc（con）;
	?lk.freers（rs）;
	}*/

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????648??2014-10-11?21:52??.classpath
?????文件????????1001??2014-10-11?21:52??.project
?????目錄???????????0??2014-10-11?21:52??.settings\
?????文件?????????491??2014-10-11?21:52??.settings\.jsdtscope
?????文件??????????55??2014-10-11?21:52??.settings\org.eclipse.core.resources.prefs
?????文件?????????357??2014-10-11?21:52??.settings\org.eclipse.jdt.core.prefs
?????文件?????????457??2014-10-11?21:52??.settings\org.eclipse.wst.common.component
?????文件?????????335??2014-10-11?21:52??.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-10-11?21:52??.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-10-11?21:52??.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????65??2014-10-11?21:52??README.md
?????目錄???????????0??2014-10-11?21:52??WebContent\
?????目錄???????????0??2014-10-11?21:52??WebContent\meta-INF\
?????文件??????????36??2014-10-11?21:52??WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2014-10-11?21:52??WebContent\WEB-INF\
?????文件???????55348??2014-10-11?21:52??WebContent\WEB-INF\11.jpg
?????文件????????7191??2014-10-11?21:52??WebContent\WEB-INF\chat.js
?????目錄???????????0??2014-10-11?21:52??WebContent\WEB-INF\lib\
?????文件??????188671??2014-10-11?21:52??WebContent\WEB-INF\lib\commons-beanutils-1.7.0.jar
?????文件??????559366??2014-10-11?21:52??WebContent\WEB-INF\lib\commons-collections-3.1.jar
?????文件???????87776??2014-10-11?21:52??WebContent\WEB-INF\lib\commons-io-1.3.2.jar
?????文件??????245274??2014-10-11?21:52??WebContent\WEB-INF\lib\commons-lang-2.3.jar
?????文件???????38015??2014-10-11?21:52??WebContent\WEB-INF\lib\commons-logging-1.0.4.jar
?????文件???????44598??2014-10-11?21:52??WebContent\WEB-INF\lib\commons-logging-api-1.1.jar
?????文件???????86381??2014-10-11?21:52??WebContent\WEB-INF\lib\ezmorph-1.0.4.jar
?????文件??????143977??2014-10-11?21:52??WebContent\WEB-INF\lib\json-lib-2.2.2-jdk15.jar
?????文件??????709922??2014-10-11?21:52??WebContent\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar
?????文件????????1788??2014-10-11?21:52??WebContent\WEB-INF\login.html
?????文件?????????367??2014-10-11?21:52??WebContent\WEB-INF\test.html
?????目錄???????????0??2014-10-11?21:52??WebContent\build\
?????目錄???????????0??2014-10-11?21:52??WebContent\build\examples\
............此處省略1251個文件信息