【正文】 sgetString adminname font size 3color black 回復(fù)時(shí)間 outprintln rsgetString admintime p align center font size 4color blue if sessiongetAttribute loginname null a href mentsjsp 我也要評論 catch Exception e outprintln wrong 用戶發(fā)表評論頁面 其主要實(shí)現(xiàn)代碼為 String ments new String requestgetParameter ments getBytes iso88591 utf8 date new String driver sqlserverSQLServerDriver String url jdbcmicrosoftsqlserverlocalhost1433DatabaseName province String uname sa String upass sa String sql insert into userment cmentsctimecuser values mentsdatesessiongetAttribute loginname try lassforName driver onnection conn DriverManagergetConnection urlunameupass tatement stmt conncreateStatement tmtexecuteUpdate sql jspforwardpage usermentdownjsp jspforward catch Exception e outprintln wrong 戶登錄 公交登錄模塊用戶進(jìn)入系統(tǒng)后點(diǎn)擊頂部導(dǎo)航條中的登錄在公交登錄頁面中填寫曾注冊的用戶名跟密碼若填寫正確則從新進(jìn)入公交登錄主頁面此時(shí)可以在評論頁面中進(jìn)行評論 點(diǎn)擊網(wǎng)頁頂部導(dǎo)航內(nèi)的登錄進(jìn)入公交登錄頁面頁面內(nèi)容如下圖 用戶登錄頁面 其主要實(shí)現(xiàn)代碼如下 String a new String requestgetParameter username getBytes iso88591 utf8 sessionsetAttribute loginnamea String b requestgetParameter password String driver sqlserverSQLServerDriver String url jdbcmicrosoftsqlserverlocalhost1433DatabaseName province String username sa String password sa Connection conn null Statement stmt null ResultSet rs null try ClassforName driver conn DriverManagergetConnection urlusernamepassword stmt conncreateStatement rs stmtexecuteQuery select from register where username a and password b while rsnext int length rsgetRow if length 1 responsesendRedirect firstpagejsp else jspforward page errorhtml jspforward catch Exception e outprintln 失敗 String account new Sring requestgetParameter account getBytes iso88591 utf8 String sex new String requestgetParameter sex getBytes iso88591 utf8 String provincename new String requestgetParameter provincename getBytes iso88591 utf8 String cityname new String requestgetParameter cityname getBytes iso88591 utf8 String year requestgetParameter year String mounth requestgetParameter mounth String dayday requestgetParameter dayday String password requestgetParameter password String driver sqlserverSQLServerDriver String url jdbcmicrosoftsqlserver11433DatabaseName province String uname sa String pword sa String sql insert into register usernamebirthdaysexpasswordprovincenamecityname values accountyearmounthdaydaysexpasswordprovincenamecityname try ClassforName driver Connection conn DriverManagergetConnection urlunamepword Statement stmt conncreateStatement outprintln 正在向網(wǎng)絡(luò)上注冊您的基本信息 stmtexecuteUpdate sql for int i 0i 1000099i responsesendRedirect logindownjsp catch Exception e outprintln 失敗 eprintStackTrace 管理員管理窗口 登錄窗口 管理員登錄窗口管理員要想進(jìn)入系統(tǒng)首先需要登錄填寫管理員的名稱跟密碼以及管理員的級別不同級別進(jìn)入的窗口是不同的 進(jìn)入登錄窗口窗口內(nèi)容如下圖 管理員登錄窗口 其窗口實(shí) 現(xiàn)代碼如下 String aname apass String aclass aname ext apass thisadminpasswordgetText aclass String electedItem Sytln aclass try Connection conn null ClassforName JdbcOdbcDriver conn DriverManagergetConnection jdbcodbcprovince sa sa Statement s conncreateStatement ResultSet rs sexecuteQuery select from adminregister where adminname aname and adminpass apass and adminclass aclass if aclass 高級管理員 rsnext Sytln rsgetString adminclass Sytln 發(fā)現(xiàn) 1 login login new login loginsetVisible false first first new first firstsetVisible true else if aclass 普通管理員 rsnext Sytln rsgetString adminclass Sytln 發(fā)現(xiàn) 1 login login new login loginsetVisible false normalfirst nf new normalfirst nfsetVisible true else thissetTitle 您的輸入有誤請查證 catch Exception e thissetTitle 運(yùn)行錯誤 管理員注冊窗口 其窗口實(shí)現(xiàn)代碼如下 String sex if thisadminfemaleisSelected sex 男 else sex 女 String adminnameadminidadminpass2adminpass1adminclass adminname ext adminpass2 thisadminpassword2getText adminpass1 thisadminpasswordgetText adminclass String electedItem if adminname adminpass1 adminpass2 adminpass1equals adminpass2 try Sytln adminname Sytln adminpass1 Sytln adminpass2 Sytln adminpass1equals adminpass2 Connection conn null ClassforName JdbcOdbcDriver conn DriverManagergetConnection jdbcodbcprovince sa sa Statement s conncreateStatement Sytln 成功 sexecuteUpdate insert into adminregister adminnameadminclassadminsexadminpass values ext electedItem sexthisadminpasswordgetText Sytln 成功 thissetTitle 您的注冊完成 first f new first fsetVisible true thissetVisible false catch Exception e thissetTitle 運(yùn)行錯誤 else thissetTitle 填寫的內(nèi)容有誤請重新檢查 修改窗口 管理員修改窗口用來修改原來注冊過的管理