Q: 我想把 python 结果呈现在 有html 格式的脚本上,那应该存成什么类型的文件? (.py , .html , .jsp , .psp ?)
Jakarta Server Pages(以前称为 JavaServer Pages)是一种 Java 标准技术,开发人员使用它为 Java Web 应用程序编写动态的、数据驱动的网页。JSP 建立在Java Servlet (又名 Jakarta Servlet )规范之上,是Jakarta EE中用于持续支持和升级的 Java Web 技术之一。
JSP 和 servlet 通常一起工作,尤其是在较旧的 Java Web 应用程序中。从编码的角度来看,JSP 和 servlet 之间最明显的区别是,对于 servlet,您可以编写 Java 代码,然后将客户端标记(如 HTML)嵌入到该代码中。使用 JSP,您从客户端脚本或标记开始,然后嵌入 JSP 标记以将您的页面连接到 Java 后端。
这是全代码,只是不知道该存成什么类型的文件,如果想看的话,请过目
# want to combine html and python together, what kind of file type is suitable?
# python script which can works fine in .py file
import mysql.connector
mydb = mysql.connector.connect(
host="196.168.100.141",
user="root",
password="password_123",
database="my_db",
auth_plugin='mysql_native_password'
)
mycursor = mydb.cursor()
mycursor.execute("SELECT P_TITLE FROM database")
myresult = mycursor.fetchall()
list_01 = []
for row in myresult:
temp_val = row[0]
list_01.append(temp_val) # store SQL value in list, then want to insert in <p> p>
html>
<html class="no-js" lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>My site title>
<meta name="description" content="this is cool website">
<link rel="icon" href="../images/favicon.png">
<link rel="stylesheet" href="../assets/css/vendor/bootstrap.min.css">
<link rel="stylesheet" href="../assets/css/vendor/cerebrisans.css">
<link rel="stylesheet" href="../assets/css/vendor/fontawesome-all.min.css">
<link rel="stylesheet" href="../assets/css/vendor/linea-icons.css">
<link rel="stylesheet" href="../assets/css/plugins/swiper.min.css">
<link rel="stylesheet" href="../assets/css/plugins/animate-text.css">
<link rel="stylesheet" href="../assets/css/plugins/animate.min.css">
<link rel="stylesheet" href="../assets/css/plugins/lightgallery.min.css">
<link rel="stylesheet" href="../assets/css/Custom.css">
<link rel="stylesheet" href="../assets/css/style.css">
head>
<body>
<div class="preloader-activate preloader-active open_tm_preloader">
<div class="preloader-area-wrap">
<div class="spinner d-flex justify-content-center align-items-center h-100">
<div class="bounce1">div>
<div class="bounce2">div>
<div class="bounce3">div>
div>
div>
div>
<div class="header-area header-area--default">
<div class="header-top-wrap border-bottom">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<div class="top-bar-wrap">
<div class="top-bar-left">
<div class="top-bar-text">div>
div>
<div class="top-bar-right">
<ul class="top-bar-info">
<li class="info-item">
<a href="my_link.com" class="info-link">
<i class="info-icon fa fa-user-circle">i>
<span class="info-text">(list_01[0]span>
a>
li>
<li class="info-item">
<a href="my_link.com" class="info-link">
<i class="info-icon fa fa-user-circle">i>
<span class="info-text">(list_01[1]span>
a>
li>
ul>
div>
div>
div>
div>
div>
div>
body>
html>
其实按照字符拼接的话任何格式都可以