MySQL免费数据库的下载地址:
http://dev.mysql.com/downloads/mysql/
数据连接驱动mysql-connector-java-5.1.6-bin.jar文件:
http://pan.baidu.com/s/1pJ1CuCz
一般数据库的基本操作步骤
Connection
Statement
ResultSet
1、调用Class.forName()方法加载相应的数据库驱动程序;
Class.forName("com.mysql.jdbc.Driver");
2、定义数据库的地址URL,, 用户名,密码;
String mysqlURL = "jdbc:mysql://localhost:3306/test";
String username = "root"
String password = "123456";
3、使用驱动程序类简历数据库连接;
Connection con = DriverManager.getConnection(mysqlURL, username, password);
4、创建语句对象;
不带参数:
Statement stmt = con.createStatement();
带参数:
PreparedStatement pstm = con.prepareStatement("INSERT INTO book (bookid, bookname)VALUES(?,?)");
5、执行语句;
查询累executeQuery
String sql = "SELECT * FROM book";
ResultSet rs = stmt.executeQuery(sql);
更新类executeUpdate
String sql = "Delete FROM book WHERE bookid = " + " '12' ";
int n = stmt.executeUpdate(sql);
6、对返回的结果集ResultSet对象进行处理;
String sql = “SELECT * FROM book”;
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
bookid = rs.getStrng(1);
bookname =rs.getString(2);
System.out.println(bookid +","+bookname);
}
7、关闭数据库。
rs.close();
stmt.close();
con.close();