struts2解決登陸問(wèn)題,struts解決分頁(yè)問(wèn)題,對(duì)mysql數(shù)據(jù)庫(kù)的增刪改查,配置文件的strutsxml的寫(xiě)法

1、我剛學(xué) struts2 的時(shí)候，遇到很多這方面的問(wèn)題。所以當(dāng)我會(huì)了我決定把他們分享下來(lái)jsp 頁(yè)面addnews.jsp 添加 all.jsp 信息顯示 a href=delete.action?id=刪除 a href=sid.action?id=更改該信息 分頁(yè)查詢 添加 fail.jsp insert title here fail 即將返回登陸頁(yè)面 in.jsp insert title here index.jsp insert title here 現(xiàn)實(shí)新聞 login.jsp 登陸頁(yè)面 用戶名： 密碼： login2-1.jsp insert title here ok.jsp

2、insert title here ok spage.jsp 分頁(yè)查詢顯示 a href=deleteman.action?id=刪除 a href=sidman.action?id=更改該信息 上一頁(yè) 下一頁(yè) 添加 updatenews.jsp 更新 編號(hào)為： 主體： 提交時(shí)間： 攥寫(xiě)人： 返回查詢頁(yè)面 實(shí)體 vo 包login.java package vo; public class login private string username; private string password; public string getusername() return username; pu

3、blic void setusername(string username) this.username = username; public string getpassword() return password; public void setpassword(string password) this.password = password; news.java package vo; public class news private int id; private int p; private string page; private string title; private s

4、tring body; private string addtime; private string addpeople; public int getp() return p; public void setp(int p) this.p = p; public string getpage() return page; public void setpage(string page) this.page = page; public int getid() return id; public void setid(int id) this.id = id; public string ge

5、ttitle() return title; public void settitle(string title) this.title = title; public string getbody() return body; public void setbody(string body) this.body = body; public string getaddtime() return addtime; public void setaddtime(string addtime) this.addtime = addtime; public string getaddpeople()

6、 return addpeople; public void setaddpeople(string addpeople) this.addpeople = addpeople; 連接數(shù)據(jù)庫(kù)dbcon.java package db; import java.sql.*; public class dbcon private connection conn = null; private statement stmt = null; private string dbdriver = com.mysql.jdbc.driver; private string dburl = jdbc:mysq

7、l:/localhost:3306/xx; private string dbuser = root; private string dbpass = dd; public dbcon() public connection getconnection() try class.forname(dbdriver); conn = drivermanager.getconnection(dburl, dbuser, dbpass); catch (classnotfoundexception e) / todo auto-generated catch block e.printstacktrac

8、e(); catch (sqlexception e) / todo auto-generated catch block e.printstacktrace(); return conn; public resultset do_query(string sql) resultset rs = null; conn = this.getconnection(); try stmt = conn.createstatement(); rs = stmt.executequery(sql); catch (sqlexception e) / todo auto-generated catch b

9、lock e.printstacktrace(); return rs; public int do_update(string sql) int res = 0; conn = this.getconnection(); try stmt = conn.createstatement(); res = stmt.executeupdate(sql); catch (sqlexception e) / todo auto-generated catch block e.printstacktrace(); return res; dao 包logindao.java package dao;

10、import java.util.arraylist; import java.util.list; import vo.login; import vo.news; import db.dbcon; public class logindao private dbcon db; private list result = new arraylist(); public logindao() db=new dbcon(); public list excute(string username,string password) string sql=select id,title from ne

11、ws where id=+username+ and title=+password+; return result; newsdao.java package dao; import java.sql.resultset; import java.sql.sqlexception; import java.util.arraylist; import java.util.list; import db.dbcon; import vo.news; public abstract class newsdao private dbcon db; private list result = new

12、 arraylist(); public newsdao() db = new dbcon(); public list spage(int pagesize,int nowpage) int count=0; int countpage; if(pagesize0&nowpage0) string sql0=select count(*) as pagecount from news; resultset rs0=db.do_query(sql0); try if(rs0.next() count=rs0.getint(pagecount); countpage=(count%pag

13、esize=0)?(count/pagesize):(count/pagesize+1); if(nowpagecountpage) nowpage=countpage; string sql=select * from news order by id limit +(nowpage*pagesize-pagesize)+,+pagesize; resultset rs=db.do_query(sql); try while(rs.next() news n = new news(); n.setid(rs.getint(id); n.settitle(rs.getstring(title)

14、; n.setbody(rs.getstring(body); n.setaddtime(rs.getstring(addtime); n.setaddpeople(rs.getstring(addpeople); result.add(n); catch (sqlexception e1) / todo auto-generated catch block e1.printstacktrace(); catch (sqlexception e) / todo auto-generated catch block e.printstacktrace(); return result; publ

15、ic list find_all() string sql = select * from news; resultset rs = db.do_query(sql); try while (rs.next() news n = new news(); n.setid(rs.getint(id); n.settitle(rs.getstring(title); n.setbody(rs.getstring(body); n.setaddtime(rs.getstring(addtime); n.setaddpeople(rs.getstring(addpeople); result.add(n

16、); catch (sqlexception e) / todo auto-generated catch block e.printstacktrace(); return result; public list sid(int id) / 通過(guò)主鍵查詢以更新string sql = select * from news where id= + id; system.out.println( 通過(guò)主鍵查詢id 為+id+ 的記錄 ); resultset rs = db.do_query(sql); try while (rs.next() news n = new news(); n.se

17、tid(rs.getint(id); n.settitle(rs.getstring(title); n.setbody(rs.getstring(body); n.setaddtime(rs.getstring(addtime); n.setaddpeople(rs.getstring(addpeople); result.add(n); catch (sqlexception e) / todo auto-generated catch block e.printstacktrace(); return result; public int delete(int id) int res =

18、 0; string sql = delete from news where id= + id; res = db.do_update(sql); system.out.print( 已經(jīng)刪除id 為+id+ 的記錄 ); return res; public int insert(news news) int res = 0; string sql = insert into news (id,title,body,addtime,addpeople) values (+ news.getid()+ ,+ news.gettitle() + ,+ news.getbody()+ ,+ ne

19、ws.getaddtime()+ ,+ news.getaddpeople() + ); res = db.do_update(sql); system.out.print(sql); return res; public int updatenews(news news) int res = 0; string sql =update news set title=+news.gettitle()+,body= +news.getbody()+,addtime=+news.getaddtime() +,addpeople=+news.getaddpeople()+where id=+news

20、.getid(); system.out.print(sql); res = db.do_update(sql); return res; action 類newsaction.java package action; import java.util.arraylist; import java.util.list; import com.opensymphony.xwork2.actionsupport; import vo.news; import dao.newsdao; public class newsaction extends actionsupport /* * */ pri

21、vate static final long serialversionuid = 1l; news news; private int id; private int nowpage=1; private int pagesize=5; private string uploadfile; public string getuploadfile() return uploadfile; public void setuploadfile(string uploadfile) this.uploadfile = uploadfile; public news getnews() return

22、news; public int getnowpage() return nowpage; public void setnowpage(int nowpage) this.nowpage = nowpage; public int getpagesize() return pagesize; public void setpagesize(int pagesize) this.pagesize = pagesize; public void setnews(news news) this.news = news; newsdao newsdao = new newsdao() ; priva

23、te list result = new arraylist(); public list getresult() return result; public void setresult(list result) this.result = result; public int getid() return id; public void setid(int id) this.id = id; public string find_all() result = newsdao.find_all(); return find_all; public string delete() newsdao.delete(id); system.out.print(id); return delete; public string insert() throws exception newsdao.insert(news); return insertall; public string updatenews() int res=newsdao.updatenews(news); if(res0) return su; else return fail; public string sid() result = n