发个以前写的测试用的程序,mysql可以使用本地匿名登陆,所以没有用户名密码之类的东西
// Test.javaimport java.sql.*;public class MySQL
{
public static void main(String[] args)
{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sDBName = "Mud";
try
{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Find MySQL Driver OK");
System.out.println("Get Connection ["+sDBName+"]");
conn = DriverManager.getConnection("jdbc:mysql:///"+sDBName);
System.out.println("Create Statement");
stmt = conn.createStatement();
System.out.println("Query");
rs = stmt.executeQuery("Select * from Account");
int i = 0;
System.out.println("Start Show ResultSet");
while (rs.next())
{
System.out.println(i+" : "+rs.getInt(1));
i++;
}
System.out.println("End Show ResultSet");
}
catch(Exception e)
{
System.out.println("Error");
}
finally
{
if(conn != null)
{
try
{
conn.close();
System.out.println("Close Connection OK");
}
catch(Exception e)
{
System.out.println("Close Connection Error");
}
}
}
}
}
// Test.javaimport java.sql.*;public class MySQL
{
public static void main(String[] args)
{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sDBName = "Mud";
try
{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Find MySQL Driver OK");
System.out.println("Get Connection ["+sDBName+"]");
conn = DriverManager.getConnection("jdbc:mysql:///"+sDBName);
System.out.println("Create Statement");
stmt = conn.createStatement();
System.out.println("Query");
rs = stmt.executeQuery("Select * from Account");
int i = 0;
System.out.println("Start Show ResultSet");
while (rs.next())
{
System.out.println(i+" : "+rs.getInt(1));
i++;
}
System.out.println("End Show ResultSet");
}
catch(Exception e)
{
System.out.println("Error");
}
finally
{
if(conn != null)
{
try
{
conn.close();
System.out.println("Close Connection OK");
}
catch(Exception e)
{
System.out.println("Close Connection Error");
}
}
}
}
}
解决方案 »
- 序列生成器怎么创建的?(急急急急急急!!)
- Mac OS 下Navicat 导入导出sql闪退的问题
- 急求解决mysql无法远程连接问题ERROR 2003 (HY000): Can't connect to MySQL server on '202.99.67
- 求一条sql语句(在线等)
- 你们觉得QQ群有用嘛?
- linux中mysql客户端编写时,打开多个表后,只对最后一个表写入有效
- 环境linux 8.0安装MYSQL出错,在线等,急!!!!!
- Message : Duplicate entry 'dfwztj' for key 'PRIMARY' 帮我看看这个怎么解决
- mysql查询缓存命中率多少适合开启Query_cache?
- mysql如何计算单词中某个字母的个数
- 安装Postgresql8 For Win后,怎么管理工具不能连接数据库,需要密码?
- 高手们请进来看看,mysql见表
-->
jdbc:mysql://localhost/mysql:3306?user=root&password=153157
再试试
http://mascotzhuang.go.nease.net/document/experience/MYSQLconnection.htm