练习~个人博客系统
这里的UI及样式借用了师兄的作品~
jsp开发,服务器是tomcat,需要用到mysql数据库。
就贴两个页面
1 <%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%> 2 <% 3 //登录验证 4 boolean isLogin = true; 5 Integer uid = (Integer)session.getAttribute("uid"); 6 if(uid==null){ 7 isLogin = false; 8 } 9 10 //JDBC连接代码 11 Connection con = null; 12 try{ 13 Class.forName("com.mysql.jdbc.Driver"); 14 con = DriverManager.getConnection( 15 "jdbc:mysql://localhost:3306/myblog", "root", "root"); 16 Statement stp = con.createStatement(); 17 String sqlp = "select * from mb_user where user_id = "+ 1; 18 ResultSet rsp = stp.executeQuery(sqlp); 19 rsp.next(); 20 String name = rsp.getString("name"); 21 String desc = rsp.getString("descrition"); 22 rsp.close(); 23 stp.close(); 24 %> 25 <!DOCTYPE html> 26 <html> 27 <head> 28 <!--网站标题--> 29 <title><%=name%>的个人博客</title> 30 <!--导入css--> 31 <link href="css/style.css" rel="stylesheet" type="text/css" /> 32 </head> 33 34 <body> 35 <!--top begin--> 36 <div class="top"> 37 <div class="top-box"> 38 <!--menu begin--> 39 <div class="menu"> 40 <a href="index.jsp" >首页</a> 41 <a href="blog.jsp" class="current">我的博文</a> 42 </div> 43 <!--menu end--> 44 45 <!--search begin--> 46 <div class="search"> 47 <form action="blog_search.jsp" method="post"> 48 <input type="text" name="search_content" class="text"/> 49 <input type="submit" value="搜索" class="btn"/> 50 </form> 51 </div> 52 <!--search end--> 53 </div> 54 </div> 55 <!--top end--> 56 57 <!--head begin--> 58 <div class="head"> 59 <div class="head-top"> 60 <div class="title"><%=name%></div> 61 <div class="subtitle"><%=desc%></div> 62 </div> 63 <div class="head-bottom"> 64 65 </div> 66 </div> 67 <!--head end--> 68 69 <!--main begin--> 70 <div class="main"> 71 <!--main-cantent begin--> 72 <div class="main-box"> 73 <!--main-content begin--> 74 <div class="main-content"> 75 <!--导航 begin--> 76 <div class="nav"> 77 <span>当前:我的博文</span> 78 <% 79 if(isLogin){ 80 %> 81 <a href="blog_add.jsp">【新建博文】</a> 82 <% 83 } 84 %> 85 </div> 86 <!--导航 end--> 87 88 <!--文章列表 begin--> 89 <% 90 Statement st1 = con.createStatement(); 91 String sql1 = "select * from mb_blog order by b_posttime desc"; 92 ResultSet rs1 = st1.executeQuery(sql1); 93 while(rs1.next()){ 94 Statement st2 = con.createStatement(); 95 String sql2 = "select * from mb_blog_type where type_id = "+rs1.getInt("b_typeid"); 96 ResultSet rs2 = st2.executeQuery(sql2); 97 rs2.next(); 98 String b_type = rs2.getString("type_name"); 99 rs2.close(); 100 st2.close(); 101 %> 102 <div class="ar_list_item"> 103 <div class="ar_title"><a href="blog_view.jsp?b_id=<%=rs1.getInt("b_id")%>"><%=rs1.getString("b_title")%></a></div> 104 <div class="ar_desc"> 105 <span>浏览数【<%=rs1.getString("b_viewnums")%>】 <%=rs1.getString("b_posttime").substring(0,16)%></span> 106 <a href="#"><%=b_type%></a> 107 <% 108 if(isLogin){ 109 %> 110 <a href="blog_edit.jsp?b_id=<%=rs1.getInt("b_id")%>">【修改博文】</a> 111 <a href="blog_del_do.jsp?b_id=<%=rs1.getInt("b_id")%>">【删除博文】</a> 112 <% 113 } 114 %> 115 </div> 116 <div class="ar_content"><%=rs1.getString("b_intro")%></div> 117 </div> 118 <% 119 } 120 rs1.close(); 121 st1.close(); 122 %> 123 <!--文章列表 end--> 124 </div> 125 <!--main-content end--> 126 127 <!--main-sidebar begin--> 128 <div class="main-sidebar"> 129 <!--博文分类 begin--> 130 <div class="side_box"> 131 <div class="side_title"> 132 博文分类 133 <a href="type_add.jsp" style="text-decoration:none; 134 color:#427A24">【新建分类】</a> 135 </div> 136 <div class="side_list"> 137 <ul> 138 <% 139 Statement st4 = con.createStatement(); 140 String sql4 = "select * from mb_blog_type"; 141 ResultSet rs4 = st4.executeQuery(sql4); 142 while(rs4.next()){ 143 %> 144 <li> 145 <a href="blog_type.jsp?type_id=<%=rs4.getInt("type_id")%>"><%=rs4.getString("type_name")%></a> 146 <a href="type_edit.jsp?type_id=<%=rs4.getInt("type_id")%>" class="a2">【改】</a> 147 <a href="type_del_do.jsp?type_id=<%=rs4.getInt("type_id")%>" class="a2">【删】</a> 148 </li> 149 <% 150 } 151 rs4.close(); 152 st4.close(); 153 %> 154 </ul> 155 </div> 156 </div> 157 <!--博文分类 end--> 158 159 <!--热门博文 begin--> 160 <div class="side_box"> 161 <div class="side_title"> 162 热门博文 163 </div> 164 <div class="side_list"> 165 <ul> 166 <% 167 Statement st3 = con.createStatement(); 168 String sql3 = "select * from mb_blog order by b_viewnums desc"; 169 ResultSet rs3 = st3.executeQuery(sql3); 170 int n=0; 171 while(rs3.next()){ 172 %> 173 <li><a href="blog_view.jsp?b_id=<%=rs3.getInt("b_id")%>"><%=rs3.getString("b_title")%></a></li> 174 <% 175 n++; 176 if(n>9){ 177 break; 178 } 179 } 180 rs3.close(); 181 st3.close(); 182 %> 183 184 </ul> 185 </div> 186 </div> 187 <!--热门博文 end--> 188 </div> 189 <!--main-sidebar end--> 190 191 <div class="clear"></div> 192 </div> 193 <!--main-box end--> 194 195 <!--main-bottom begin--> 196 <div class="main-bottom"> 197 Copyright © 2015 <%=name%>个人博客网站 All rights reserved 198 </div> 199 <!--main-bottom end--> 200 </div> 201 <!--main end--> 202 </body> 203 </html> 204 <% 205 }catch(Exception e){ 206 System.out.println(e); 207 }finally{ 208 try{ 209 if(con!=null){ 210 con.close(); 211 } 212 }catch(Exception e){ 213 System.out.println(e); 214 } 215 } 216 %>
1 <%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%> 2 <% 3 //登录验证 4 boolean isLogin = true; 5 Integer uid = (Integer)session.getAttribute("uid"); 6 if(uid==null){ 7 isLogin = false; 8 } 9 10 //JDBC连接代码 11 Connection con = null; 12 try{ 13 Class.forName("com.mysql.jdbc.Driver"); 14 con = DriverManager.getConnection( 15 "jdbc:mysql://localhost:3306/myblog", "root", "root"); 16 Statement stp = con.createStatement(); 17 String sqlp = "select * from mb_user where user_id = "+ 1; 18 ResultSet rsp = stp.executeQuery(sqlp); 19 rsp.next(); 20 String name = rsp.getString("name"); 21 String desc = rsp.getString("descrition"); 22 String intro = rsp.getString("intro"); 23 rsp.close(); 24 stp.close(); 25 %> 26 <!DOCTYPE html> 27 <html> 28 <head> 29 <!--网站标题--> 30 <title><%=name%>的个人博客</title> 31 <!--导入css--> 32 <link href="css/style.css" rel="stylesheet" type="text/css" /> 33 </head> 34 35 <body> 36 <!--top begin--> 37 <div class="top"> 38 <div class="top-box"> 39 <!--menu begin--> 40 <div class="menu"> 41 <a href="index.jsp" class="current">首页</a> 42 <a href="blog.jsp">我的博文</a> 43 </div> 44 <!--menu end--> 45 46 <!--search begin--> 47 <div class="search"> 48 <form action="blog_search.jsp" method="post"> 49 <input type="text" name="search_content" class="text"/> 50 <input type="submit" value="搜索" class="btn"/> 51 </form> 52 </div> 53 <!--search end--> 54 </div> 55 </div> 56 <!--top end--> 57 58 <!--head begin--> 59 <div class="head"> 60 <div class="head-top"> 61 <div class="title"><%=name%></div> 62 <div class="subtitle"><%=desc%></div> 63 </div> 64 <div class="head-bottom"> 65 66 </div> 67 </div> 68 <!--head end--> 69 70 <!--main begin--> 71 <div class="main"> 72 <!--main-cantent begin--> 73 <div class="main-box"> 74 <!--main-content begin--> 75 <div class="main-content"> 76 <div class="ar_title">博主介绍</div> 77 <div class="ar_content"> 78 <%=intro%> 79 </div> 80 </div> 81 <!--main-content end--> 82 83 <!--main-sidebar begin--> 84 <div class="main-sidebar"> 85 <% 86 if(uid==null){ 87 %> 88 <!--博主登录 begin--> 89 <div class="side_box"> 90 <div class="side_title">博主登录</div> 91 <div class="login_box"> 92 <form action="user_login_do.jsp" method="post"> 93 <label>用户名:</label> 94 <input type="text" name="username" class="text"/> 95 <br/> 96 <label>密 码:</label> 97 <input type="password" name="userpass" class="text"/> 98 <br/> 99 <input type="submit" value="登录" class="btn"/> 100 <input type="reset" value="重置" class="btn"/> 101 <% 102 String rtn = request.getParameter("rtn"); 103 if("1".equals(rtn)){ 104 %> 105 <p> 106 <span style="color:red">用户名和密码不能为空!</span> 107 </p> 108 <% 109 }else if("2".equals(rtn)){ 110 %> 111 <p> 112 <span style="color:red">用户名或密码错误!</span> 113 </p> 114 <% 115 } 116 %> 117 </form> 118 </div> 119 </div> 120 <!--博主登录 end--> 121 <% 122 }else{ 123 %> 124 <!--个人中心 begin--> 125 <div class="side_box"> 126 <div class="side_title">用户中心</div> 127 <div class="ucenter_box"> 128 <p>博主<%=name%>,欢迎您登录!</p> 129 <p><a href="user_info_edit.jsp">个人资料修改</a></p> 130 <p><a href="user_psw_edit.jsp">登录密码修改</a></p> 131 <p><a href="blog.jsp">博文管理</a></p> 132 <p><a href="user_logout_do.jsp">退出</a></p> 133 </div> 134 </div> 135 <!--个人中心 end--> 136 <% 137 } 138 %> 139 <!--形象墙 begin--> 140 <div class="side_box"> 141 <div class="side_title">形象墙</div> 142 <div class="imagewall_box"> 143 <img src="images/img05.png" /> 144 </div> 145 </div> 146 <!--形象墙 end--> 147 </div> 148 <!--main-sidebar end--> 149 150 <div class="clear"></div> 151 </div> 152 <!--main-box end--> 153 154 <!--main-bottom begin--> 155 <div class="main-bottom"> 156 Copyright © 2015 <%=name%>个人博客网站 All rights reserved 157 </div> 158 <!--main-bottom end--> 159 </div> 160 <!--main end--> 161 </body> 162 </html> 163 <% 164 }catch(Exception e){ 165 System.out.println(e); 166 }finally{ 167 try{ 168 if(con!=null){ 169 con.close(); 170 } 171 }catch(Exception e){ 172 System.out.println(e); 173 } 174 } 175 %>