首先,MySQL肯定是要安装的,然后呢,下载一个关键驱动:mysql-connector-java-5.1.20-bin.jar;
注意要在程序里面,把这个库引用进来:
import java.sql.*;
public class Main {
/**
* @author ZJC
* Java连接MySQL示例
*/
//mysql配置时的用户名
static String userName = "root";
//mysql配置时的密码
static String Password = "643872dx";
private static String driverName = "com.mysql.jdbc.Driver";
//url指向要访问的数据库名mydb
static private String url = "jdbc:mysql://127.0.0.1:3306/mydb";
static Connection dbConn;
public static void main(String[] args) {
// TODO Auto-generated method stub
System.out.println("dwfewf");
Connection temp = OpenDB();
}
static Connection OpenDB()
{
try
{
//加载驱动程序
Class.forName(driverName);
dbConn = DriverManager.getConnection(url,userName,Password);
if(!dbConn.isClosed())
System.out.println("success!");
// statement用来执行SQL语句
Statement statement = dbConn.createStatement();
// 要执行的SQL语句
ResultSet rs = statement.executeQuery("select * from mydb");
System.out.println("dqd");
while(rs.next())
{
System.out.println(rs.getString("id"));
}
System.out.println("dhwed");
//数据库切换
rs = statement.executeQuery("use test_navi");
rs = statement.executeQuery("select * from test_navi");
while(rs.next())
{
System.out.println(rs.getString("attack"));
}
}
catch(Exception e)
{
System.out.print(e);
}
return dbConn;
}
}
运行结果: