java 链接数据库
this is test --------------------编程问答-------------------- 什么? --------------------编程问答-------------------- --------------------编程问答-------------------- 链接数据库要引入数据库驱动,自己下一个,这里给你一个链接oracle的代码import java.sql.*;--------------------编程问答-------------------- --------------------编程问答-------------------- 驱动:jdbc.basic.driverClassName=oracle.jdbc.driver.OracleDriver
public class FenYe {
public static void main(String[] args) {
Connection ct = null;
CallableStatement cs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
ct = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:yao", "scott", "tiger");
cs = ct.prepareCall("{call yao5(?,?,?,?,?,?)}");
cs.setString(1, "emp");
cs.setInt(2, 5);
cs.setInt(3, 1);
cs.registerOutParameter(4, oracle.jdbc.OracleTypes.INTEGER);
cs.registerOutParameter(5, oracle.jdbc.OracleTypes.INTEGER);
cs.registerOutParameter(6, oracle.jdbc.OracleTypes.CURSOR);
cs.execute();
int geshu = cs.getInt(4);
int yeshu = cs.getInt(5);
ResultSet ji1 = (ResultSet) cs.getObject(6);
System.out.println(geshu);
System.out.println(yeshu);
while (ji1.next()) {
System.out.println(ji1.getInt(1) + ji1.getString(2));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
cs.close();
ct.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
数据库访问地址:jdbc.basic.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
用户名密码:jdbc.basic.username=user jdbc.basic.password=pwd --------------------编程问答--------------------
是在jdbc.properties配置文件里面
补充:Java , Java EE