📄 index2.jsp
字号:
<%@page contentType="text/html; charset=gbk"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Exception.*"%>
<%
//数据库连接
String url="jdbc:odbc:xuesheng";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet result=stmt.executeQuery("select * from xinxi_study");
ResultSetMetaData resultmd=result.getMetaData();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>学生界面</title>
<style type="text/css">
<!--
body {
background-image: url(684514.jpg);
}
.STYLE1 {
color: #FF9933;
font-weight: bold;
font-size: xx-large;
font-family: "华文行楷";
}
-->
</style>
</head>
<body>
<center>
<form name="form1" method="post" action="select.jsp" id="form1">
<span class="STYLE1">
<%
//int count=resultmd.getColumnCount();
//condition = new String(condition.getBytes("ISO-8859-1"), "GBK");
String text1=(String)session.getAttribute("uid1");
String text2="study_id";
String text3="=";
String sql="select study_name from xinxi_study where "+text2+ text3 + text1;
ResultSet result1=stmt.executeQuery(sql);
//out.println("欢迎您同学:"+"<p>");
//out.println(sql);
out.println("<br>");
while(result1.next())
{
out.println("欢迎您: "+result1.getString("study_name")+"同学");
}
//String first=result1.getString(1);
//out.println(first);
%>
</span>
<tr>
<td align="left">
<p align="center">
</p>
<p align="center"><A href="studyselect.jsp" ><font face="方正舒体" size="6">查询已借书目</font></A></p>
<p align="center"> <font face="方正舒体" size="6"><A href="jieshu.jsp" >借书</A> </font> <A href="huanshu.jsp" ><font face="方正舒体" size="6">还书</font></A></p>
<p align="center">
<font face="方正舒体" size="6"><A href="select.jsp" >查询</font></A>
<font face="方正舒体" size="6"><A href="studypassword.jsp" >密码修改</font></A></p>
<p></p>
<p></p>
<p></p>
<p align="center"><A href="index1.jsp">返回上一页</p>
</td>
</tr>
</p>
</p>
<%
stmt.close();
con.close();
%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -