```java
package com.atguigu.maven;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.junit.Test;
import java.sql.*;
import java.util.*;
public class HelloTest {
@Test
public void Jdbc() throws Exception {
/*
jdbc连接数据库
1.创建连接
Connection connection=Jdbvtool.getconntion()
2.写sql语句==》int result=conntion.update("SQL语句,替换问号,")
3.getconnction
先创建一个properties的文件,保存数据库的地址,密码,用户名,Driver
然后使用获取
*/
//方式一
Driver driver = new com.mysql.jdbc.Driver();
// Class.forName("com.mysql.jdbc.Driver");
Properties p = new Properties();
p.setProperty("user", "root");
p.setProperty("password", "123321");
String url = "jdbc:mysql://localhost:3306/myemployees";
Connection connection = driver.connect(url, p);
PreparedStatement ps = connection.prepareStatement("insert Student(id,name) set value(?,?)");
ps.setInt(1, 2);
ps.setString(2, "zhansan");
ps.executeUpdate();
ps.close();
connection.close();
//方式二
Class.forName("com.mysql.jdbc.Driver");
Connection connection1 = DriverManager.getConnection("jdbc:mysql://localhost:3306/myemployees",
"root", "123321");
PreparedStatement ps2 = connection1.prepareStatement("insert Student(id,name) set value(?,?)");
ps.setInt(1, 2);
ps.setString(2, "zhansan");
ps.executeUpdate();
ps.close();
connection.close();
}
@Test
public void method() throws SQLException {
QueryRunner queryRunner = new QueryRunner();
int result=queryRunner.update(
DriverManager.getConnection("jdbc:mysql://localhost:3306/myemployees",
"root", "123321"),
"insert into Student(id,name) value(?,?)",
2, "zhangsan");
System.out.println(result);
}
@Test
public void method2() throws SQLException {
QueryRunner queryRunner = new QueryRunner();
List<Student> student=queryRunner.query(
DriverManager.getConnection("jdbc:mysql://localhost:3306/myemployees",
"root", "123321"),
"select name,id from Student",
new BeanListHandler<Student>(Student.class));
for (Student student1 : student) {
System.out.println(student1);
}
}
}
class Student{
private int id;
private String name;
public Student() {
}
public Student(int id, String name) {
this.id = id;
this.name = name;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
@Override
public String toString() {
return id+" "+ name;
}
public void setName(String name) {
this.name = name;
}
}