最近在学习数据库开发的一些实例,这里浅谈一下用JDBC连接数据库MySQL(当然也可以连接SQL Sever或Oracle了,只是我更喜欢开源软件,同时也更简单)。
首先正确安装好MySQL,建立好数据库studentinfo
mysql>create database studentinfo;
然后编写java代码,ConnectToMySQL.java
import java.sql.*;
public class ConnectToMySQL {
public static Connection getConnection() throws SQLException ,
java.lang.ClassNotFoundException{
String url = \"jdbc:mysql://localhost:3306/studentinfo\";
Class.forName(\"com.mysql.jdbc.Driver\");
String userName = \"root\";
String password = \"\";
Connection con = DriverManager.getConnection(url,userName,password);
return con;
}
public static void main(String[] args) {
try{
Connection con = getConnection();
Statement sql = con.createStatement();
sql.execute(\"drop table if exists student\");
sql.execute(\"create table student(id int not null auto_increment,name varchar(20) not
null default \'name\',math int not null default 60,primary key(id));\");
sql.execute(\"insert student values(1,\'AAA\',\'99\')\");
sql.execute(\"insert student values(2,\'BBB\',\'77\')\");
sql.execute(\"insert student values(3,\'CCC\',\'65\')\");
String query = \"select * from student\";
ResultSet result = sql.executeQuery(query);
System.out.println(\"Student表数据如下:\");
System.out.println(\"---------------------------------\");
System.out.println(\"学号\"+\" \"+\"姓名\"+\" \"+\"数学成绩\");
System.out.println(\"---------------------------------\");
int number;
String name;
String math;
while(result.next()){
number = result.getInt(\"id\");
name = result.getString(\"name\");
math = result.getString(\"math\");
System.out.println(number + \" \" + name + \" \" + math);
}
sql.close();
con.close();
}catch(java.lang.ClassNotFoundException e){
System.err.println(\"ClassNotFoundException:\" + e.getMessage());
}catch(SQLException ex){
System.err.println(\"SQLException:\" + ex.getMessage());
}
}
}
轻松搞定,一下为输出结果:
要注意的是使用MySQL数据库,需要用到对应的JDBC驱动程序mysql-connector-java-5.0.3,可以到zySQL的官方网站上下载(http://www.mysql.org)