java+Servlet+html代码

ｃｌｇ风

已于 2022-07-23 19:51:22 修改

阅读量182

点赞数

文章标签： servlet java html

于 2022-07-23 19:49:13 首次发布

本文链接：https://blog.csdn.net/Donotfor/article/details/125951026

版权

依赖

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>org.example</groupId>
  <artifactId>Json</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>Json Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>com.google.code.gson</groupId>
      <artifactId>gson</artifactId>
      <version>2.6.2</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.0.1</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.2</version>
      <scope>provided</scope>
    </dependency>
  </dependencies>

  <build>
    <finalName>Json</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

web.xml代码块

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  <display-name>JsonTest</display-name>
  <welcome-file-list>
    <welcome-file>WEB-INF/index.jsp</welcome-file>
  </welcome-file-list>
  <servlet>
    <servlet-name>NewsServlet</servlet-name>
    <servlet-class>NewsServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>NewsServlet</servlet-name>
    <url-pattern>/getJson</url-pattern>
  </servlet-mapping>

</web-app>

ajax代码块

<!DOCTYPE html>

<!-- <meta http-equiv="Access-Control-Allow-Origin" content="*" /> -->

<html>

<head>

    <meta charset="utf-8">

    <title>菜鸟教程(runoob.com)</title>

    <script src="js/jquery-3.3.1.min.js">

    </script>

    <script>

    $(document).ready(function(){

    });

    $(function(){

       // $("button").click(function(){

        $.ajax({

            url: 'http://localhost:8080/getJson',

            　type: "get",

        　　crossDomain: true,

        　　xhrFields: {

        　　　　withCredentials: true

        　　},

        　　dataType: "json",

        　　data: {

        　　　　"yngrbsh":"31010920090306250337209",

        　　　　"pglsh":"157a0a07-73e9-450a-b835-3f396b3b7acb",

        　　　　"jbdms":"JB_GXY;JB_NCZ;JB_TNB_YH"

        　　},

    　　success: function (data) {

            let h33 = document.getElementById("h33")

            var html = "";

            console.log(data[0].content)  

            h33.innerText = data[0].content

            for (var i = 0; i < data.length; i++) {

                html+="<tr>"+

                    "<td>"+data[i].nId+"</td>"+

                    "<td>"+data[i].title+"</td>"+

                    "<td>"+data[i].content+"</td>"+

                    "<td>"+data[i].date+"</td>"+

                    "<td>"+data[i].url+"</td>"

                    +"</tr>"

            }

            $("#tbody_tr").html = html

            $("#tbody_tr").append(html);

    　　}

    });

            // });

    })

    </script>

</head>

<body>

    <table>

        <thead>

            <tr>

                <td>路径类型名称</td>

                <td>路径ID</td>

                <td>路径名称</td>

                <td>请求数量</td>

            </tr>

        </thead>

        <tbody id="tbody_tr">



        </tbody>

       

    </table>



<button>发送一个 HTTP GET 请求并获取返回结果</button>

<h3 id="h33"></h3>

</body>

</html>

JDBC代码块

package com.JDBC;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class JDBC {
    private static final String name = "com.mysql.jdbc.Driver";
    private static final String url = "jdbc:mysql://127.0.0.1:3306/zuoye";
    private static final String root = "root";
    private static final String pass = "*******";

//加载驱动
    static{
        try {
            Class.forName(name);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
//    链接驱动
    public static Connection getConn(){
        Connection cn = null;
        try {
            cn= DriverManager.getConnection(url,root,pass);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return cn;
    }
//关闭链接
    public static void CloseCon(Connection con , PreparedStatement pstm , ResultSet rs){
        try {
            if(con!=null){
                con.close();
            }
            if(pstm!=null){
                pstm.close();
            }
            if(rs!=null){
                rs.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static void main(String[] args) {
        System.out.println(getConn());
    }

}

dao查询所有模块

package com.Dao;

import com.JDBC.JDBC;
import com.Model.Workflow_Base;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class Workflow_BaseDao {
    Connection con = null;
    PreparedStatement pstm = null;
    ResultSet rs = null;
    String sql = "";
//查询所有
    public List<Workflow_Base> selectAll(){
        List<Workflow_Base> arr = new ArrayList<Workflow_Base>();
        con = JDBC.getConn();
        sql = "select id, workflowtype, workflowname, formid from WORKFLOW_BASE";
        try {
            pstm = con.prepareStatement(sql);
            rs = pstm.executeQuery();
            while (rs.next()){
                int id = rs.getInt("id");
                String workflowtype = rs.getString("workflowtype");
                String workflowname = rs.getString("workflowname");
                String formid = rs.getString("formid");
                Workflow_Base wb = new Workflow_Base(id,workflowtype,workflowname,formid);
                arr.add(wb);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBC.CloseCon(con,pstm,rs);
        }
        return arr;
    }

    public static void main(String[] args) {
        Workflow_BaseDao wdb = new Workflow_BaseDao();

        List<Workflow_Base> workflow_bases = wdb.selectAll();
        for (Workflow_Base w :workflow_bases) {
            System.out.println(w.getWorkflowname());
        }

    }

}