TA的每日心情 衰 2021-2-2 11:21
签到天数: 36 天
[LV.5]常住居民I
package s2.jsp.zhangxiao.dao;( ?/ q Q: k& a
/**9 u! h( r4 E* d# l! T% o% r6 l3 d
* 实体类
: X- U" J, Q! Q( ~& F- W# R * @author Administrator
1 T4 x1 G* I/ X" C* X; B" _ *4 V4 R3 ~0 S4 U& G6 d
*/
# J9 y! O/ W6 e1 l* f& `3 F public class News {
0 G9 G0 I o) [* \& C, ^ // id, title, content, pubtime, author
- J& o& j0 L! [$ p. p private int id;. @. \! r; n$ c! D t3 z
private String title;/ E4 a( f) V3 |; s- J
private String content;
5 N( {0 J; K1 \& e' T/ Z private String pubtime;6 l, n: z& i' N4 Z1 h/ b
private String author;
6 F& h/ k2 b( y* z& x$ s /**, @- T' ^# P! o+ }3 _4 |
* 构造函数
3 y4 C2 B2 r8 x9 ~ * @param author 作者! T' o' J. _6 C8 m$ k
* @param content 内容
$ Y& ?: x' C o+ f * @param id 序号. a: \4 @. k- ~6 v; X# a6 X) y
* @param pubtime 发布时间
% ~' ]. }0 @. R0 y * @param title 标题
y* g' ]% B8 | */
$ P8 D- n' w* y; g% X public News( int id,String title,String content, String pubtime,String author) {5 O0 F2 }0 w% h5 `+ V* i
0 n ~- J; K. M! Q4 Y; F; T this.author = author;9 b. b. G! ^0 b6 b0 c' T H+ o
this.content = content;
3 }2 p! P. S, T9 O% D8 k# ^ this.id = id;2 N+ V' _( l( u
this.pubtime = pubtime;
: J. Q7 u9 v9 s* X+ ` this.title = title;1 D* F) G* z1 ^: p. I
}
: B9 u( h( K, w' P7 z3 l /**& |9 a. Z8 u# u3 w, S& @9 G! T
* 无参构造函数9 Y9 W3 C2 G4 f- a) b9 Q
*/6 ~9 `3 ^3 f. _0 L; `' E0 B4 n P
public News() {
! d6 w& u0 L0 A0 V+ P( z super();9 t/ E1 m K- Q1 W2 K2 d
}
, n2 _4 o: f$ Q4 b; U /**( v! L3 k3 I1 U2 |' r+ v* J
* get ,set
2 k7 \# c0 |1 p) G * @return
& I* T R& C, S4 q */
6 \- q3 G7 r7 H; N8 H public int getId() {
2 x0 h8 ~* F% Z: }; l& [ return id;1 r5 m, X" q$ c! J
}
g6 h+ x$ K1 l9 W0 U( R( m1 A1 |& l public void setId(int id) {
, j9 p- H- k- Y. a- C this.id = id;! W5 Q) j7 c9 o! P# K' P- p2 P" V
}
3 S4 g, ~ S# x/ D public String getTitle() {* w. v' y6 H1 p8 B
return title;
3 k1 C) c2 i/ T$ j1 s }1 v: g0 v! C% y8 T
public void setTitle(String title) {
! [7 ?: I( z0 G2 ? this.title = title;* E! [) @( E+ O `% ]
}- K( O2 f$ v$ X. w# P- Q
public String getContent() {
& W( I% y* Z, I& Z' {4 K$ F- q return content;! q. W: W/ }& V0 Z T% J' {
}. I5 A% Z) A- Y" q1 o r; ?' k. R k
public void setContent(String content) {
) r. L* }" B& ]" @7 N5 h this.content = content;
5 o/ y1 k% \) k8 X7 {6 d) f }
/ P" B% f3 s+ L. a% _3 T2 F public String getPubtime() {1 _: P. C4 |9 R8 B, _8 p- Q# x
return pubtime;
3 G: X9 E- I5 b! L( _, b' W }2 x$ r2 k, \% I4 e- M
public void setPubtime(String pubtime) {
4 y# r$ P, ]" T. `9 d this.pubtime = pubtime;
# y: q) R* I0 f7 ^5 t }
! A) C, ?+ E/ |) ] public String getAuthor() {" l' `# ?% T; G9 K+ n4 W, P* s
return author;- D9 ~4 X' F" x6 N/ n# o* _
}
: \( _* i, F& ~4 G; p C, N* a+ L: k public void setAuthor(String author) {
' r) u: c* x' \) o: S this.author = author;' p t( E2 K: p. Y' w) J
}5 G# b( C4 a, I
& w: ]2 B: {+ K5 C$ N3 t# g7 z
}3 Y" W! g! W1 l' k( i( y' `
复制代码 package s2.jsp.zhangxiao.entity;/ _+ C" M0 a; s, N( L4 p) c w& r4 V
import java .sql.PreparedStatement;# x; I7 [2 r% V. M8 [
import java.sql.DriverManager;; `9 x' i* H& q: q9 e. }
import java.sql.Connection;- o* |+ y( u1 p3 t
import java.sql.ResultSet;
8 Y- Z b; ]$ e import java.sql.SQLException;; s9 ?4 P. ^; p
1 {: Y+ c2 [3 r8 j1 j3 n: ^- W9 W import com.microsoft.sqlserver.jdbc.SQLServerDriver;9 v& i9 @5 N1 I6 k1 ]( j0 f/ l2 }
% n( L. B" a, M, ? public class NewsBase {
( e0 C7 k+ \% G/ B; ~. J& \
& |% j) y" P! M$ i0 D private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";7 S9 F6 M. ~) q6 O o9 r8 M
private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=news";. J* J. [6 _: X% B0 n+ d1 J; }" r; }
private static final String DBNAME="sa";8 V. y ]" N; a! T) g# L7 k% d
private static final String DBPASS="1234";# d; G# r6 l9 z+ E9 L' u; u$ c
, ? K6 F5 ]2 L$ [+ ? public Connection getConnection(){
! I; h, H/ n5 f+ p Connection con=null;2 t3 a4 `9 y/ n! N3 c% C% Q
try {1 l0 o! h# l. d* c5 R
Class.forName(DRIVER);
( j5 |) X4 A4 q# a' U con=DriverManager.getConnection(URL, DBNAME, DBPASS);
2 }2 U# G- \8 K( t, u3 U O& D } catch (ClassNotFoundException e) {+ _6 j/ Y- ?2 ~( Z! X
System.out.println("加载驱动异常");
7 B7 y4 Z! J* p! x: i! f e.printStackTrace();
6 I6 b: e. q+ @# O2 ]& r } catch (SQLException e) {
4 U: N3 d1 I" M" W0 D# a2 a2 x System.out.println("数据库连接异常");
# o. F: S _' Y4 U e.printStackTrace();
5 j3 D5 o+ W9 c1 q8 ^( H }
) J: z4 E4 u" d return con;
7 |- i' X5 C0 B8 F* }+ g }
0 V1 m' Y+ a4 T 7 ^7 K6 F! k, P/ W1 J! D# V
public void colseAll(Connection con,PreparedStatement past,ResultSet rs){
g8 }, R" |) s7 j& [+ p' @ try {
8 e7 L6 ~( q. `/ [2 M rs.close();2 b* d! K; Q3 e9 N
} catch (SQLException e) {
2 ]+ z$ F- n5 O System.out.println("");
' d: Y; h2 n7 T% t" s( {6 P e.printStackTrace();
7 E* i: C4 G& l% T) W1 W8 u }
; o) t( ^' Z* P9 H" H9 B8 T. t try {) F" I9 X- ?8 s: ]
past.close();
8 F& R1 s6 k# e2 S! ~4 Q. d } catch (SQLException e) {
5 K$ ]6 a* N6 k. D7 Y System.out.println("");
/ I4 M% l" M+ p, D) J, H e.printStackTrace();
; X+ r# l, M1 V }
* [ r/ d2 Y3 _! E! _( T' V9 w' ?9 x try {
2 _& q# L$ E7 K0 g0 A! S! S7 @; `5 e con.close();
# D+ G7 U, m) T5 h" t } catch (SQLException e) {
; c) R% K( v! S Y) c // TODO Auto-generated catch block
: k% d9 v9 u$ V4 j3 M2 s e.printStackTrace();
: b& {7 d5 \5 L$ } }+ Y4 \6 y0 D: h- s/ q, q8 {
}6 V: z5 V' L6 ?) F3 H$ L9 |
0 c5 J+ a. U" [9 P3 C) D4 u& } public int update(String sql,String[] getValues){! w! G* W; ~0 s) v4 y j9 `6 _ b- o
int i=0;
: E C+ L- V. \" M Connection con=null;/ w- F$ j: G4 K. I2 d* y! M
PreparedStatement past=null;
7 b' S' u3 P" W; k4 S" t; ] con=getConnection();
9 }% p4 t* r" v try {
}" ~1 u) _- H8 f5 J past=con.prepareStatement(sql);- R" H& B2 d. f) m& j' a
if(getValues!=null){( v0 ~- X' O$ I, S5 |
for (int j = 0; j < getValues.length; j++) {
4 W6 E8 c! _1 i0 ^2 } past.setString(j+1, getValues[j]);# Z$ P1 [6 \% ^$ M3 p
}' {7 @, _" i! ^6 o8 }6 Z
}
+ y( C( n% h6 D0 E/ m1 p4 h" v7 M, T i=past.executeUpdate();
$ t& p$ O; W a; V; i- x } catch (SQLException e) {# j; |. {# h% ^* R! `
// TODO Auto-generated catch block9 G) k" i x1 E: l" ]7 t" Q+ z
e.printStackTrace();) _$ {* @; P2 ], [9 ?
}
: p/ u R! e# w! l, B return i;- L- a( B7 O0 X: ]
}
. r9 Y% w1 g' M6 B) u& ]" z/ {% c3 V }0 X u/ v4 q5 x% f
复制代码 package s2.jsp.zhangxiao.entity;
2 Q: B1 Y+ t$ A) n$ u: @
' ]( m7 M# \7 ]$ r6 }# d: d import java.sql.Connection;0 @3 n- j. x% M9 Z& R
import java.sql.PreparedStatement;! B1 _9 L' M6 b j
import java.sql.ResultSet;- p0 x8 C. {' \2 c0 L
import java.sql.SQLException;
4 j- H9 H3 x, X) D, I! f0 i import java.util.ArrayList;
/ f: y* v% t5 p1 G- W/ _ import java.util.List;$ t4 K9 Z4 O& d7 ~; J3 ` a
- }. y4 N0 r9 Q% c+ p
import s2.jsp.zhangxiao.dao.News;3 y( y2 W F) C* W4 I; F
0 g9 l, C( b4 W' b
public class NewsDao extends NewsBase {' u# |2 z) m r3 S* m& \ a
private int count =2;1 @5 y3 p' n" N# g6 h5 k! l
2 z/ Z" x C# Q5 R1 c5 M
/**
/ e0 j0 d1 Y$ O) h) ?, Q. e * 查询总页数: m+ |9 B# }# O- l1 \
* @return8 l1 G# P6 i0 e6 [7 O
*/, e4 O& F3 i( d( y) p
public int countPage(){- ~: L' k/ k' `0 }, V* o% C
int rows=0;+ \* u* J! `7 a7 X, w& V
Connection con=null;' z6 f# A* w5 R* x0 R0 l$ ~' T4 X5 ?- J
PreparedStatement past=null;
% M. |: d' ^5 { _% D8 m5 N ResultSet rs=null;8 u5 `6 @3 f1 m8 K0 N
con=getConnection();' Q) o$ J6 _$ R w
//查询所有的的页数 返回受影响的行数
" n0 o, x2 Q# f) ^6 h String sql="select count(*)as c from news";
' X% k+ F8 z# D try {- ~( `; N2 j; H7 f3 G1 M" M
past=con.prepareStatement(sql); ^, y1 u: _0 [/ Z5 I
rs=past.executeQuery();
1 D+ U/ D' h4 g2 u: ~ e if(rs.next()){) Y9 d2 C9 L8 D s* ~1 o
//将所有的行数保存到rows 变量里
F" i {2 v' w rows=rs.getInt("c");- R9 j I9 R9 {3 Y- A
//如果显示两页 count 代表显示的页数
! U# |5 d1 y' t if(rows%2==0){
: N. j9 n5 a/ l$ f$ E) R' ] rows=rows/count;8 C9 A* }% J6 ]$ H7 r
3 H' ^2 c- I* Y. o8 V' ?7 z* L2 D }else{
& |' ]: \2 R% v+ \ g rows=rows/count+1;- A8 v: ]6 y$ r* n& U
}6 T2 {; B5 J( N1 Y% s, k( A
}
: ]/ I% @9 r, ~* L } catch (SQLException e) {
' U: r% W5 I0 c# E1 Y) n, k0 \* Z System.out.println("查询总页数方法异常");8 c' z4 D& R2 D) F# f4 w# g
e.printStackTrace();
4 s0 {7 n% b; x* s+ n }
* Y3 v' w7 j/ f$ D) e: a& i) a& w# X( ? return rows;1 M1 E- b! q- k( o* P+ v7 ?
}
6 ]) b' j3 x/ J /**
2 C6 i S* r( _1 U * 根据id删除信息5 h8 Q! S. n8 G+ y. c
* @param id
$ Q. B) S. t; J! a" `% Y * @return
1 l+ T" W, Y" L */
2 l, C& u1 u# j5 i, \8 I3 w' y public int deleteNewsId(int id){
; e/ y$ Z9 R8 Q+ a String sql="delete news where id="+id;1 e; r8 w8 y' Z" A5 u$ S2 a
return update(sql,null);
) @5 A+ x0 w7 V w+ \ }4 ]% N+ Z2 i( M$ `1 U
/**& d7 Y6 [! U. y k
* 根据总页数分页
% R( ^6 |: x( n * @param page
7 h- E# t+ }7 V5 C% @3 S8 ^+ Z * @return) a, V# d6 c8 |1 X' E& I: E& C! ^
*/
, X$ t! y$ e [* g, [. n public List getPageList(int page){! C/ h1 U+ |8 e2 o6 O9 P
Connection con=null;- P$ w+ _# a2 `7 N% H) \
PreparedStatement past=null;+ j" h# K; m9 Q9 d# K
ResultSet rs=null;
! H4 E7 n) I6 s/ i" h8 Z1 O, v+ ? List list=new ArrayList();- |0 c' _' S* Y; b
con=getConnection();9 J- \* X0 s. s7 u2 _; W5 j; X
//2 G1 k& o! `& w% m( G5 n1 G
String sql="select top "+count+" * from news where id not in (select top "+(page-1)*count+" id from news order by pubtime desc )order by pubtime desc";
$ C) D' L7 n# G& S; ~6 A try {6 A& p% T+ t1 ^8 g4 y W
past=con.prepareStatement(sql);/ r/ {4 X2 s% ]+ d) n" r1 j6 R
rs=past.executeQuery();
) H/ J4 K* B& e+ v Q8 h: z while(rs.next()){( A4 A m7 W4 f4 f3 b
" ^2 _/ G) U: k
// id, title, content, pubtime, author
9 [- ?; E0 |/ x& ~) Q& v int id=rs.getInt("id");) R( C$ R" S* h3 i& S5 @8 @
String title=rs.getString("title");
4 d1 N7 s* ?( I8 E7 w7 Q3 H; u* q1 u String content=rs.getString("content");, B+ r/ w8 Z1 L b
String pubtime=rs.getString("pubtime");+ i a8 {2 Z1 U8 b, @6 |% f
String author=rs.getString("author");8 o4 M% ]0 t9 v5 N0 Y: ~% M
News news=new News(id, title,content,pubtime,author);
1 L" b1 P( u+ O5 {4 r0 g: F; Y# o list.add(news);
! V0 q$ s) t7 S5 l4 ` }* P/ i. g- ~2 v) {* t. w! N1 V
} catch (SQLException e) {
# N3 [5 z" _% X8 y5 }: u1 V // TODO Auto-generated catch block
# M( C! l+ Q9 w8 i0 D0 f e.printStackTrace();: Q' ]: _4 F! X1 U: U& f/ n2 r1 j7 ?
}0 B0 F" X8 m2 h1 ~
return list;: y0 s) X8 f7 z# p5 X% [0 g
7 j2 ?, @% r. r% I$ |" _5 a1 b }* t* J/ d4 R7 T/ P" l
}
! }8 b2 @, ~1 V2 N# U 复制代码
9 l) Y* p8 d" t" s, C7 r
+ d1 B9 S: m0 V- I7 J 源代码以及数据库下载 : , ^4 f& W! V: a- I4 G6 T
4 a5 U& A4 z9 u
我的日常 1、本主题所有言论和图片纯属会员个人意见,与本社区立场无关2、本站所有主题由该帖子作者发表,该帖子作者与我的日常 享有帖子相关版权3、其他单位或个人使用、转载或引用本文时必须同时征得该帖子作者和我的日常 的同意4、帖子作者须承担一切因本文发表而直接或间接导致的民事或刑事法律责任5、本帖部分内容转载自其它媒体,但并不代表本站赞同其观点和对其真实性负责6、如本帖侵犯到任何版权问题,请立即告知本站,本站将及时予与删除并致以最深的歉意7、我的日常 管理员和版主有权不事先通知发贴者而删除本文
JAVA爱好者①群:
JAVA爱好者②群:
JAVA爱好者③ :