步骤一:安装mysql,可以去官方下载http://www.mysql.com,点击download,然后点击MySQL Community Downloads,可以下载MySQL on Windows(Installer & Tools),并设置好用户名和密码(root,111111)以及端口号(默认是3306)
步骤二:下载mysql数据库驱动,本人下载的是mysql-connector-java-5.1.26-bin.jar
步骤三:创建javaproject,在项目根目录下新建一个lib文件夹,该文件夹与文件夹src和文件夹JRE System Library [JavaSE-1.7]同级,然后将上面下载的驱动拷贝到该lib文件夹下面,然后右键点击lib文件夹下的mysql-connector-java-5.1.26-bin.jar,在右键弹出的菜单中选择BuildPath,进一步选择Add to Build Path.就看到与文件夹src和文件夹JRE System Library [JavaSE-1.7]同级的下面多了mysql-connector-java-5.1.26-bin.jar
步骤四:在src文件夹下面创建一个class文件,具体内容如下:
package jadbcdemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "111111");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String sql="select * from xxj2";
try {
Statement stmt = conn.createStatement();
ResultSet rs= stmt.executeQuery(sql);
while(rs.next())
{
String name = rs.getString(1);
String addr = rs.getString(2);
System.out.println(name + ":" + addr);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
if(conn!=null)
{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
步骤五:在上面代码上 右键执行Run As -->Java Application,在控制台可以看到输出:
张三:北京
李四:广西
可以直接到mysql中直接查询与上面结果一致。