封装代码:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class MydbDao {
Connection con=null;
Statement st=null;
public Statement mydbOpen() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");//加载数据库驱动
con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","用户名","密码");
st=con.createStatement();
System.out.println("连接成功!");
}catch(Exception e) {
e.printStackTrace();
}
return st;
}
public void mydbClose() {
try {
st.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
应用操作数据:
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;
public class ConnectJDBC {
public void show() {
MydbDao db = new MydbDao();
Scanner sc=new Scanner(System.in);