学习十四

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

一级指标分级

日常生活活动: 能力完好 轻度受损 中度受损 重度受损

精神状态: 能力完好 轻度受损 中度受损 重度受损

感知觉与沟通: 能力完好 轻度受损 中度受损 重度受损

社会参与: 能力完好 轻度受损 中度受损 重度受损

提交

‌styles.css‌ body { font-family: Arial, sans-serif; background-color: #f4f4f4; margin: 0; padding: 0; }

h1 {
text-align: center;
color: #333;
}

.form-group {
margin-bottom: 15px;
}

label {
display: block;
margin-bottom: 5px;
font-weight: bold;
}

select {
width: 100%;
padding: 8px;
box-sizing: border-box;
}

button {
display: block;
width: 100%;
padding: 10px;
background-color: #5cb85c;
color: white;
border: none;
cursor: pointer;
font-size: 16px;
}

button:hover {
background-color: #4cae4c;
}
JavaBean 类：PrimaryIndicators
public class PrimaryIndicators {
private int dailyLiving;
private int mentalStatus;
private int sensoryCommunication;
private int socialInvolvement;

// Getters and Setters
public int getDailyLiving() {
    return dailyLiving;
}

public void setDailyLiving(int dailyLiving) {
    this.dailyLiving = dailyLiving;
}

public int getMentalStatus() {
    return mentalStatus;
}

public void setMentalStatus(int mentalStatus) {
    this.mentalStatus = mentalStatus;
}

public int getSensoryCommunication() {
    return sensoryCommunication;
}

public void setSensoryCommunication(int sensoryCommunication) {
    this.sensoryCommunication = sensoryCommunication;
}

public int getSocialInvolvement() {
    return socialInvolvement;
}

public void setSocialInvolvement(int socialInvolvement) {
    this.socialInvolvement = socialInvolvement;
}

}
Servlet 类：PrimaryIndicatorsServlet
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
@WebServlet("/submitPrimaryIndicators")
public class PrimaryIndicatorsServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrimaryIndicators indicators = new PrimaryIndicators();
indicators.setDailyLiving(Integer.parseInt(request.getParameter("dailyLiving")));
indicators.setMentalStatus(Integer.parseInt(request.getParameter("mentalStatus")));
indicators.setSensoryCommunication(Integer.parseInt(request.getParameter("sensoryCommunication")));
indicators.setSocialInvolvement(Integer.parseInt(request.getParameter("socialInvolvement")));
try {
// Database connection
String url = "jdbc:oracle:thin:@//localhost:1521/xe";
String user = "your_username";
String password = "your_password";
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "INSERT INTO primary_indicators (daily_living, mental_status, sensory_communication, social_involvement) VALUES (?, ?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, indicators.getDailyLiving());
pstmt.setInt(2, indicators.getMentalStatus());
pstmt.setInt(3, indicators.getSensoryCommunication());
pstmt.setInt(4, indicators.getSocialInvolvement());
pstmt.executeUpdate();

        conn.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }

    response.sendRedirect("primaryIndicators.jsp");
}

}