1、准备工作
a、java运行环境(以eclipse为例)
b、下载mysql支持jdbc的jar包(http://dev.mysql.com/downloads/connector/j/)
c、mysql数据库(我以Navicat集成环境的mysql为例)
2、首先下载了jar包后将其导入进去
博主懒就不给一步步演示了自行去http://jingyan.baidu.com/article/ca41422fc76c4a1eae99ed9f.html看看吧讲的很详细。
3、接下来就是创建表了(以它为例)
4、接下来是时候写代码了
import java.sql.*;
public class DbTest {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String DBDriver = "com.mysql.jdbc.Driver";
String connectionStr = "URL";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
Class.forName(DBDriver);
con = DriverManager.getConnection(connectionStr,"username","password");
stmt = con.createStatement();
rs = stmt.executeQuery("select * from test_awards");
while(rs.next()){
System.out.println(rs.getString("stu_nbr")+"");
System.out.println(rs.getInt("stu_awards")+"");
}
con.close();
}
}
5、看效果