[大数据]主方法操作数据库【简单版】

主方法操作数据库【简单版】

public class JDBCDemo {
    private static final String DATABASE_DRIVER = "com.mysql.jdbc.Driver" ;//Oracle为oracle.jdbc.driver.OracleDriver
    private static final String DATABASE_URL = "jdbc:mysql://192.168.56.10:3306/gulimall_pms?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai" ;
    private static final String DATABASE_USER = "root" ;
    private static final String DATABASE_PASSWORD = "root" ;
    public static void main(String[] args) throws Exception{
        Class.forName(DATABASE_DRIVER);
        Connection  connection = DriverManager.getConnection(DATABASE_URL,DATABASE_USER,DATABASE_PASSWORD);
        String sql = "INSERT INTO user(id,name,age,email) VALUES (?,?,?,?)";
            PreparedStatement pstmt = connection.prepareStatement(sql);
            pstmt.setInt(1,1);
            pstmt.setString(2,"张三");
            pstmt.setInt(3,18);
            pstmt.setString(4, UUID.randomUUID()+"@qq.com");
            System.out.println(pstmt.execute());
    }
}
/**
 spring:
 datasource:
 username: root
 password: root
 url: jdbc:mysql://192.168.56.10:3306/gulimall_pms?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
 driver-class-name: com.mysql.jdbc.Driver
 */