mysql连接问题(在线等待高手!解决给高分!!) 你写的乱套了·?为什么不写在一个类中,然后用BEAN调用呢?为什么不去遵循MVC体系结构呢?咳······这样堆出来的东西谁也不愿意看……………… 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@ page import="java.sql.*"%><% out.println("test mysql database!"); try{ Class.forName("org.gjt.mm.mysql.Driver").newInstance(); }catch(Exception e){out.println("Unable to load driver.");} try{ Connection cn=DriverManager.getConnection ("jdbc:mysql://localhost/addressbook?user=root&password=root&useUnicode=true&characterEncoding=8859_1"); Statement stmt=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); ResultSet rs=stmt.executeQuery("select * from addressbook"); for (int i=1;i<20;i++){ if (rs.absolute(i)){ out.println(rs.getString(1)); out.println(rs.getString(2))); out.println(rs.getString(3))); else{break;} } rs.close(); stmt.close(); cn.close(); } catch (SQLException e) { out.println("SQLException:"+e.getMessage()); out.println("SQLState:"+e.getSQLState()); out.println("VendorError:"+e.getErrorCode()); } %>调试结果:test mysql database! SQLException:Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect SQLState:08S01 VendorError:0 <%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <html> <body> <%Class.forName("org.gjt.mm.mysql.Driver").newInstance();/*或String url ="jdbc:mysql://localhost/test?user=root&password=&useUnicode=true&characterEncoding=8859_1";Connection conn=DriverManager.getConnection(url);*/String url ="jdbc:mysql://localhost:3306/test" ; //test为你的数据库名 Connection conn= DriverManager.getConnection(url,"",""); //或Connection conn= DriverManager.getConnection(url);Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from t_temp"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) { out.println(rs.getString(1)+"<br>");}rs.close(); stmt.close(); conn.close(); %> </body> </html>将mysql数据库驱动mm.mysql-2.0.4-bin.jar这个包放到webapps\ROOT\WEB-INF\lib目录下,然后重新启动tomcat服务器就可以了。 java设置Date的json输出格式的问题 三个小问题 java.util.timer怎么设定在指定的时间执行任务? 截取点 急!!!缓存问题? 用 servlet 添加到数据库的程序 怎么没反应,为什么???? 分钟计时器。。在线等 jsp如何写一个方法 JSP的中文转换问题高分在线请教 怎么设置TOMCAT4。06的虚拟目录? 请问各位高人,如何用JNDI来配置一个数据源呢?马上给分!!! 怎样把JSP的序运行起来??
<% out.println("test mysql database!");
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}catch(Exception e){out.println("Unable to load driver.");}
try{
Connection cn=DriverManager.getConnection ("jdbc:mysql://localhost/addressbook?user=root&password=root&useUnicode=true&characterEncoding=8859_1");
Statement stmt=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("select * from addressbook");
for (int i=1;i<20;i++){
if (rs.absolute(i)){
out.println(rs.getString(1));
out.println(rs.getString(2)));
out.println(rs.getString(3)));
else{break;}
}
rs.close();
stmt.close();
cn.close();
}
catch (SQLException e)
{
out.println("SQLException:"+e.getMessage());
out.println("SQLState:"+e.getSQLState());
out.println("VendorError:"+e.getErrorCode());
}
%>
调试结果:
test mysql database! SQLException:Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect SQLState:08S01 VendorError:0
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
/*或String url ="jdbc:mysql://localhost/test?user=root&password=&useUnicode=true&characterEncoding=8859_1";
Connection conn=DriverManager.getConnection(url);
*/
String url ="jdbc:mysql://localhost:3306/test" ; //test为你的数据库名
Connection conn= DriverManager.getConnection(url,"",""); //或Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from t_temp";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
out.println(rs.getString(1)+"<br>");
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
将mysql数据库驱动mm.mysql-2.0.4-bin.jar这个包放到webapps\ROOT\WEB-INF\lib目录下,然后重新启动tomcat服务器就可以了。