<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%><html>
<head>
</head>
<body>
<% String id=request.getParameter("id");id = new String(id.getBytes("ISO8859_1"),"gb2312");%>
<%=id%>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost:3306/paper?useUnicode=true&characterEncoding=gbk";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql = "select * from student where sname='"+id+"'";
ResultSet rs=stmt.executeQuery(sql);
String sql2="";
sql2 = rs.getString(4);%>
<input type ="text" name = "textname" value = "<%=sql2%>"><br> <br>
<%rs.close();
stmt.close();
conn.close();
%><input type ="text" name = "textname" value = "<%=sql2%>"><br> <br>
</body>
</html>
<%@ page language="java" import="java.sql.*"%><html>
<head>
</head>
<body>
<% String id=request.getParameter("id");id = new String(id.getBytes("ISO8859_1"),"gb2312");%>
<%=id%>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost:3306/paper?useUnicode=true&characterEncoding=gbk";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql = "select * from student where sname='"+id+"'";
ResultSet rs=stmt.executeQuery(sql);
String sql2="";
sql2 = rs.getString(4);%>
<input type ="text" name = "textname" value = "<%=sql2%>"><br> <br>
<%rs.close();
stmt.close();
conn.close();
%><input type ="text" name = "textname" value = "<%=sql2%>"><br> <br>
</body>
</html>
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Before start of result set
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.text_jsp._jspService(org.apache.jsp.text_jsp:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: Before start of result set
com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:5044)
com.mysql.jdbc.ResultSet.getString(ResultSet.java:2057)
org.apache.jsp.text_jsp._jspService(org.apache.jsp.text_jsp:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
sql2 = rs.getString(4);%>
==========
String sql2="";
if (rs.next()) {
sql2 = rs.getString(4);%>
}