相關文檔鏈接
源碼文檔下載

Demo01

import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; public class Demo01 {public static void main(String[] args) {//獲取連接try (Connection conn = DBUtils.getConn();) {//創建SQL執行對象Statement stat = conn.createStatement();//執行SQLString sql = "select ename from emp";ResultSet rs = stat.executeQuery(sql);while(rs.next()) {String name = rs.getString("ename");System.out.println(name);}} catch (Exception e) {e.printStackTrace();}} }

Demo02

import java.io.IOException; import java.io.InputStream; import java.util.Properties;public class Demo02 {public static void main(String[] args) throws IOException {//創建讀取配置文件數據的對象Properties p = new Properties();//獲取文件流InputStream ips = Demo02.class.getClassLoader().getResourceAsStream("jdbc.properties");//把文件加載到屬性對象中p.load(ips);//讀取數據String name = p.getProperty("name");String age = p.getProperty("age");System.out.println(name+":"+age);} }

Demo03

import java.sql.Connection; import java.sql.SQLException;import org.apache.commons.dbcp.BasicDataSource;public class Demo03 {public static void main(String[] args) throws SQLException {//創建數據庫連接池對象BasicDataSource ds = new BasicDataSource();//設置數據庫連接信息ds.setDriverClassName("com.mysql.jdbc.Driver");ds.setUrl("jdbc:mysql://localhost:3306/newdb3");ds.setUsername("root");ds.setPassword("root");//設置初始連接數量ds.setInitialSize(3);//設置最大連接數量ds.setMaxActive(5);//從連接池中獲取連接 拋異常Connection conn = ds.getConnection();System.out.println(conn);} }

Demo04

import java.sql.Connection; import java.sql.Statement; import java.util.Scanner;public class Demo04 {public static void main(String[] args) {Scanner s = new Scanner(System.in);System.out.println("請輸入用戶名");String username = s.nextLine();System.out.println("請輸入密碼");String password = s.nextLine();//獲取連接try (Connection conn = DBUtils.getConn();) {Statement stat = conn.createStatement();String sql = "select count(*) from user "+ "where username='"+username+"' and password='"+password+"'";//輸出后在終端中測試System.out.println(sql);} catch (Exception e) {e.printStackTrace();}} }

DBUtils

package com.example.demo;import java.io.InputStream; import java.sql.Connection; import java.sql.SQLException; import java.util.Properties;import org.apache.commons.dbcp.BasicDataSource;public class DBUtils {//創建DBCP連接池.BasicDataSource用池來管理Connectionprivate static BasicDataSource ds;static {//創建讀取配置文件數據對象Properties p=new Properties();//獲取文件流InputStream ips=DBUtils.class.getResourceAsStream("application.yaml");try {//把文件加載到屬性對象中p.load(ips);} catch (Exception e) {//異常打印堆棧跟蹤e.printStackTrace();}String driver=p.getProperty("driver");String url=p.getProperty("url");String username=p.getProperty("username");String password=p.getProperty("password");//創建數據庫連接對象,ds=new BasicDataSource();//設置數據庫連接信息ds.setDriverClassName(driver);ds.setUrl(url);ds.setUsername(username);ds.setPassword(password);//設置數據庫連接數量ds.setInitialSize(5);//設置最大連接數量ds.setMaxActive(100);}public static Connection getConn() throws Exception {Connection conn=ds.getConnection();return conn;} }

總結

以上是生活随笔為你收集整理的springboot:记录jdbc的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。