工具
(1)eclipse-jee-mars-R-win32-x86_64
(2)mysql-5.5.39-winx64
(3)JBDC插件:mysql-connector-java.jar
使用mysql命令行或者可视化客户端创建好database和table。
我的database名是:t1
table名是:bnutalk
用户名是root
密码是123456
新建一个Java Project
为项目添加一个lib文件夹:右键项目名->New->Folder->lib;
将mysql-connector-java.jar复制到lib下;
右键mysql-connector-java.jar->Build Path->Add to Build Path。
编写Java代码
package com.imooc.jdbc;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
public class JdbcTest {
private static final String URL="jdbc:mysql://127.0.0.1:3306/t1";
private static final String USER="root";
private static final String PASSWORD="123456";
public static void main(String[] args) throws Exception {
/*加载mysql驱动*/
Class.forName("com.mysql.jdbc.Driver");
/*获得数据库的连接*/
Connection conn=(Connection) DriverManager.getConnection(URL, USER, PASSWORD);
/*通过数据库的连接,实现增删改查*/
Statement stmt=(Statement) conn.createStatement();
/*查询数据库t1中的bnutalk table*/
ResultSet rs=(ResultSet) stmt.executeQuery("select id,age from bnutalk");
/*将查询到的信息打印到控制台*/
while(rs.next())
{
System.out.println(rs.getInt("id")+","+rs.getInt("age"));
}
}
}