【正文】 hits))。((intime))。(ne)。}(st, rs, conn)。} catch (SQLException e) {()。}return list。}//，更新新聞信息public boolean updateNew(Newsinfo ne){boolean flag = false。String sql = update newsinfo set newcla = ?, title = ?, author = ?, content = ?, intime = ? where id = ?。Connection conn = ()。try {PreparedStatement pst = (sql)。(1, ())。(2,())。(3, ())。(4,())。(5, ())。(6, ())。int id = ()。(pst, rs, conn)。31 / 41if(id0){flag = true。}} catch (SQLException e) {()。}return flag。}//，刪除新聞public int deleteNew(int id){int i = 0 。String sql = delete from newsinfo where id = ?。Connection conn = ()。try {PreparedStatement st = (sql)。(1, id)。i = ()。(st, rs, conn)。} catch (SQLException e) {()。}return i。}// ID 查詢單個新聞。public ListNewsinfo selectone(int id){Newsinfo ne = null。32 / 41ListNewsinfo list = new ArrayListNewsinfo()。String sql = select * from newsinfo where id=+id。Connection conn = ()。try {Statement st = ()。ResultSet rs = (sql)。while(()){ne = new Newsinfo()。((id))。((newcla))。((title))。((author))。((content))。((hits))。((intime))。(ne)。}(st, rs, conn)。} catch (SQLException e) {()。}return list。}//public ListNewsinfo selectAll(){Newsinfo ne =null。ListNewsinfo list = new ArrayListNewsinfo()。String sql=select * from newsinfo order by intime desc。Connection conn = ()。Statement st。33 / 41try {st = ()。ResultSet rs = (sql)。while(()){ne = new Newsinfo()。((id))。((newcla))。((title))。((author))。((content))。((hits))。((intime))。(ne)。}} catch (SQLException e) {()。}return list。}//、查詢多少條新聞public ListNewsinfo selectBySS(int newcla,int s){Newsinfo ne = null。ListNewsinfo list = new ArrayListNewsinfo()。String sql = select * from newsinfo where newcla=+newcla+ order by intime asc limit 0,+s。(sql)。Connection conn = ()。try {Statement st = ()。34 / 41ResultSet rs = (sql)。while(()){ne = new Newsinfo()。((id))。((newcla))。((title))。((author))。((content))。((hits))。((intime))。(ne)。}(st, rs, conn)。} catch (SQLException e) {()。}return list。}//public ListNewsinfo selecthits(int s){Newsinfo ne = null。ListNewsinfo list = new ArrayListNewsinfo()。String sql = select * from newsinfo order by hits desc limit 0,+s。(sql)。Connection conn = ()。try {Statement st = ()。ResultSet rs = (sql)。while(()){ne = new Newsinfo()。35 / 41((id))。((newcla))。((title))。((author))。((content))。((hits))。((intime))。(ne)。}(st, rs, conn)。} catch (SQLException e) {()。}return list。}//public ListNewsinfo selectNew(int s){Newsinfo ne =null。ListNewsinfo list = new ArrayListNewsinfo()。String sql=select * from newsinfo order by intime desc limit 0,+s。Connection conn = ()。Statement st。try {st = ()。ResultSet rs = (sql)。while(()){ne = new Newsinfo()。((id))。((newcla))。((title))。36 / 41((author))。((content))。((hits))。((intime))。(ne)。}} catch (SQLException e) {()。}return list。}//public void addHits(int id,int hit){String sql=update newsinfo set hits=+hit+ where id=+id。Connection conn = ()。try {Statement st=()。(sql)。(st, rs, conn)。} catch (SQLException e) {()。}}//public ListNewsinfo selectByLike(String s){Newsinfo ne =null。ListNewsinfo list = new ArrayListNewsinfo()。String sql=select * from newsinfo where title like 39。%+s+%39。Connection conn = ()。37 / 41Statement st。try {st = (,)。ResultSet rs = (sql)。while(()){ne = new Newsinfo()。((id))。((newcla))。((title))。((author))。((content))。((hits))。((intime))。(ne)。}} catch (SQLException e) {()。}return list。}}:package 。import 。import 。38 / 41import 。import 。import 。import 。import 。import 。import 。public class NewclaJdbc {ResultSet rs=null。//查詢所有新聞分類public ListNewcla selcetFenlei(){Newcla cla= null。ListNewcla list = new ArrayListNewcla()。Connection conn = ()。String sql=select * from newcla。try {Statement st= ()。ResultSet rs = (sql)。while(()){cla = new Newcla()。((newcla_id))。((newcla))。(cla)。}(st, rs, conn)。} catch (SQLException e) {()。}39 / 41return list。}//根據(jù) ID 刪除新聞分類public int deletecla(int id){int i = 0 。String sql = delete from newcla where newcla_id = ?。Connection conn = ()。try {PreparedStatement st = (sql)。(1, id)。i = ()。(st, rs, conn)。} catch (SQLException e) {()。}return i。}//添加新聞分類public boolean insertcla(Newcla cla){Connection conn = ()。boolean flag = false。String sql=insert into newcla(newcla) values(39。+()+39。)。(sql)。try {Statement st = ()。int i = (sql)。(st, rs, conn)。40 / 41if(i0)flag = true。} catch (SQLException e) {()。}return flag。}//根據(jù) ID 查詢新聞分類public ListNewcla selcetById(int id){Newcla cla= null。ListNewcla list = new ArrayListNewcla()。Connection conn = ()。String sql=select * from newcla where newcla_id=+id。try {Statement st= ()。ResultSet rs = (sql)。while(()){cla = new Newcla()。((newcla_id))。((newcla))。(cla)。}(st, rs, conn)。} catch (SQLException e) {()。}return list。}41 / 41//更新新聞分類public boolean updateUserById(Newcla cla){boolean flag = false。String sql = update newcla set newcla = ? where newcla_id = ?。Connection conn = ()。try {PreparedStatement pst = (sql)。(1, ())。(2, ())。int id = ()。(pst, rs, conn)。if(id0){flag = true。}} catch (SQLException e) {()。}return flag。}}