java jdbc增删改监听_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);

driver = properties.getProperty("driver");

url = properties.getProperty("url");

username = properties.getProperty("username");

password = properties.getProperty("password");

// 加载驱动

Class.forName(driver);

} catch (IOException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

/**

* 获取数据库连接

* @throws SQLException

*/

public static Connection getConnection() {

try {

return DriverManager.getConnection(url, username, password);

} catch (SQLException e) {

e.printStackTrace();<