空间数据库管理系统

空间数据库实习

连接数据库并调用oracle里面一个写好的函数或者过程，主要弄懂函数如何调用，如何传入参数传出参数

public class Main {
 public static void main(String args[]){
  Connection connection=getConnection();
  double dist; 
  String star=JOptionPane.showInputDialog("请输入起点:");
  String end=JOptionPane.showInputDialog("请输入终点:");
  CallableStatement state;
  try {
   state = connection.prepareCall("{?=call distance(?,?)}");
   state.registerOutParameter(1, OracleTypes.NUMBER);
   state.setString(2, star);  
   state.setString(3, end);
   state.execute();
   dist=state.getDouble(1);
   System.out.println("两点间距离为"+dist+"m");
  } catch (SQLException e) { 
   // TODO Auto-generated catch block 
   e.printStackTrace();
  }
 }
 
 public static Connection getConnection(){
  Connection conn=null;
  try{
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url="jdbc:oracle:thin:@//localhost:1521/orcl"; 
   String username="Test6";  
   String password="0";  
   conn= DriverManager.getConnection(url,username,password);    
   if(conn!=null)System.out.println("数据库连接成功");
  }catch(ClassNotFoundException e){ 
   e.printStackTrace();
  }catch(SQLException e){  
   e.printStackTrace(); 
  }  
  return conn;
 }
}
           

整个代码需要下载文件，https://download.csdn.net/download/m0_45123364/14896095