package?com.lll.dao;

import?java.sql.ResultSet;
import?java.util.Vector;

import?javax.swing.JOptionPane;

import?com.lll.until.Jdbc;

public?class?Dao?extends?Jdbc?{

	public?boolean?check（String?user?String?pass）?{
		//?boolean?b=false;

		boolean?r?=?false;//?user=“abc“;pass=“123“;
		try?{
			this.start（）;
			String?sql?=?“select?*?from?userinfor?“?+?“where?username=‘“?+?user
					+?“‘?and?password=‘“?+?pass?+?“‘?“;
			ResultSet?rs?=?this.query（sql）;
			if?（rs.next（））?{
				r?=?true;//?System.out.println（r）;
			}

		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			this.close（）;
		}

		return?r;

	}

	public?Vector?select（String?s）?{
		Vector?v?=?new?Vector（）;
		try?{
			this.start（）;
			String?sql?=?“select?*?from?userinfor?“;
			ResultSet?rs?=?this.query（sql）;

			while?（rs.next（））?{
				Vector?row?=?new?Vector（）;
				row.add（rs.getString（“id“））;
				row.add（rs.getString（“username“））;
				row.add（rs.getString（“password“））;
				v.add（row）;//?System.out.print（c）;
				//?System.out.println（v）;
			}
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			this.close（）;
		}
		return?v;

	}

	public?void?reset（String?pass?String?user）?{
		try?{
			this.start（）;
			String?sql?=?“update?userinfor?set?password=‘“?+?pass
					+?“‘where?username=‘“?+?user?+?“‘“;

			this.update（sql）;
			JOptionPane.showConfirmDialog（null?“保存成功“?“確認“
					JOptionPane.YES_NO_OPTION）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			this.close（）;
		}
	}

	/**
	?*?@param?args
	?*/
	public?static?void?main（String[]?args）?{
		//?TODO?Auto-generated?method?stub

	}

}

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

?????文件????????286??2011-02-17?11:08??jiudain\.classpath

?????文件????????499??2011-02-15?14:47??jiudain\.project

?????文件???????9426??2011-02-19?17:20??jiudain\hs_err_pid1664.log

?????文件?????227885??2011-02-16?17:53??jiudain\src\image\as.jpg

?????文件??????10980??2011-02-15?16:47??jiudain\src\image\down.jpg

?????文件??????30066??2011-02-15?16:47??jiudain\src\image\left.jpg

?????文件???????2339??2011-02-16?10:12??jiudain\src\image\r.jpg

?????文件??????61686??2011-02-20?19:54??jiudain\src\image\right.jpg

?????文件?????139800??2011-02-20?15:14??jiudain\src\image\top.jpg

?????文件???????1638??2011-02-20?18:02??jiudain\src\com\lll\until\Jdbc.java

?????文件???????5816??2011-02-20?18:00??jiudain\src\com\lll\gui\AddRoom.java

?????文件???????3908??2011-02-21?14:25??jiudain\src\com\lll\gui\DingPane.java

?????文件???????5078??2011-02-20?21:38??jiudain\src\com\lll\gui\Login.java

?????文件???????3115??2011-02-20?14:09??jiudain\src\com\lll\gui\MadePane.java

?????文件???????5969??2011-02-20?18:00??jiudain\src\com\lll\gui\Maderoom.java

?????文件???????9440??2011-02-20?19:42??jiudain\src\com\lll\gui\Mainframe.java

?????文件???????4478??2011-02-20?13:34??jiudain\src\com\lll\gui\PersonPane.java

?????文件???????3525??2011-02-20?18:00??jiudain\src\com\lll\gui\RemovePerson.java

?????文件???????3573??2011-02-20?18:01??jiudain\src\com\lll\gui\RemoveRoom.java

?????文件???????7419??2011-02-20?21:37??jiudain\src\com\lll\gui\RoomPane.java

?????文件???????5745??2011-02-20?18:02??jiudain\src\com\lll\gui\UpdatePassword.java

?????文件???????1781??2011-02-20?18:01??jiudain\src\com\lll\dao\Dao.java

?????文件???????1816??2011-02-21?14:25??jiudain\src\com\lll\dao\DingDao.java

?????文件???????1673??2011-02-20?18:02??jiudain\src\com\lll\dao\MoneyDao.java

?????文件???????2157??2011-02-19?17:01??jiudain\src\com\lll\dao\PersonDao.java

?????文件???????2611??2011-02-19?11:38??jiudain\src\com\lll\dao\Roomdao.java

?????文件?????231949??2011-02-14?17:43??jiudain\lib\sqljdbc.jar

?????文件????3145728??2011-02-20?19:33??jiudain\db\guesthouse.mdf

?????文件????1048576??2011-02-20?19:33??jiudain\db\guesthouse_log.ldf

?????文件?????227885??2011-02-16?17:53??jiudain\bin\image\as.jpg

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