连接之前,先下载驱动mysql-connector-java-3.1.12.zip,解压把其中的mysql-connector-java-3.1.12-bin.jar加入到项目中。见下图:
首先在MySql中建立数据库mydatabase,和表friends,字段有fid,fname。然后编写以下程序:
import java.sql.*;
public class DBConn ...{
public static void main(String[] args) ...{
String driver = "com.mysql.jdbc.Driver"; //驱动
String url = "jdbc:MySql://localhost/mydatabase"; //数据库URL
String user = "root"; //数据库登陆名
String password = "admin"; //数据库密码
try ...{
Class.forName(driver);
Connection dcon = DriverManager.getConnection(url, user,password);
String sql = "select * from friends;";
Statement stmt = dcon.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) ...{
System.out.println("id:"+rs.getInt("fid")+",姓名:"+rs.getString("fname"));
}
} catch (Exception e) ...{
e.printStackTrace();
}
}
}
如果数据库中没有数据,则可以用以下代码:
import java.sql.*;
public class DBConn ...{
public static void main(String[] args) ...{
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:MySql://localhost/mydatabase";
String user = "root";
String password = "admin";
try ...{
Class.forName(driver);
Connection con = DriverManager.getConnection(url, user, password);
String insert = "insert into friends(fid,fname) values(?,?)";
PreparedStatement prestatement = con.prepareStatement(insert);
String[] names = ...{ "Rachel", "Rose", "Phoebe", "Monica","Chandler", "Joey" };
for (int i = 0; i < 6; i++) ...{
prestatement.setInt(1, i+1);
prestatement.setString(2, names[i]);
prestatement.execute();
}
String query = "select * from friends";
ResultSet result = prestatement.executeQuery(query);
System.out.println("The Results is:");
while (result.next()) ...{
System.out.println(result.getString("fname"));
}
con.close();
} catch (SQLException e) ...{
e.printStackTrace();
} catch (ClassNotFoundException e) ...{
e.printStackTrace();
}
}
}
如果不能运行成功,先检查下是不是驱动包倒入错了。一定要先解压把其中的Jar文件倒入。我开始时把下载的驱动包没解压直接以ZIP文件倒入了。结果出现以下错误。
java.lang.ClassNotFoundException: com.MySql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at DBConn.main(DBConn.java:13)