做web项目的时候需要上传图片到数据库学习了下
package picturetest;
/**
*
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* @author Administrator
*
*/
public class DBUtil
{
// 定义数据库连接参数
public static final String DRIVER_CLASS_NAME = "com.mysql.cj.jdbc.Driver";
public static final String URL = "jdbc:mysql://localhost:3306/pictest?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true";
public static final String USERNAME = "root";
public static final String PASSWORD = "root";
// 注册数据库驱动
static
{
try
{
Class.forName(DRIVER_CLASS_NAME);
}
catch (ClassNotFoundException e)
{
System.out.println("注册失败!");
e.printStackTrace();
}
}
// 获取连接
public static Connection getConn() throws SQLException
{
return DriverManager.getConnection(URL, USERNAME, PASSWORD);
}
// 关闭连接
public static void closeConn(Connection conn)
{
if (null != conn)
{
try
{
conn.close();
}
catch (SQLException e)
{
System.out.pr