📄 student_info.jsp
字号:
<%@ page contentType="text/html; charset=iso8859_1" language="java" import="java.sql.*" errorPage="" %>
<html >
<head>
<title>无标题文档</title>
</head>
<body background="jpg/4.jpg">
<div align="center">
<p> </p>
<p align="left"> </p>
<p align="left">
<%
//String name = request.getParameter("student_id");
String name = (String)session.getAttribute("student_id");
//out.println(session.getAttribute("student_n"));
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(ClassNotFoundException e){
out.println(e.getMessage());
}
try{
con=DriverManager.getConnection("jdbc:mysql://localhost/jsp?user=root&password=123456&useUnicode=true&characterEncoding=iso8859_1");
sql=con.createStatement();
rs=sql.executeQuery("SELECT student_id,student_name,grade FROM student where student_id = '" + name +"'");
while(rs.next())
{
out.print("<p>学号:" +" " + rs.getString(1) +"</p>");
out.print("<p>姓名:" +" " + rs.getString(2) +"</p>");
out.print("<p>班级:" +" " + rs.getString(3) +"</p>");
}
}
catch(Exception e)
{
out.print(e.getMessage());
}
%>
</p>
</div>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -