jdbc和druid

导入mysql jar包
在当前module下new一个directory，把jar包粘贴到里面
之后右键jar包，add as Library

// 注册驱动,加载类
Class.forName("com.mysql.jdbc.Driver");

// 获取连接对象
String url = "jdbc:mysql://127.0.0.1:3306/db2";
String userName = "root";
String passWord = "";
Connection con = DriverManager.getConnection(url,userName,passWord);
String sql = "insert into study values(?,?);";//？是占位符

// 获取执行sql的对象,并执行sql
PreparedStatement sta = con.prepareStatement(sql);
sta.setString(1,"19001");
sta.setString(2,"Math");
int count = sta.executeUpdate();// 返回受影响的行数
// 释放资源
sta.close();con.close();

//Establishing SSL connection without server's identity verification is not recommended
//后面加上参数useSSL=false就好了
String url = "jdbc:mysql://127.0.0.1:3306/db2?useSSL=false";

处理事务

try{
	con.setAutoCommit(false);//开启事务
	// 执行sql
	con.commit();//提交事务
}catch(){
	con.rollback();//回滚事务
}

查询结果集

String sql = "select * from study";
Statement sta = con.createStatement();
ResultSet rs = sta.executeQuery(sql);//返回结果集
// 光标下移一行, 并且判断当前行是否有数据
while(rs.next()){
    String stno = rs.getString("stno");
    String course = rs.getString("course");
    System.out.println(stno + "," + course);
}

druid

使用这个也是要导jar包的

//配置文件druid.properties
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/db2?useSSL=false&useServerPrepStmts=true
username=root
password=
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
# 最大等待时间
maxWait=3000

//加载配置文件
Properties prop = new Properties();
prop.load(new FileInputStream("idea_test/src/druid.properties"));
DataSource dataSource = DruidDataSourceFactory.createDataSource(prop);//连接池对象
Connection conn = dataSource.getConnection();//数据库连接对象
//执行sql
String sql = "select * from study";
PreparedStatement pps = conn.prepareStatement(sql);
ResultSet resultSet = pps.executeQuery();