//JDBC_BBS.java
import?java.sql.*;

public?class?JDBC_BBS?{
	public?static?void?main（String[]?args）?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;//?注冊MySQL?的驅動
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
		//?先定義變量，后使用和關閉
		Connection?conn?=?null;//?數據庫連接
		Statement?stmt?=?null;//?數據庫表達式
		ResultSet?rs?=?null;//?結果集
		try?{
			//?獲取數據庫的連接
			conn?=?java.sql.DriverManager
					.getConnection（
							“jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK“
							“root“?“root“）;
			//?root是用戶名，密碼為root編碼為GBK
			//?獲取表達式
			stmt?=?conn.createStatement（）;
			stmt.executeUpdate（“drop?table?student“）;//?刪除表student
			stmt.executeUpdate（“drop?table?discuss“）;//?刪除表discuss
			stmt.executeUpdate（“drop?table?reply“）;//?刪除表reply
			//?創建表student
			stmt
					.executeUpdate（“create?table?student（id?int?not?null?auto_increment“
							+?“username?varchar（20）??unique“
							+?“password?varchar（20）?not?null“
							+?“sex?varchar（8）?not?null“
							+?“age?varchar（4）?“
							+?“birth?varchar（20）?not?null“
							+?“telephone?varchar（12）“
							+?“email?varchar（40）?not?null“
							+?“primary?key?（id））“）;
			//?創建表discuss
			stmt.executeUpdate（“create?table?discuss（name?char（20）?not?null“
					+?“email?char（40）?not?null“?+?“subject?char（60）?not?null“
					+?“content?text?not?null“?+?“time?char（40）“
					+?“username?char（20）“
					+?“id?int?not?null?auto_incrementprimary?key?（id））“）;
			//?創建表reply
			stmt.executeUpdate（“create?table?reply（name?char（20）?not?null“
					+?“content?text?not?null“?+?“time?char（40）reply?int“
					+?“id?int?not?null?auto_increment“?+?“primary?key?（id））“）;
			stmt
					.executeUpdate（“insert?into?discuss（nameemailsubjectcontenttimeusername）?values（‘FrogKing‘?‘menghuan277717@163.com‘‘Test‘‘The?first?input?data!‘‘2009年4月18日18：30：30‘‘FrogKing‘）“）;
			//?執行插入數據的?SQL
			stmt
					.executeUpdate（“insert?into?Student（usernamepasswordsexagebirthtelephoneemail）?values（‘Tome‘?‘1234‘‘男‘20‘‘‘13820991219‘‘menghuan277717@163.com‘）“）;
			stmt
					.executeUpdate（“insert?into?Student（usernamepasswordsexagebirthtelephoneemail）?values（‘Bell‘?‘1234‘‘男‘20‘‘‘13820991219‘‘menghuan277717@163.com‘）“）;
			stmt
					.executeUpdate（“insert?into?Student（usernamepasswordsexagebirthtelephoneemail）?values（‘Jack‘?‘1234‘‘男‘20‘‘‘13820991219‘‘menghuan277717@163.com‘）“）;
			stmt
					.executeUpdate（“insert?into?Student（usernamepasswordsexagebirthtelephoneemail）?values（‘FrogKing‘?‘123456‘‘男‘20‘‘‘13820991219‘‘menghuan277717@163.com‘）“）;

		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{//?釋放資源
//			try?{
//				rs.close（）;
//			}?catch?（SQLException?e）?{
//			}
			try?{
				stmt.close（）;
			}?catch?（SQLException?e）?{
			}
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
			}
		}
	}
}

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

?????文件???????1413??2009-07-04?14:22??附件程序\BBSTalk\.project

?????文件????????300??2009-07-04?14:22??附件程序\BBSTalk\.mymetadata

?????文件????????533??2009-05-11?14:11??附件程序\BBSTalk\.classpath

?????文件???????1569??2009-05-26?22:33??附件程序\BBSTalk\WebRoot\login.html

?????文件???????4406??2009-05-26?23:26??附件程序\BBSTalk\WebRoot\discuss.jsp

?????文件???????4927??2009-05-20?02:51??附件程序\BBSTalk\WebRoot\detail.jsp

?????文件???????1295??2009-07-04?16:26??附件程序\BBSTalk\WebRoot\opendata.jsp

?????文件???????1009??2009-05-19?16:16??附件程序\BBSTalk\WebRoot\convert.jsp

?????文件???????7118??2009-05-20?03:32??附件程序\BBSTalk\WebRoot\register.jsp

?????文件???????2421??2009-05-20?03:38??附件程序\BBSTalk\WebRoot\saveregister.jsp

?????文件????????970??2009-05-19?13:39??附件程序\BBSTalk\WebRoot\MainForm.jsp

?????文件???????1206??2009-05-19?13:41??附件程序\BBSTalk\WebRoot\person.jsp

?????文件???????2065??2009-05-20?03:58??附件程序\BBSTalk\WebRoot\delete.jsp

?????文件???????2225??2009-05-20?03:25??附件程序\BBSTalk\WebRoot\saveNewtitle.jsp

?????文件???????2533??2009-05-19?13:39??附件程序\BBSTalk\WebRoot\newtitle.jsp

?????文件???????3175??2009-05-20?03:41??附件程序\BBSTalk\WebRoot\getPassword.jsp

?????文件???????1791??2009-05-20?02:11??附件程序\BBSTalk\WebRoot\enter.jsp

?????文件???????2005??2009-05-20?03:12??附件程序\BBSTalk\WebRoot\saveRevert.jsp

?????文件??????57018??2009-03-29?21:21??附件程序\BBSTalk\WebRoot\Pictures\111.jpg

?????文件??????40644??2009-04-05?17:13??附件程序\BBSTalk\WebRoot\Pictures\MainJPG.jpg

?????文件???????2093??2009-05-05?17:29??附件程序\BBSTalk\WebRoot\Pictures\BGBlue.jpg

?????文件??????74518??2009-05-19?10:13??附件程序\BBSTalk\WebRoot\Pictures\head.bmp

?????文件???????5386??2009-05-19?10:42??附件程序\BBSTalk\WebRoot\Pictures\delete.bmp

?????文件??????36724??2009-05-26?22:33??附件程序\BBSTalk\WebRoot\Pictures\001.jpg

?????文件??????22965??2009-05-26?23:25??附件程序\BBSTalk\WebRoot\Pictures\discuss.jpg

?????文件?????????39??2009-03-18?00:49??附件程序\BBSTalk\WebRoot\meta-INF\MANIFEST.MF

?????文件????????392??2009-05-19?22:47??附件程序\BBSTalk\WebRoot\WEB-INF\web.xml

?????文件???????3089??2009-07-04?16:16??附件程序\BBSTalk\WebRoot\WEB-INF\classes\JDBC_BBS.class

?????文件?????493105??2009-03-18?09:56??附件程序\BBSTalk\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.3-bin.jar

?????文件???????3027??2009-07-04?16:16??附件程序\BBSTalk\src\JDBC_BBS.java

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