package?org.jinshi366.dao;

import?java.math.BigDecimal;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?org.jinshi366.utils.DBConnection;

public?class?UserDao?{

	Connection?conn?=?null?;?
	PreparedStatement?ps?=?null?;
	Statement?st?;?
	ResultSet?rs?=?null?;?
	//注冊用戶

	/**
	?*?@title:?register
	?*?@Description?:?添加一個用戶?并在?userinfo?添加用戶信息
	?*?@param?name
	?*?@param?password?:?void
	?*?@auther?:?
	?*?@2016年10月4日?@下午5:30:55
	?*/
	public?void?register（String?name??String?password）{
		conn?=?DBConnection.getDBConnection（）?;?
		String?sql?=?“insert?into?user?（name??password）?values?（??）“?;?
		String?userinfosql?=?“insert?into?userinfo?（username??income）?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1604??2016-10-04?19:18??servlet-mysql-demo\practice.sql

?????文件????????315??2016-10-04?19:32??servlet-mysql-demo\readme.txt

?????文件???????1019??2016-09-28?12:24??servlet-mysql-demo\servlet_mysql_demo\.classpath

?????文件???????1051??2016-09-27?19:09??servlet-mysql-demo\servlet_mysql_demo\.project

?????文件????????567??2016-09-27?19:09??servlet-mysql-demo\servlet_mysql_demo\.settings\.jsdtscope

?????文件????????364??2016-09-27?19:09??servlet-mysql-demo\servlet_mysql_demo\.settings\org.eclipse.jdt.core.prefs

?????文件????????506??2016-09-27?19:09??servlet-mysql-demo\servlet_mysql_demo\.settings\org.eclipse.wst.common.component

?????文件????????349??2016-09-27?19:09??servlet-mysql-demo\servlet_mysql_demo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-09-27?19:09??servlet-mysql-demo\servlet_mysql_demo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-09-27?19:09??servlet-mysql-demo\servlet_mysql_demo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3606??2016-10-04?19:03??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\dao\UserDao.class

?????文件???????1787??2016-10-04?16:13??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\servlet\AddMoneyServlet.class

?????文件???????2249??2016-10-04?18:24??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\servlet\LoginServlet.class

?????文件???????1702??2016-09-29?19:03??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\servlet\QueryMoneyServlet.class

?????文件???????1881??2016-10-04?19:10??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\servlet\RegisterServlet.class

?????文件???????1812??2016-10-04?15:57??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\servlet\SubtractMoneyServlet.class

?????文件????????504??2016-09-29?14:43??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\test\DBTest.class

?????文件????????605??2016-09-29?14:43??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\test\LoginTest.class

?????文件????????608??2016-09-29?14:43??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\test\RegisterTest.class

?????文件???????2038??2016-09-29?14:43??servlet-mysql-demo\servlet_mysql_demo\build\classes\org\jinshi366\utils\DBConnection.class

?????文件???????3829??2016-10-04?19:03??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\dao\UserDao.java

?????文件???????1115??2016-10-04?16:13??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\servlet\AddMoneyServlet.java

?????文件???????1530??2016-10-04?18:24??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\servlet\LoginServlet.java

?????文件???????1154??2016-09-29?19:03??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\servlet\QueryMoneyServlet.java

?????文件???????1392??2016-10-04?19:10??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\servlet\RegisterServlet.java

?????文件???????1140??2016-10-04?15:57??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\servlet\SubtractMoneyServlet.java

?????文件????????274??2016-09-28?13:22??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\test\DBTest.java

?????文件????????309??2016-09-28?19:31??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\test\LoginTest.java

?????文件????????297??2016-09-28?19:28??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\test\RegisterTest.java

?????文件???????1432??2016-09-28?15:03??servlet-mysql-demo\servlet_mysql_demo\src\org\jinshi366\utils\DBConnection.java

............此處省略42個文件信息