public static void main(String[] args) {
String url = "";
String username = "";
String password = "";
//1.注册驱动
Class.forName("dm.jdbc.driver.JdbcDriver");
//2.创建连接
Connection connection = DriverManager.getConnection(url, username, password);
//3.创建执行对象
Statement statement = connection.createStatement();
//4.执行sql 获取结果
String sql = "select * from A";
ResultSet resultSet = statement.executeQuery(sql);
//5.操作数据
while (resultSet.next()){
String a = resultSet.getString("字段名A");
}
//6.关闭连接
resultSet.close();
statement.close();
connection.close();
}
驱动可以是mysql、oracle、达梦等数据库
oracle驱动:oracle.jdbc.driver.OracleDriver
达梦数据库驱动: dm.jdbc.driver.DmDriver
url含义:连接地址 例如:localhost:3306//数据库名
username:数据库账号
password:数据库密码