程序设计--Java Web之《云博客》（version1.0）

后续进行完善，目前只有框架布局：

上结果：

这个是注册界面：

注册成功界面

注册失败界面：

已有账号，可以直接登录：

一个简陋的主界面；

实现增加日志的功能；

完成插入功能。

返回主页。

实现浏览功能；

小bug ，中文乱码。但是英文没问题。

这个是查询界面；

修改界面；

修改结果；

预留更多，后面继续。

退出功能；

话不多说，上代码：

delete1.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/4/17
  Time: 14:53
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java"
         pageEncoding="UTF-8"
         import="java.sql.*"
%>


    delete table here


<%
    request.setCharacterEncoding("UTF-8");
    String id = request.getParameter("delettext");

    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/test";
    String un = "root";         //MySql用户名
    String pa = "cjd";  //MySql密码

    Connection con = DriverManager.getConnection(url, un, pa);
    Statement st = con.createStatement();
   // PreparedStatement pst = null;
    System.out.println("delete Successful!");
    String sql = "DELETE FROM we WHERe class =?";
 //   pst = con.prepareStatement(sql);
    PreparedStatement pstmt = con.prepareStatement(sql);
    pstmt.setString(1, id);
    int flag = pstmt.executeUpdate();
    if (flag > 0) {
        out.println("删除成功！");
        out.print("返回首页 ");
    } else {
        out.println("删除失败！");
        out.print("返回首页 ");
    }
    con.close();
    st.close();

%>

delete01.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/5/29
  Time: 11:37
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


<%
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
%>

    输入你要删除的日志序号：

help.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/5/29
  Time: 14:49
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


敬请期待。。。。。。。。

<%
    out.print("返回首页 ");
%>

logoin.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    logoin



    用户名：

    密码：

logoin_zh.jsp

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    


<%
    //获取用户输入信息
    request.setCharacterEncoding("utf-8");
  //  response.setHeader (" content - type ",＂text/ html ; charset = UTF -8");
//    response.setHeader("concent-type,text/html;charset=UTF-8");
    // response.setCharacterEncoding (" UTF -8"");
    response.setCharacterEncoding("UTF-8");
    String username=request.getParameter("username");
    String userpwd=request.getParameter("userpwd");
    Connection conn = null;
    Statement stmt = null;
    try {
        //连接驱动
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
    //建立数据库连接
    String url = "jdbc:mysql://localhost:3306/test";
    //数据库账号
    String uname="root";
    //数据库密码
    String upwd="cjd";

    try {
        conn = DriverManager.getConnection(url, uname, upwd);
        //创建发射器
        stmt = conn.createStatement();
        //创建sql语句
        String sql = "select*from test.yonghu where username='"+username+"' and userpwd='"+userpwd+"'";
        //发送sql语句并接收结果
        ResultSet rs = stmt.executeQuery(sql);
        if (rs.next()) {
            out.print("登陆成功");
            response.sendRedirect("testform01.jsp");
        } else {
            out.print("登陆失败");
            out.print("返回注册 ");
        }
        rs.close();
    }
    catch (SQLException e) {
        e.printStackTrace();
    }

%>

registered.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    注册


个人云博客在线平台登录


    输入用户名：

    输入密码：

    确认密码：

    
    <%
        out.print("已有账号，去登陆"+"登录 ");
    %>

Show.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"
         import="java.sql.*"
%>



    
    Insert title here
<%

    //star
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
    String name5 = request.getParameter("showtext");
    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/test";

    String un = "root";         //MySql用户名
    String pa = "cjd";       //MySql密码
    Connection con = DriverManager.getConnection(url, un, pa);
    request.setCharacterEncoding("UTF-8");
 //   Statement st = con.createStatement();
//    WHERe name ="+name5;
    out.print(name5);
    String sql = "SELECt * FROM we where class =?";
    PreparedStatement preparedStatement = con.prepareStatement(sql);
    preparedStatement.setString(1,name5);

    ResultSet resultSet = preparedStatement.executeQuery();
    resultSet.last();

%>

    你要查询的日志数据表中共有
    <%=resultSet.getRow()%>条
    

        <%
            resultSet.beforeFirst();
            while (resultSet.next()){
        %>          
        <%}%>
    
        
            记录条数
            日志题目
            天气
            日志序号
            日志内容

        

        <%=resultSet.getRow()%>
        <%=resultSet.getString("name")%>
        <%=resultSet.getString("sex")%>
        <%=resultSet.getInt("class")%>
        <%=resultSet.getString("topic")%>
    

<%
    if (resultSet!=null){
        resultSet.close();
    }
    if (preparedStatement!=null){
        preparedStatement.close();
    }
    if (con!=null){
        con.close();
    }
%>


<%
    out.print("返回首页 ");
%>

Show01.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/5/29
  Time: 11:43
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


<%
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
%>

    请输入你要查询的日志的序号

test.jsp

<%@ page language="java"
         pageEncoding="UTF-8"
         import="java.sql.*"
%>



    Insert title here


<%
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
    String name = request.getParameter("textname");
    String pwd = request.getParameter("u1");
    int num = Integer.parseInt(request.getParameter("classuser"));
    String textname1 = request.getParameter("textname1");

    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/test";
    String un = "root";         //MySql用户名
    String pa = "cjd";  //MySql密码

    Connection con = DriverManager.getConnection(url, un, pa);
    Statement st = con.createStatement();
//    String sql = "select * from we";
    System.out.println("Connection Successful!");
    String sql = "Insert into we(name,sex,class,topic) values(?,?,?,?)";
    PreparedStatement pstmt = con.prepareStatement(sql);
    pstmt.setString(1, name);
    pstmt.setString(2, pwd);
    pstmt.setInt(3, num);
    pstmt.setString(4, textname1);
    int n = pstmt.executeUpdate();

    if (n == 1) {%>数据插入成功！
<%} else {%>数据插入失败！
<%
    }
    out.print("返回首页 ");
    con.close();
    st.close();

%>

test01.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/5/29
  Time: 11:28
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


<%
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
%>

    第个日志记录

    日志标题：

    天气：

    日志内容：

test01.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/5/29
  Time: 11:18
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


个人云博客在线平台主页面







    <%
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        out.println("增加日志 "+" "+" ");
        out.println("删除日志 "+" "+" ");
        out.println("浏览日志 "+" "+" ");
        out.println("修改日志 "+" "+" ");
        out.println("退出 "+" "+" ");
        out.println("更多 "+" ");
    %>

Update.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/4/17
  Time: 15:46
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" import="java.sql.*" %>


    update table here


<%
    request.setCharacterEncoding("UTF-8");
    response.setCharacterEncoding("UTF-8");
    String name1 = request.getParameter("updatetext");
    String sex1 = request.getParameter("updatesex");
    int num1 = Integer.parseInt(request.getParameter("updateclass"));
    String topic1 = request.getParameter("updatetopic");

    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/test";
    String un = "root";         //MySql用户名
    String pa = "cjd";  //MySql密码

    Connection con = DriverManager.getConnection(url, un, pa);
    Statement st = con.createStatement();

    System.out.println("update Successful!");
//    String sql ="update we set sex=?,class=?,topic=? where name=?";
    String sql ="update we set sex=?,name=?,topic=? where class=?";
      // pst = con.prepareStatement(sql);
    PreparedStatement pstmt = con.prepareStatement(sql);
    pstmt.setString(1, sex1);
    pstmt.setInt(4, num1);
    pstmt.setString(3, topic1);
    pstmt.setString(2, name1);

    int flag = pstmt.executeUpdate();
    if (flag > 0) {
        out.println("修改成功！");
        out.print("返回主页面 ");
    } else {
        out.println("修改失败");
        out.print("返回主页面  ");
    }
    con.close();
    st.close();

%>

Update01.jsp

<%--
  Created by IntelliJ IDEA.
  User: ${陈平安}
  Date: 2022/5/29
  Time: 11:46
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


<%
    request.setCharacterEncoding("UTF-8");
%>

    输入你要修改的日志标题：

    输入你要修改的日志天气：

    输入你要修改的日志序号：

 

    输入你要修改的日志内容：

zc.jsp

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.SQLException" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title


<%
    //获取用户输入信息
    request.setCharacterEncoding("utf-8");
    String username=request.getParameter("username");
    String userpwd=request.getParameter("userpwd");
    String cuserpwd=request.getParameter("cuserpwd");
    //判断两次密码是否相同
    if (cuserpwd.equals(userpwd)) {
        Connection conn = null;
        Statement stmt = null;
        try {
            //连接驱动
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        //建立数据库连接
        String url="jdbc:mysql://localhost:3306/test";
        //数据库账号
        String user="root";
        //数据库密码
        String upwd="cjd";
        try {
            conn= DriverManager.getConnection(url,user,upwd);
            //创建发射器
            stmt=conn.createStatement();
            //创建sql语句
            String sql="insert into yonghu(username,userpwd) value ('"+username+"','"+userpwd+"')";
            //发送sql语句并接收结果
            int count = stmt.executeUpdate(sql);
            if (count>0){
                out.print("注册成功");
                out.print("登录 ");
            }
            else{
                out.print("注册失败");
                out.print("返回注册界面 ");
            }
            //关闭资源
            stmt.close();
            conn.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    else {
        out.print("注册失败"+"
");
        out.print("返回注册界面 ");
    }
%>

还需要引入5.7的Mysql的jar包；

记录条数	日志题目	天气	日志序号	日志内容
<%=resultSet.getRow()%>	<%=resultSet.getString("name")%>	<%=resultSet.getString("sex")%>	<%=resultSet.getInt("class")%>	<%=resultSet.getString("topic")%>

程序设计--Java Web之《云博客》（version1.0）

个人云博客在线平台登录 输入用户名： 输入密码： 确认密码： <% out.print("已有账号，去登陆"+"登录 "); %>

Java相关栏目本月热门文章

个人云博客在线平台登录

输入用户名：
输入密码：
确认密码：
<% out.print("已有账号，去登陆"+"登录 "); %>