web实验报告-站点设计

1、广州大学学生实验stmt = null; rs = null;开课学院及：计算机科学与工程4182013年5 月 18 日tryClass.forName(.gjt.mm.Driver);(*只能为文字和,老师评语将添加到此处,学生作答*)dbcon= DriverManager.getConnection(url,userName,usassword);一、实验目的应用和掌握所学到的 Web 技术二、实验内容设计一个 Web 站点，要求综合运用本课程学到的全部知识三、实验原理catch(SQLException ex)System.out.prln(ex.toString();catch(C

2、laJsp 语言 Java四、实验设备 Java jdk +eclipse五、实验要求六、实验程序主要程序CSSotFoundException ex)tomcat6.0System.out.prln(ex.toString();package com.liuyan;importjava.sql.*;publictryexeSql(String strSql)publicclass dbstmt=dbcon.createSement();StringuserName=root;stmt.executeUpdate(strSql);return true;Stringusassword=1234

3、56;catch(Exception ex)String url=jdbc:=gb2312;:/localhost:3306/ch11?useUnicode=true&characterEncodingSystem.out.prreturn false;ln(ex.toString();Connectiondbcon;Sement stmt;public ResultSet exeSqlQuery(String strSql)tryResultSet rs;public db()学院计算机科学与教育学院年级/专业/班软工104学号1006100012实验课程名称Web 应用技术成绩实验项目名称

4、Web 站点设计指导老师strSql=strSql + Us strSql=strSql + ) ;assword;stmt=dbcon.createSement();rs =stmt.executeQuery(strSql);strSql=strSql + values(; strSql=strSql + + UserName + ,;catch(Exceptionex)strSql=strSql + + Us strSql=strSql + );assword + ;isAdd = super.exeSql(strSql); return isAdd;System.out.pr rs =

5、null;ln(ex.toString();returnrs;publicis_exist()/users.java package com.liuyan; import java.util.*; import java.sql.*; import java.text.*;strSql=select * from users where UserName = +UserName+; ResultSet rs = null;isExist = false;tryrs = super.exeSqlQuery(strSql); while(rs.next()isExist = true;catch(

6、Exception ex)public clasers extends dbprivateUserID;private String UserName;private String Usassword;System.out.prln(ex.toString();private String strSql;return isExist;public users()UserID=0; UserName=;publicuser_valid()Usassword=;strSql=select * from users where; strSql=strSql + UserName = +UserNam

7、e+;strSql=;strSql=strSql + and Us ResultSet rs = null;isValid = false;tryassword = +Usassword+;publicadd_user()strSql=inserto users ;rs = super.exeSqlQuery(strSql); while(rs.next()strSql=strSql + (; strSql=strSql + UserName,;this.UserID = rs.get isValid = true;(UserID);publicgetUserID()catch(Excepti

8、on ex)System.out.prreturn isValid;return this.UserID;ln(ex.toString();public void setUserName(String UserName)this.UserName = UserName;publicinit()public String getUserName()return this.UserName;strSql=select * from users where UserID=; strSql=strSql +UserID;tryResultSet rs = super.exeSqlQuery(strSq

9、l); if (rs.next()public void setUsassword(String Usassword)this.Usassword = Usassword;this.UserID=rs.get(UserID);this.UserName=rs.getString(UserName);public String getUsreturn this.Usassword()this.Usassword=rs.getString(Usassword);assword;return true;elsereturn false;/words.java package com.liuyan;

10、import java.util.*; import java.sql.*; import java.text.*;public class words extends dbcatch(Exception ex)System.out.pr return false;ln(ex.toString();privateWordsID;private String WordsTitle; private String WordsContent; private String WordsTime;public void setUserID(UserID)privateUserID;this.UserID

11、 = UserID;private String strSql;private SimpleDateFormat timeFormatter;publicinit()strSql=select * from words where WordsID=; strSql=strSql + WordsID;tryResultSet rs = super.exeSqlQuery(strSql); if (rs.next()public words()WordsID=0; WordsTitle=; WordsContent=; UserID=0;timeFormatter = new SimpleDate

12、Format(yyyy-MM-dd hh:mm:ss); WordsTime=timeFormatter.format(new java.util.Date();strSql=;this.WordsID=rs.get(WordsID);this.WordsTitle=rs.getString(WordsTitle); this.WordsContent=rs.getString(WordsContent); this.WordsTime=rs.getString(WordsTime);publicadd_words()this.UserID=rs.get return true;(UserID

13、);elsereturn false;strSql=inserto words ;strSql=strSql + (; strSql=strSql + WordsTitle,;strSql=strSql + WordsContent,; strSql=strSql + WordsTime,; strSql=strSql + UserID; strSql=strSql + ) ;strSql=strSql + values(;catch(Exception ex)System.out.pr return false;ln(ex.toString();strSql=strSql + + Words

14、Title + ,; strSql=strSql + + WordsContent + ,; strSql=strSql + + WordsTime + ,; strSql=strSql + + UserID + ; strSql=strSql + );isAdd = super.exeSql(strSql); return isAdd;public ResultSet show_all_words()strSql=select * from words; ResultSet rs = null;trypublicdelete_words()rs = super.exeSqlQuery(str

15、Sql);strSql = delete from words where WordsID=+WordsID; isDelete = super.exeSql(strSql);return isDelete;catch(Exception ex)System.out.prln(ex.toString();return rs;public void setUserID(UserID)public void setWordsID(WordsID)this.UserID = UserID;this.WordsID = WordsID;publicgetUserID()publicgetWordsID

16、()return this.UserID;return this.WordsID;创建数据库CREATE TABLE users (public void setWordsTitle(String WordsTitle)this.WordsTitle = WordsTitle;UserID big(20) NOT NULL auto_increment,UserName varchar(20) default NULL,Usassword varchar(20) default NULL,PRIMARY KEY (UserID) ;CREATE TABLE words (public Stri

17、ng getWordsTitle()return this.WordsTitle;WordsID big(20) NOT NULL auto_increment,WordsTitle varchar(100) default NULL, WordsContent text,WordsTime datetime default 0000-00-00 00:00:00,public void setWordsContent(String WordsContent)this.WordsContent = WordsContent;UserID big(20) NOT NULL default 0,PRIMARY KEY(WordsID) ;七、总结心得主界面public String