JSP连接数据库并创建学生信息示例代码

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

<% String url = 'jdbc:mysql://localhost:3306/student_db'; String username = 'root'; String password = 'password';

Connection conn = null; PreparedStatement pstmt = null;

String name = request.getParameter('name'); int age = Integer.parseInt(request.getParameter('age')); String gender = request.getParameter('gender');

try { Class.forName('com.mysql.jdbc.Driver'); conn = DriverManager.getConnection(url, username, password);

String sql = 'INSERT INTO student (name, age, gender) VALUES (?, ?, ?)';
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setInt(2, age);
pstmt.setString(3, gender);
pstmt.executeUpdate();

out.println('学生信息创建成功！');

} catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (pstmt != null) { pstmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } %>

此代码将创建一个学生信息表单，用户可以输入学生姓名、年龄和性别，并将其插入到名为“student_db”的MySQL数据库中的“student”表中。请注意，此代码仅用于示例目的，应根据实际需求进行修改和优化。