<html>
<head><title>helloworld.jsp</title></head>
<body>
<%@ page language="java" import="java.sql.*" %>
<%
try{
Class.forName("org.gjt.mm.mysql.Driver");
out.println("Success loading Mysql Driver!");
}
catch(Exception e)
{
out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try{
out.println("xxxx");
Connection connect=java.sql.DriverManager.getConnection("jdbc:mysql://218.204.12.34:3306/windows?useUnicode=true&characterEncoding=gb2312","lijie","skeidjl");
out.print("Success connect Mysql server!"); Statement stmt = connect.createStatement();
ResultSet rs=stmt.executeQuery("select name from windows.users");
while(rs.next())
{ out.println(rs.getString(2)); }
}
catch(Exception e)
{
out.print("get data error!");
e.printStackTrace();
}
%></body></html>结果是success driver load 但get data error
应该是getConnection的错误,但不太明白怎么错了,请指教。
<head><title>helloworld.jsp</title></head>
<body>
<%@ page language="java" import="java.sql.*" %>
<%
try{
Class.forName("org.gjt.mm.mysql.Driver");
out.println("Success loading Mysql Driver!");
}
catch(Exception e)
{
out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try{
out.println("xxxx");
Connection connect=java.sql.DriverManager.getConnection("jdbc:mysql://218.204.12.34:3306/windows?useUnicode=true&characterEncoding=gb2312","lijie","skeidjl");
out.print("Success connect Mysql server!"); Statement stmt = connect.createStatement();
ResultSet rs=stmt.executeQuery("select name from windows.users");
while(rs.next())
{ out.println(rs.getString(2)); }
}
catch(Exception e)
{
out.print("get data error!");
e.printStackTrace();
}
%></body></html>结果是success driver load 但get data error
应该是getConnection的错误,但不太明白怎么错了,请指教。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货