package?com.test.database;

import?java.awt.List;
import?java.sql.*;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.lang.object;
import?com.mysql.jdbc.Connection;

public?class?DBManager?{
	
	public?final?static?String?TABLE_NAME?=?“l(fā)ogin_info“;
	
	public?final?static?String?COLUMN_USERNAME?=?“username“;
	public?final?static?String?COLUMN_PASSWORD?=?“password“;
	public?final?static?String?COLUMN_GENDER?=?“gender“;
	public?final?static?String?COLUMN_AGE?=?“age“;
	public?final?static?String?COLUMN_PHONE?=?“phone“;
	public?final?static?String?COLUMN_EMAIL?=?“email“;
	
	public?Statement?getStatement（）?{
		Connection?connection?=?null;
		Statement?stmt?=?null;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			connection?=?（Connection）?DriverManager.getConnection（“jdbc:mysql://localhost:3306/myDatabase?useUnicode=true&characterEncoding=utf8“?“root“?“root“）;
			stmt?=?connection.createStatement（）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		return?stmt;
	}
	
	public?ArrayListject>>?getDatabaseContents（）?{
		ArrayListject>>?list?=?new?ArrayListject>>（）;
		HashMapject>?map?=?null;
		String?sql?=?“select?*?from?“?+?TABLE_NAME;
		Statement?stmt?=?getStatement（）;
		ResultSet?rst?=?null;
		try?{
	????????rst?=?stmt.executeQuery（sql）;
	????????if（rst?!=?null）?{
				while（rst.next（））?{
					map?=?new?HashMapject>（）;
					map.put（COLUMN_USERNAME?rst.getString（COLUMN_USERNAME））;
					map.put（COLUMN_PASSWORD?rst.getString（COLUMN_PASSWORD））;
					map.put（COLUMN_GENDER?rst.getString（COLUMN_GENDER））;
					map.put（COLUMN_AGE?rst.getInt（COLUMN_AGE））;
					map.put（COLUMN_PHONE?rst.getString（COLUMN_PHONE））;
					map.put（COLUMN_EMAIL?rst.getString（COLUMN_EMAIL））;
					list.add（map）;
				}
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		return?list;
	}
	
	public?ResultSet?query（String?sql）?{
		ResultSet?rst?=?null;
		Statement?stmt?=?getStatement（）;
		System.out.println（“stmt?=?“?+?stmt）;
		try?{
			rst?=?stmt.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?rst;
	}
	
	public?int?update（String?sql）?{
		Statement?stmt?=?getStatement（）;
		int?result?=?0;
		try?{
			result?=?stmt.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
	}
}

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

?????文件????????780??2013-07-17?11:51??androidWeb\.classpath

?????文件????????303??2012-06-11?16:40??androidWeb\.mymetadata

?????文件???????1228??2012-06-11?16:59??androidWeb\.project

?????文件?????????96??2013-07-17?11:44??androidWeb\.settings\org.eclipse.jdt.ui.prefs

?????文件???????2713??2013-07-19?15:14??androidWeb\src\com\test\database\DBManager.java

?????文件???????3832??2013-07-19?15:18??androidWeb\src\com\test\servlet\loadMessage.java

?????文件???????3751??2013-07-19?15:18??androidWeb\src\com\test\servlet\NewAccount.java

?????文件????????892??2013-07-16?16:40??androidWeb\WebRoot\index.jsp

?????文件?????????39??2012-06-11?16:40??androidWeb\WebRoot\meta-INF\MANIFEST.MF

?????文件???????3692??2013-07-19?15:14??androidWeb\WebRoot\WEB-INF\classes\com\test\database\DBManager.class

?????文件???????3510??2013-07-19?15:18??androidWeb\WebRoot\WEB-INF\classes\com\test\servlet\loadMessage.class

?????文件???????4640??2013-07-19?15:18??androidWeb\WebRoot\WEB-INF\classes\com\test\servlet\NewAccount.class

?????文件?????249351??2013-07-17?11:49??androidWeb\WebRoot\WEB-INF\lib\gson-2.2.4-javadoc.jar

?????文件?????127564??2013-07-17?11:49??androidWeb\WebRoot\WEB-INF\lib\gson-2.2.4-sources.jar

?????文件?????190418??2013-07-17?11:49??androidWeb\WebRoot\WEB-INF\lib\gson-2.2.4.jar

?????文件????8143387??2013-07-17?11:51??androidWeb\WebRoot\WEB-INF\lib\mysql-connector-java-3.1.12.zip

?????文件?????495944??2013-07-17?11:51??androidWeb\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.4-bin.jar

?????文件???????1265??2013-07-19?15:19??androidWeb\WebRoot\WEB-INF\web.xml

?????文件????????364??2013-07-11?17:05??LoginTest\.classpath

?????文件????????845??2013-07-11?17:05??LoginTest\.project

?????文件???????1028??2013-07-17?15:03??LoginTest\AndroidManifest.xml

?????文件???????1093??2013-07-19?16:01??LoginTest\bin\classes\com\test\login\CreateUserActivity$1.class

?????文件???????4213??2013-07-19?16:01??LoginTest\bin\classes\com\test\login\CreateUserActivity$2.class

?????文件???????7068??2013-07-19?16:01??LoginTest\bin\classes\com\test\login\CreateUserActivity.class

?????文件???????1090??2013-07-19?16:04??LoginTest\bin\classes\com\test\login\LoginActivity$1.class

?????文件???????3744??2013-07-19?16:04??LoginTest\bin\classes\com\test\login\LoginActivity$2.class

?????文件???????5282??2013-07-19?16:04??LoginTest\bin\classes\com\test\login\LoginActivity.class

?????文件????????328??2013-07-19?15:50??LoginTest\bin\classes\com\test\login\R$attr.class

?????文件????????429??2013-07-19?15:50??LoginTest\bin\classes\com\test\login\R$drawable.class

?????文件???????1674??2013-07-19?15:50??LoginTest\bin\classes\com\test\login\R$id.class

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