链接数据库之前必须要有JDBC驱动包
我的版本是 mysql-connector-java-5.1.39-bin.jar
附下载链接:https://dev.mysql.com/downloads/connector/
具体导入使用的软件请自行搜索。
数据库厂商要用java连接数据库必须实现四个类:
Java.sql.Driver
Java.sql.Connection
Java.sql.Statement
Java.sql.ReslutSet
具体代码:
public class driverTest{
public static void main(String[] args){
Connection connection=null;
Statement statement=null;
ResultSet resultSet=null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//获取数据库连接
connection = (Connection) DriverManager.getConnection("jdbc:mysql:///student_score", "root", "13579");
statement = connection.createStatement();
resultSet = statement.executeQuery("select * from number");
while (resultSet.next()) {
System.out.println("ID:" + resultSet.getInt(1));
System.out.println("账号:" + resultSet.getString(2));
System.out.println("密码:" + resultSet.getString(3));
}
}catch(Exception e){
e.printStackTrace();
}finally {
releaseDB(resultSet, statement, connection);
}
}
//关闭资源方法,由内到外
public static void releaseDB(ResultSet resultSet,Statement statement,
Connection connection){
if(resultSet!=null){
try{
resultSet.close();
}catch(Exception e){
e.printStackTrace();
}
}
if(statement!=null){
try{
statement.close();
}catch(Exception e){
e.printStackTrace();
}
}
if(connection!=null){
try{
connection.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
}
我所用的数据库名为student_score,表结构: