这是我连接mysql数据库的一个总结。
mysql jdbc驱动下载地址:http://download.csdn.net/detail/maihilton/8094183
static Connection conn = null;
static String DBServer = "localhost"; //数据库服务器名称或IP
static String DBName = "test"; //数据库名称
static String DBUser = "root"; //数据库用户
static String DBPassword = "yourpassword"; //数据库密码
public static Connection getConnection()
{
try
{ //加载jdbc驱动
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Success loading Mysql Driver!");
//数据库连接语句
String url = "jdbc:mysql://" + DBServer + ":3306/"+ DBName;
conn = DriverManager.getConnection(url,DBUser,DBPassword);
if (conn != null)
System.out.println("数据库连接成功!");
}
catch(Exception e)
{
System.out.println("无法连接数据库!");
e.printStackTrace();
}
return conn;
}