回复驱动的问题:到 mysql.org 下载驱动JDBC2.0 for MySQL 文件名是 mm.mysql-2.0.4-bin.jar地址: http://www.mysql.com/downloads/download.php?file=Downloads/Contrib/mm.mysql-2.0.4-bin.jar放到Resin or Tomcat的lib目录里
我用了上面的方法,结果却是这样 Class.forName ("org.gjt.mm.mysql.Driver").newInstance(); conn= java.sql.DriverManager.getConnection ("jdbc:mysql://"+host+"/"+database,user,pass); stmt=conn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY); 执行到第二句就出现了下面的异常java.sql.SQLException: Communication link failure: java.net.SocketException at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:370) at org.gjt.mm.mysql.Connection.connectionInit Connection.java:261) …………
我用了上面的方法,结果却是这样 Class.forName ("org.gjt.mm.mysql.Driver").newInstance(); conn= java.sql.DriverManager.getConnection ("jdbc:mysql://"+host+"/"+database,user,pass); stmt=conn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY); 执行到第二句就出现了下面的异常java.sql.SQLException: Communication link failure: java.net.SocketException at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:370) at org.gjt.mm.mysql.Connection.connectionInit Connection.java:261) …………
String conn="jdbc:odbc:jspdata";
connection sql=DriverManager.getConnection(Con);
Statement Stmt=sql.createStatement();
给分!
Class.forName("org.gjt.mm.mysql.Driver");
String conn="jdbc:mysql:jspdata";
connection sql=DriverManager.getConnection(Con);
Statement Stmt=sql.createStatement();
你必须拷mysqlodbc中的org目录到\tomcat\webapps\ROOT\WEB-INF\classes\下
这次该给全分啦!呵呵!
附加问题令问!呵呵!
mysqlodbc什么东西
文件名是 mm.mysql-2.0.4-bin.jar地址:
http://www.mysql.com/downloads/download.php?file=Downloads/Contrib/mm.mysql-2.0.4-bin.jar放到Resin or Tomcat的lib目录里
C:\mysql\bin> mysqladmin -u root password "你要设置的新密码"
修改:
C:\mysql\bin> mysqladmin -u root -p 旧密码 password "新密码"
基本的流程是1. 加载驱动Class.forName("org.git.mm.mysql.Driver");2. 建立连接 Connection con = DriverManager.getConnection(url,user,password)3. 操作数据Statement smt = con.createStatement();
smt.executeUpdate("Insert into xxx (,,,) values(,,,)");
...
但是在tomcat4.0不行,不知道谁知道原因?
谢!
Class.forName ("org.gjt.mm.mysql.Driver").newInstance();
conn= java.sql.DriverManager.getConnection
("jdbc:mysql://"+host+"/"+database,user,pass);
stmt=conn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
执行到第二句就出现了下面的异常java.sql.SQLException: Communication link failure: java.net.SocketException
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:370)
at org.gjt.mm.mysql.Connection.connectionInit Connection.java:261)
…………
Class.forName ("org.gjt.mm.mysql.Driver").newInstance();
conn= java.sql.DriverManager.getConnection
("jdbc:mysql://"+host+"/"+database,user,pass);
stmt=conn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
执行到第二句就出现了下面的异常java.sql.SQLException: Communication link failure: java.net.SocketException
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:370)
at org.gjt.mm.mysql.Connection.connectionInit Connection.java:261)
…………
被系统设定为CLASSPATH,所以只需设置如下:
CLASSPATH=D:\jdk1.3.1_02\lib\tools.jar;D:\jdk1.3.1_02\lib\dt.jar;.
而驱动放在Resin & Tomcat的lib目录里面就可以了.回楼上:可能你的语句有问题
Class.forName("org.gjt.mm.mysql.Driver");Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=&useUnicode=true&characterEncoding=8859_1");Statement smt=con.createStatement();
<%@page import="java.sql.*"
import ="java.util.*"
import ="java.io.*"
contentType="text/html; charset=gb2312"
%>
<html>
<head>
<title>使用MYsql数据库</title>
</head>
<body>
<%!
String host="localhost"; //数据库主机
String database="addressbook"; //数据库名
String user=""; //用户名
String pass=""; //口令
%><% java.sql.Connection sqlConn; //数据库连接对象
java.sql.Statement sqlStmt; //语句对象
java.sql.ResultSet sqlRst; //结果集对象
//登记JDBC驱动对象
Class.forName ("org.gjt.mm.mysql.Driver").newInstance ();
//连接数据库
sqlConn= java.sql.DriverManager.getConnection ("jdbc:mysql://"+host+"/"+database,user,pass);
//创建语句对象
sqlStmt=sqlConn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
//执行Sql语句
String sqlQuery="select count(*) from addressbook";
sqlRst=sqlStmt.executeQuery (sqlQuery);
sqlRst.next();
int count=sqlRst.getInt(1); //取得总的留言记录数
sqlQuery="select * from addressbook order by id desc;";
sqlRst=sqlStmt.executeQuery (sqlQuery); //执行SQL语句
%>
<table border="1" width="100%" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="0">
<tr>
<td align="center"> ID</td>
<td align="center">昵称</td>
<td align="center">性别</td>
<td align="center">地址</td>
</tr>
<% while (sqlRst.next()) { //取得下一条记录 %>
<tr>
<!--显示记录-->
<td><%=sqlRst.getString("id")%></td>
<td><%=sqlRst.getString("name")%></td>
<td><%=sqlRst.getString("address")%></td>
<td><%=sqlRst.getString("phone") %></td>
</tr>
<% } %>
</table>
</body>
<%
//关闭结果集对象
sqlRst.close();
//关闭语句对象
sqlStmt.close ();
//关闭数据库连接
sqlConn.close();
%>