image3.jsp

一本jsp自学教材

<%@ page contentType="text/html;charset=gb2312"%>   
<%@ page import="java.sql.*"   %>   
<%@ page import="java.util.*"%>    
<%@ page import="java.text.*"%>   
<%@ page import="java.io.*"%>   
<%
 
  String name=request.getParameter("name");
  name=new String(name.getBytes("ISO-8859-1"));
  String driverName="com.mysql.jdbc.Driver";
  String username="root";
  String password="yesterdayn";
  String dbName="study";
  String tableName="roles";
 try{ 
  Class.forName("com.mysql.jdbc.Driver");
  //建立同数据库的连接对象
  String url="jdbc:mysql://localhost/"+dbName+"?characterEncoding=GBK";
  Connection conn=DriverManager.getConnection(url,username,password);
  String sql="SELECT * FROM "+tableName+" WHERE name='"+name+"'";     
  Statement stmt=null;   
  ResultSet rs=null;   
  stmt=conn.createStatement();   
  rs=stmt.executeQuery(sql);
  if(rs.next())
  {  
   out.print("人物:"+rs.getString(2)+"<BR>");
   out.print("简介:"+rs.getString(3)+"<BR>");
   out.print("<IMG width=300 height=400 src='image4.jsp?id="+rs.getString("id")+"'/>");
  } 
  else
  {
    out.print("图片无法显示.");
  }  
}
catch(Exception e)
{
 out.println(e.toString());
}   
%>