首先需要一个jdbc连接数据库的jar,点我下载
本文主要介绍如何使用jdbc连接以及获取到数据库的数据:
- 首先将下载的jar(如果没有),在configure build path当中将jdbc 的jdr添加进去
- 具体实现,定义要连接的数据库的路径,用户名以及密码
- 使用“Class.forName(“com.mysql.jdbc.Driver”);”实例化Driver的类,相当于是初始化,必不可少的
- 再使用语句“conn = DriverManager.getConnection(connectString, user, pass);”就可以连接了,由于可能会出现异常(连接失败),因此必须配合try catch语句使用,不然会报错
- 在获取数据库数据时,使用语句“stat = conn.createStatement(); “来获取执行sql语句的对象,然后再使用 ”rs = stat.executeQuery(sqlSentence); “执行sql查询,返回结果集
- 可能需要导入的包名:import =”java.util.ArrayList,java.sql.Connection,java.sql.DriverManager,java.sql.Statement,java.util.Scanner,java.sql.*
static Connection conn;
ArrayList<Student> getData(){
ArrayList<Student> ArrayStu = new ArrayList<Student>();
String connectString = "jdbc:mysql://IP:3306/test"
+ "?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8";
String user ="user";
String pass="123456";
boolean getFetch = false;
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(connectString, user, pass);
getFetch = true;
}catch(Exception e){
System.out.println(e.getMessage());
}
if(getFetch){
try{
ResultSet rs= null;
String sql = "select *from stu order by num";
rs = executeQuery(sql);
while(rs.next()){
String id = rs.getString("id");
String num = rs.getString("num");
String name = rs.getString("name");
Student student = new Student(id,num,name);
ArrayStu.add(student);
}
}catch(Exception e){
System.out.println(e.getMessage());
}
}
return ArrayStu;
}
static private ResultSet executeQuery(String sqlSentence) {
Statement stat;
ResultSet rs = null;
try {
stat = conn.createStatement(); //获取执行sql语句的对象
rs = stat.executeQuery(sqlSentence); //执行sql查询,返回结果集
} catch (Exception e) {
System.out.println(e.getMessage());
}
return rs;
}
class Student{
private String id;
private String num;
private String name;
String getID(){
return this.id;
}
String getNum(){
return this.num;
}
String getName(){
return this.name;
}
Student(String id, String num, String name){
this.id = id;
this.num = num;
this.name = name;
}
}