package com.java1234.util;
import java.sql.Connection;
import java.sql.DriverManager;
/**
* 数据库工具类
*/
public class DBUtil {
private String dbUrl ="jdbc:mysql://localhost:3306/wuye?useSSL=false"; //数据库连接地址
private String dbUseName = "root"; //用户名
private String dbPassword = "111111"; //密码
private String jdbcName = "com.mysql.cj.jdbc.Driver"; //驱动名称
/**
* 获取数据库连接
* @return
* @throws Exception
*/
public Connection getCon()throws Exception{
Class.forName(jdbcName);
Connection con = DriverManager.getConnection(dbUrl,dbUseName,dbPassword);
return con;
}
/**
* 关闭数据库连接
* @param con
* @throws Exception
*/
public void closeCon(Connection con)throws Exception{
if(con!=null){
con.close();
}
}
public static void main(String[] args){
DBUtil dbUtil = new DBUtil();
try {
dbUtil.getCon();
System.out.println("数据库连接成功!");
} catch (Exception e) {
e.printStackTrace();
System.out.println("数据库连接失败!");
}
}
}
连接数据库,可验证数据库是否连接成功 ,需修改自己的用户名和密码
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Timestamp;
import java.util.Date;
import javax.swing.JOptionPane;
import com.java1234.util.DBUtil;
public class time {
private Date date ;
private DBUtil dbUtil;
private Timestamp timestamp ;
public time() {
super();
}
public time(Date date,Timestamp timestamp) {
this.date=date;
this.timestamp=timestamp;
}
public Date getDate() {
return date;
}
public void setDate(Date date) {
this.date = date;
}
public Timestamp getTimestamp() {
return timestamp;
}
public void setTimestamp(Timestamp timestamp) {
this.timestamp = timestamp;
}
public int add(Connection con,time t)throws Exception{
String times;
String sql="insert into t_time values(null,?)";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setTimestamp(1,timestamp);
return pstmt.executeUpdate();
}
private void timeadd(time t) {
dbUtil=new DBUtil();
Connection con=null;
try {
con = dbUtil.getCon();
int n = t.add(con,t);
if(n==1) {
JOptionPane.showMessageDialog(null,"添加成功!");
}else {
JOptionPane.showMessageDialog(null,"添加失败!");
}
}catch(Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null,"添加失败!");
}
}
public static void main(String args[]) {
Date date = new Date();
Timestamp timestamp = new Timestamp(date.getTime());
time t=new time (date,timestamp);
t.timeadd(t);
}
}
获取系统时间并写入数据库中