1.MySQL
public class jdbcTest {
private static final String URL = "jdbc:mysql://localhost:3306/jdbc?serverTimezone=UTC&characterEncoding=utf-8&useUnicode=true";
private static final String USER = "root";
private static final String PASSWORD = "123456";
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);
String sql="select * from user";
Statement st=conn.prepareStatement(sql);
ResultSet rs=st.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3)+"\t");
}
rs.close();
st.close();
conn.close();
}
}
2.HikariDataSource
@SpringBootTest
public class DataSourceTests {
@Autowired
private DataSource dataSource;
@Test
void testGetConnection() throws SQLException {
Connection conn=dataSource.getConnection();
System.out.println("conn="+conn);
}
@Test
void testSaveNotice() throws SQLException {
Connection conn=dataSource.getConnection();
String sql="insert into user (username,password) values ('u3',666)";
Statement st=conn.prepareStatement(sql);
boolean rs= st.execute(sql);
if (rs){
System.out.println("添加失败");
}
System.out.println("添加成功");
st.close();
conn.close();
}
}