jdbc数据库固定格式

//加载驱动，指向jar包
            Class.forName("oracle.jdbc.driver.OracleDriver");
  //链接本地服务
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
	//PreparedStatement 预处理
			PreparedStatement preStatement = conn.prepareStatement("select distinct job from emp where deptno=?");
	//给第一个问号赋值
			preStatement.setString(1, "20");
//preStatement.中的.executeQuery();查询方法返回 ResultSet  ，executeUpdate() 增删改方法返回int
			ResultSet result = preStatement.executeQuery();
//循环遍历，集合的.next()光标前移
			while (result.next()) {
			//打印
				System.out.println("Loan Type: " + result.getString("job"));
			}