创建mysql对象_mysql创建statement对象

mysql创建statement对象

关注:56  答案:4  mip版

解决时间 2021-01-24 21:05

提问者西伯利亚狼

2021-01-24 13:31

package com.yxq.toolsbean;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DB {

private final String url = "jdbc:mysql://localhost:3306/mysql";

private final String userName = "root";

private final String password = "";

private Connection conn = null;

private Statement stm=null;

public DB(){

try {

Class.forName("com.mysql.jdbc.Driver");

System.out.println("加载数据库成功！");

} catch (Exception e) {

e.printStackTrace();

System.out.println("加载数据库驱动失败！");

}

}

public void createCon() {

try {

Connection conn = DriverManager.getConnection(url, userName, password);

System.out.println("获取数据库连接成功！");

} catch (Exception e) {

e.printStackTrace();

System.out.println("获取数据库连接失败ÿ