我的类是下面这样的,并且Mysql4.1已经装好了,我还可以通过[MySQL Command Line Client]登陆!
import java.sql.*;
public class ConnMysql
{
public static void main(String[] abc) throws ClassNotFoundException,SQLException,
InstantiationException,IllegalAccessException
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/3306/samp_db?user=root&password=root123&useUnicode=true&characterEncoding=8859_1";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from users where name='may'";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.println("this is a username--->"+rs.getString(1));
System.out.println("this is a userpass--->"+rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
}}
import java.sql.*;
public class ConnMysql
{
public static void main(String[] abc) throws ClassNotFoundException,SQLException,
InstantiationException,IllegalAccessException
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/3306/samp_db?user=root&password=root123&useUnicode=true&characterEncoding=8859_1";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from users where name='may'";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.println("this is a username--->"+rs.getString(1));
System.out.println("this is a userpass--->"+rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
}}
解决方案 »
- spring bean 参数注入方式的问题!
- oracle中写 '= null'会怎么处理
- getHibernateTemplate().
- servlet无法使用的问题
- 中国又有一个开源发布了
- 真地想要structs的中文资料
- 用webrowset来输出xml时有没有办法输出text image 这样的数据库字段中的数据?
- eclipse問題
- 部署Duke Bank老出错,大家帮帮看看
- <:O..zzZZZ 大仙级别的问题:如何用j2ee实现应用程序的模块化
- 在struts中,如何验证用户输入的年龄不是整数?
- [100分] 在struts中,action中scope定义成session和request,有何区别?小弟刚出道给个例子
>String url ="jdbc:mysql://localhost/3306/samp_db?>user=root&password=root123&useUnicode=true&characterEncoding=8859_1";
>String url ="jdbc:mysql://localhost:3306/samp_db?user=root&password=root123&useUnicode=true&characterEncoding=8859_1";这样呢?
Exception in thread "main" java.sql.SQLException: Communication failure during h
andshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at ConnMysql.main(ConnMysql.java:29)
这样子吧,要不就是password不对
如果在linux下就启动mysqld_safe &
或者视你的版本而言启动safe_mysqld &如果你输入mysql -u <your account> -p
********<your password>
可以进入的话,则启动了mysql服务器。
看样子好像是没有启动mysql服务器。
或者端口号不对
端口号是3306吗?
Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","123");
敢问高手,到底哪个驱动更牛一点,更好一点。
谢了
需要org和com俩个驱动都装上,我也不知道为什么,可能是版本驱动的问题。我总是喜欢最高版本,
虽然计算机配置不高!