数据库连接步骤：
步骤一：加载jdbc程序步骤二：建立与数据库的连接，并得到连接对象Connection步骤三：在程序中编写sql步骤四：执行sql步骤五：处理结果集步骤六：断开与数据库的连接
代码示例
package com.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import oracle.jdbc.driver.OracleDriver;
public class DataBase {
private final static String driver =
"oracle.jdbc.driver.OracleDriver";
private final static String url =
"jdbc:oracle:thin:@127.0.0.1:1521:orcl";
private final static String username =
"scott";
private final static String password =
"lzqlzq";
protected Connection con =
null;
public void getcon() {
try {
Class.forName(driver);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
con = DriverManager.getConnection(url,username,password);
}
catch (SQLException e) {
e.printStackTrace();
}
System.out.println(con);
}
public static void main(String[] args) {
DataBase db =
new DataBase();
db.getcon();
}
}
转载请注明原文地址: https://ju.6miu.com/read-668018.html
