gerenxinxi_result.jsp

jsp与数据库连接的图书馆管理系统

<%@page contentType="text/html;charset=gbk" %><style type="text/css">
<!--
body {
	background-image: url();
	background-color: #FFCCFF;
}
.STYLE1 {
	font-size: large;
	font-weight: bold;
}
.STYLE2 {font-size: medium}
-->
</style>
<%@page import="java.sql.*" %>
<%
/*
  String sidcustomer=request.getParameter("idcustomer");
	String  idcustomer=new String(sidcustomer.getBytes("iso-8859-1"));  
	*/
	 String idcustomer=request.getParameter("idcustomer");        
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/booksystem/db/bs.mdb;");
	Statement sql=con.createStatement();
	ResultSet rs=sql.executeQuery("select * from customers where idcustomer='"+idcustomer+"' ");
	
	if(rs.next()){
	
	out.print("个人信息如下: ");
	out.print("<table border>");
	out.print("<tr>");
	out.print("<th width=72>用户编号</td>");
  out.print("<th width=72>用户名称</td>");
  out.print("<th width=50>密码</td>");
  out.print("<th width=50>密码</td>");
	out.print("<th width=50>电话</td>");
	out.print("<th width=50>email</td>");   
  out.print("<th width=62>省份</td>");
  out.print("<th width=50>城市</td>");   
  out.print("<th width=50>zip</td>");
  out.print("<th width=50>地址</td>");
  out.print("<th width=50>次数</td>");
  
	out.print("</tr>");
	}
	Statement sql2=con.createStatement();
	ResultSet rs2=sql2.executeQuery("select * from customers where idcustomer='"+idcustomer+"' ");
	while(rs2.next())
	{
	
	String a,b,c,d,f,g,h,i,j;
	int e,k;
	out.print("<tr>");	
	a=rs.getString(1);
	out.print("<td>"+a+"</td>");
	b=rs.getString(2);
	out.print("<td>"+b+"</td>");
	c=rs.getString(3);
	out.print("<td>"+c+"</td>");
	d=rs.getString(4);
	out.print("<td>"+d+"</td>");
	e=rs.getInt(5);
	out.print("<td>"+e+"</td>");
	f=rs.getString(6);
	out.print("<td>"+f+"</td>");
	g=rs.getString(7);
	out.print("<td>"+g+"</td>");
	h=rs.getString(8);
	out.print("<td>"+h+"</td>");
	i=rs.getString(9);
	out.print("<td>"+i+"</td>");
	j=rs.getString(10);
	out.print("<td>"+j+"</td>");
	k=rs.getInt(11);
	out.print("<td>"+k+"</td>");
	out.print("</tr>");

	}

	%>