工具类:
import java.sql.Connection;
import java.sql.DriverManager;
/*
1.导入jar包
2.创建jdbc类
3.设置数据库信息
4.注册driver
5.返回
*/
public class jdbc {
String name = "链接名";
String pwd = "密码";
String url = "jdbc:mysql://127.0.0.1:3306/数据库名";
String driver = "com.mysql.jdbc.Driver";
public Connection getConn(){
try{
//注册driver地址
Class.forName(driver);
//链接数据库
Connection conn = DriverManager.getConnection(url, name, pwd);
return conn;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
}
测试类:可以用泛型数据结构存储
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Main {
public static void main(String[] args) {
jdbc jdbc = new jdbc();
//链接jdbc
Connection conn = jdbc.getConn();
//sql语句
String sql = "select * from user";
try {
//预处理sql语句
PreparedStatement ps = conn.prepareStatement(sql);
//变量赋值,where ? 号
//ps.setInt(1, 1);
//执行sql/查询用executeQuery(),增删改用
ResultSet rs = ps.executeQuery();ps.executeUpdate();
//遍历
while(rs.next()){
//第一个数据是int类型
System.out.println(rs.getInt(1));
//第二个数据是varchar类型
System.out.println(rs.getString(2));
}
} catch (Exception e) {
e.printStackTrace();
}
}
}