Java语言操作Oracle之中阶学习
1、jdbc操作oracle/mysql数据库的步骤
--第一步:导入驱动包(*.jar)
--第二步:书写database.properties配置文件
--第三步:加载驱动(Class.forName(driver))
--第四步:创建连接对象(Connection),创建Statement,发送sql语句,接收结果
--第五步:释放资源
2、配置文件:database.properties
driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:orcl
username=scott
password=crazy
3、JDBCUtil工具类
public class JdbcUtil {
private static String driver = null;
private static String url = null;
private static String username = null;
private static String password = null;
static {
try {
Properties props = new Properties();
InputStream ins = JdbcUtil.class.getClassLoader().getResourceAsStream("database.properties");
props.load(ins);
driver = props.getProperty("driver");
url = props.getProperty("url");
username = props.getProperty("username");
password = props.getProperty("password");
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConn() throws SQLException {
return DriverManager.getConnection(url, username, password);
}
}
4、Oracle性能测试
@Test
public void insert() throws Exception {
long startTime = System.currentTimeMillis();
Class.forName("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "crazy");
Statement st = conn.createStatement();
for (int i = 1; i <= 50000; i++) {
int flag = st.executeUpdate("insert into zhiheng(eid,ename) values(" + i + ",'诸葛亮')");
}
st.close();
conn.close();
long endTime = System.currentTimeMillis();
System.out.println("插入5万次花费" + (endTime - startTime) / 1000 + "秒");
}