package?youceo;

import?java.sql.*;

public?class?AccessDB?{
	Connection?conn;
	String?url?=?“jdbc:mysql://localhost:3306/etalk?user=root&password=root“;
	//添加用戶
	public?boolean?addUser（String?username?String?password）{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;			
			conn?=?DriverManager.getConnection（url）;
			PreparedStatement?pst?=?conn.prepareStatement（“select?count（*）?from?user?where?username=?“）;
			pst.setString（1?username）;
			ResultSet?rs?=?pst.executeQuery（）;
			if（rs?!=?null）?{
				return?false;
			}
			pst?=?conn.prepareStatement（“insert?into?user（usernamepasswd）?values（??）“）;
			pst.setString（1?username）;
			pst.setString（2?password）;
			pst.executeUpdate（）;
			if（pst?!=?null）?{
				pst.close（）;
				pst?=?null;
			}
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			if（conn?!=?null）?{
				try?{
					conn.close（）;
					conn?=?null;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
		}
		return?true;
	}
	//修改用戶密碼
	public?boolean?editUser（String?username?String?password1?String?password2）?{
		if?（!readUser（usernamepassword1））?return?false;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;			
			conn?=?DriverManager.getConnection（url）;
			PreparedStatement?pst?=?conn.prepareStatement（“update?user?set?passwd=??where?username=?“）;
			pst.setString（1?password2）;
			pst.setString（2?username）;
			if（pst.executeUpdate（）?!=?0）?return?true;
			if（pst?!=?null）?{
				pst.close（）;
				pst?=?null;
			}
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			if（conn?!=?null）?{
				try?{
					conn.close（）;
					conn?=?null;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
		}
		return?false;
	}?
	//更改用戶頭像
	public?void?editUser（String?username?String?photo）?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;			
			conn?=?DriverManager.getConnection（url）;
			PreparedStatement?pst?=?conn.prepareStatement（“update?user?set?photo=??where?username=?“）;
			pst.setString（1?photo）;
			pst.setString（2?username）;
			pst.executeUpdate（）;
			if（pst?!=?null）?{
				pst.close（）;
				pst?=?null;
			}
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			if（conn?!=?null）?{
				try?{
					conn.close（）;
					conn?=?null;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
		}
	}
	//用戶登錄時驗證用戶有效性
	public?boolean?readUser（String?username?String?password）?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			conn?=?DriverManager.getConnection（url）;
			PreparedStatement?pst?=?conn.prepareStatement（“select?*?from?user?where?username=?“）;
			pst.setString（1?username）;
			ResultSet?rs?=?pst.executeQuery（）;
			if（rs.next（））{
				if（password.equals（rs.getString（

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

?????文件????????414??2010-06-03?21:01??etalk\.classpath

?????文件????????288??2010-06-03?21:01??etalk\.mymetadata

?????文件???????1223??2010-06-03?21:01??etalk\.project

?????文件???????9215??2010-06-03?21:01??etalk\src\youceo\AccessDB.java

?????文件???????1664??2010-06-03?21:01??etalk\src\youceo\CommentServlet.java

?????文件???????1272??2010-06-03?21:01??etalk\src\youceo\Doc.java

?????文件???????1864??2010-06-03?21:01??etalk\src\youceo\DownloadServlet.java

?????文件???????1249??2010-06-03?21:01??etalk\src\youceo\EditServlet.java

?????文件???????1312??2010-06-03?21:01??etalk\src\youceo\EditUser.java

?????文件???????1653??2010-06-03?21:01??etalk\src\youceo\LoginServlet.java

?????文件???????2198??2010-06-03?21:01??etalk\src\youceo\PhotoServlet.java

?????文件???????1026??2010-06-03?21:01??etalk\src\youceo\SearchServlet.java

?????文件???????5133??2010-06-03?21:01??etalk\src\youceo\SelectServlet.java

?????文件???????4247??2010-06-03?21:01??etalk\src\youceo\UploadServlet.java

?????文件????????604??2009-06-11?13:22??etalk\WebRoot\bg.gif

?????文件???????1159??2008-11-23?18:47??etalk\WebRoot\ca_hz_002.gif

?????文件???????2755??2010-06-03?21:01??etalk\WebRoot\change.jsp

?????文件?????????92??2010-05-20?21:37??etalk\WebRoot\chart_top.gif

?????文件???????1586??2010-06-03?21:01??etalk\WebRoot\check.jsp

?????文件???????3805??2010-06-01?19:49??etalk\WebRoot\css.css

?????文件????????510??2010-06-03?21:01??etalk\WebRoot\delete.jsp

?????文件???????8717??2010-06-03?21:01??etalk\WebRoot\detail.jsp

?????文件???????6356??2010-06-03?21:01??etalk\WebRoot\edit.jsp

?????文件???????3445??2010-06-03?21:01??etalk\WebRoot\editUser.jsp

?????文件?????132261??2010-05-18?12:05??etalk\WebRoot\etalk.jpg

?????文件???????2629??2010-05-28?17:30??etalk\WebRoot\head.css

?????文件????????143??2010-05-23?00:51??etalk\WebRoot\head.js

?????文件???????8116??2010-06-03?21:01??etalk\WebRoot\hotBook.jsp

?????文件???????2324??2010-06-03?21:01??etalk\WebRoot\image.jsp

?????文件??????14131??2010-05-09?15:30??etalk\WebRoot\img\default.jpg

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