guanliyuan.jsp

WEB图书馆系统,jsp编写,适用用于JSP的初始者

<style type="text/css">
<!--
body {
	background-image: url(618761071.jpg);
}
-->
</style>

<%@ page contentType="text/html;charset=GB2312"%>
<%@ 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_guanliyuan");
  //ResultSetMetaData resultmd=result.getMetaData();
%>


<h1 align="center">欢迎进入管理员操作系统<font color="0.0"></h></font>
<p align="center">
<%
//int count=resultmd.getColumnCount();
//condition = new String(condition.getBytes("ISO-8859-1"), "GBK"); 

String text1=(String)session.getAttribute("uid1");
String text2="guanliyuan_id";
String text3="=";

String sql="select guanliyuan_name from xinxi_guanliyuan 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("guanliyuan_name")+"管理员"+"<p>");
}
//String first=result1.getString(1);
//out.println(first);



stmt.close();
con.close();
%>