jsp操作新闻表数据作业_jsp的label for语句-CSDN博客

本文链接：https://blog.csdn.net/m0_74374651/article/details/137904090

html

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="UTF-8">

<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>News Management System</title>

</head>

<body>

<h1>News Management System</h1>



<form action="add.jsp" method="post">

<h2>Add News</h2>

<label for="title">Title:</label><br>

<input type="text" id="title" name="title"><br>

<label for="content">Content:</label><br>

<textarea id="content" name="content"></textarea><br>

<label for="datetime">Publish Date:</label><br>

<input type="datetime-local" id="datetime" name="datetime"><br>

<label for="author">Author:</label><br>

<input type="text" id="author" name="author"><br>

<input type="submit" value="Add News">

</form>



<h2>Select All News</h2>

<a href="selectAll.jsp">View All News</a>



<h2>Select Specific News</h2>

<form action="selectId.jsp" method="get">

<label for="id">Enter ID:</label><br>

<input type="text" id="id" name="id"><br>

<input type="submit" value="Search">

</form>



<h2>Conditional Query</h2>

<form action="conditionalQuery.jsp" method="post">

<label for="condition">Enter Condition:</label><br>

<input type="text" id="condition" name="condition"><br>

<input type="submit" value="Search">

</form>



<h2>Fuzzy Search</h2>

<form action="fuzzySearch.jsp" method="post">

<label for="keyword">Enter Keyword:</label><br>

<input type="text" id="keyword" name="keyword"><br>

<input type="submit" value="Search">

</form>



<h2>Delete News</h2>

<form action="delete.jsp" method="post">

<label for="deleteId">Enter ID to Delete:</label><br>

<input type="text" id="deleteId" name="deleteId"><br>

<input type="submit" value="Delete">

</form>



<h2>Update News</h2>

<form action="update.jsp" method="post">

<label for="updateId">Enter ID to Update:</label><br>

<input type="text" id="updateId" name="updateId"><br>

<label for="newTitle">New Title:</label><br>

<input type="text" id="newTitle" name="newTitle"><br>

<label for="newContent">New Content:</label><br>

<textarea id="newContent" name="newContent"></textarea><br>

<label for="newDatetime">New Publish Date:</label><br>

<input type="datetime-local" id="newDatetime" name="newDatetime"><br>

<label for="newAuthor">New Author:</label><br>

<input type="text" id="newAuthor" name="newAuthor"><br>

<input type="submit" value="Update">

</form>

</body>

</html>

add

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

<%@ page import="java.sql.*" %>

<%

String title = request.getParameter("title");

String content = request.getParameter("content");

String datetime = request.getParameter("datetime");

String author = request.getParameter("author");

Connection conn = null;

PreparedStatement pstmt = null;

try {

// Establishing connection

Class.forName("your.database.driver.Class").newInstance();

conn = DriverManager.getConnection("your_database_connection_url");

// Inserting news

String sql = "INSERT INTO news (title, content, datetime, author) VALUES (?, ?, ?, ?)";

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, title);

pstmt.setString(2, content);

pstmt.setString(3, datetime);

pstmt.setString(4, author);

pstmt.executeUpdate();

out.println("News added successfully!");

} catch (Exception e) {

out.println("Error: " + e.getMessage());

} finally {

if (pstmt != null) pstmt.close();

if (conn != null) conn.close();

}

%>

selectAll

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

<%@ page import="java.sql.*" %>

<!DOCTYPE html>

<html>

<head>

<title>Select All News</title>

</head>

<body>

<%

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

// Establishing connection

Class.forName("your.database.driver.Class").newInstance();

conn = DriverManager.getConnection("your_database_connection_url");

// Retrieving all news

String sql = "SELECT * FROM news";

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

// Displaying news

while (rs.next()) {

out.println("ID: " + rs.getString("id") + "<br>");

out.println("Title: " + rs.getString("title") + "<br>");

out.println("Content: " + rs.getString("content") + "<br>");

out.println("Publish Date: " + rs.getString("datetime") + "<br>");

out.println("Author: " + rs.getString("author") + "<br><br>");

}

} catch (Exception e) {

out.println("Error: " + e.getMessage());

} finally {

if (rs != null) rs.close();

if (stmt != null) stmt.close();

if (conn != null) conn.close();

}

%>

</body>

</html>

selectid

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

<%@ page import="java.sql.*" %>

<!DOCTYPE html>

<html>

<head>

<title>Select News by ID</title>

</head>

<body>

<%

String id = request.getParameter("id");

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

// Establishing connection

Class.forName("your.database.driver.Class").newInstance();

conn = DriverManager.getConnection("your_database_connection_url");

// Retrieving news by ID

String sql = "SELECT * FROM news WHERE id = ?";

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, id);

rs = pstmt.executeQuery();

// Displaying news

if (rs.next()) {

out.println("ID: " + rs.getString("id") + "<br>");

out.println("Title: " + rs.getString("title") + "<br>");

out.println("Content: " + rs.getString("content") + "<br>");

out.println("Publish Date: " + rs.getString("datetime") + "<br>");

out.println("Author: " + rs.getString("author") + "<br><br>");

} else {

out.println("No news found with ID: " + id);

}

} catch (Exception e) {

out.println("Error: " + e.getMessage());

} finally {

if (rs != null) rs.close();

if (pstmt != null) pstmt.close();

if (conn != null) conn.close();

}

%>

</body>

</html>

delete

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

<%@ page import="java.sql.*" %>

<!DOCTYPE html>

<html>

<head>

<title>Delete News</title>

</head>

<body>

<%

String deleteId = request.getParameter("deleteId");

Connection conn = null;

PreparedStatement pstmt = null;

try {

// Establishing connection

Class.forName("your.database.driver.Class").newInstance();

conn = DriverManager.getConnection("your_database_connection_url");

// Deleting news

String sql = "DELETE FROM news WHERE id = ?";

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, deleteId);

int rowsAffected = pstmt.executeUpdate();

if (rowsAffected > 0) {

out.println("News with ID " + deleteId + " deleted successfully!");

} else {

out.println("No news found with ID " + deleteId);

}

} catch (Exception e) {

out.println("Error: " + e.getMessage());

} finally {

if (pstmt != null) pstmt.close();

if (conn != null) conn.close();

}

%>

</body>

</html>

update

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

<%@ page import="java.sql.*" %>

<!DOCTYPE html>

<html>

<head>

<title>Update News</title>

</head>

<body>

<%

String updateId = request.getParameter("updateId");

String newTitle = request.getParameter("newTitle");

String newContent = request.getParameter("newContent");

String newDatetime = request.getParameter("newDatetime");

String newAuthor = request.getParameter("newAuthor");

Connection conn = null;

PreparedStatement pstmt = null;

try {

// Establishing connection

Class.forName("your.database.driver.Class").newInstance();

conn = DriverManager.getConnection("your_database_connection_url");

// Updating news

String sql = "UPDATE news SET title = ?, content = ?, datetime = ?, author = ? WHERE id = ?";

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, newTitle);

pstmt.setString(2, newContent);

pstmt.setString(3, newDatetime);

pstmt.setString(4, newAuthor);

pstmt.setString(5, updateId);

int rowsAffected = pstmt.executeUpdate();

if (rowsAffected > 0) {

out.println("News with ID " + updateId + " updated successfully!");

} else {

out.println("No news found with ID " + updateId);

}

} catch (Exception e) {

out.println("Error: " + e.getMessage());

} finally {

if (pstmt != null) pstmt.close();

if (conn != null) conn.close();

}

%>

</body>

</html>