sql.jsp

来自「J2EE独立开发制作」· JSP 代码 · 共 51 行

<%@ page import="java.sql.*" %> 
<%@ page import="java.util.*"%> 
<%@ page contentType="text/html;charset=GBK" %>

<% 
out.println("读取mysql中中文信息！"); 
try { 
Class.forName("com.mysql.jdbc.Driver").newInstance(); 
} 

catch (Exception E) { 
out.println("Unable to load driver."); 
} 

try { 
Connection C = DriverManager.getConnection("jdbc:mysql://localhost:3306/murach?user=root&password=sun&useUnicode=true&characterEncoding=ISO-8859-1");
Statement s=C.createStatement(); 
ResultSet rs=s.executeQuery("select * from User"); 
out.println("<table border=1>"); 
int i=1; 
for (i=1;i<20;i++) 
{ 
if (rs.absolute(i)) 
{ 
out.println("<tr>");
out.println("<td>"); 
out.print(rs.getString(2)); 
out.println("</td>"); 
out.println("<td>"); 
out.print(rs.getString(3)); 
out.println("</td></tr>"); 
} 
else 
{ 
break; 
} 

} 
out.println("</table>"); 
rs.close(); 
s.close(); 
C.close(); 

} 
catch (SQLException E) { 
out.println("SQLException: " + E.getMessage()); 
out.println("SQLState: " + E.getSQLState()); 
out.println("VendorError: " + E.getErrorCode()); 
} 
%>