JAVA JDBC 增删改查简单例子

1、数据库配置文件jdbc.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
username=root
password=

2、数据库数据类JdbcUtils

package com.test;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JdbcUtils {
	private static String driver = null;
    private static String url = null;
    private static String username = null;
    private static String password = null;
    // 加载驱动，获取数据库连接信息
    static {
        try {
            // 加载配置文件
            InputStream in = JdbcUtils.class.getClassLoader().getResourceAsStream("DB.properties");
            Properties properties = new Properties();
            properties.load(in);