Java by API/java.sql/ParameterMetaData

Содержание

1 ParameterMetaData: getParameterClassName(int param)
2 ParameterMetaData: getParameterCount()
3 ParameterMetaData: getParameterMode(int param)
4 ParameterMetaData: getParameterType(int param)
5 ParameterMetaData: getParameterTypeName(int param)
6 ParameterMetaData: isNullable(int param)
7 ParameterMetaData.parameterModeIn
8 ParameterMetaData.parameterModeInOut
9 ParameterMetaData.parameterModeOut
10 ParameterMetaData.parameterNoNulls

ParameterMetaData: getParameterClassName(int param)

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   PreparedStatement pstmt = null;
   ParameterMetaData paramMetaData = null;
   String query = "select * from survey where id > ? and name = ?";
   pstmt = conn.prepareStatement(query);
   paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       String paramClassName = paramMetaData.getParameterClassName(param);
       System.out.println("param class name=" + paramClassName);
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData: getParameterCount()

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   String query = "select * from survey where id > ? and name = ?";
   PreparedStatement pstmt = conn.prepareStatement(query);
   ParameterMetaData paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       String paramTypeName = paramMetaData.getParameterTypeName(param);
       System.out.println("param SQL type name=" + paramTypeName);
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData: getParameterMode(int param)

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   PreparedStatement pstmt = null;
   ParameterMetaData paramMetaData = null;
   String query = "select * from survey where id > ? and name = ?";
   pstmt = conn.prepareStatement(query);
   paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       int paramMode = paramMetaData.getParameterMode(param);
       System.out.println("param mode=" + paramMode);
       if (paramMode == ParameterMetaData.parameterModeOut) {
         System.out.println("the parameter"s mode is OUT.");
       } else if (paramMode == ParameterMetaData.parameterModeIn) {
         System.out.println("the parameter"s mode is IN.");
       } else if (paramMode == ParameterMetaData.parameterModeInOut) {
         System.out.println("the parameter"s mode is INOUT.");
       } else {
         System.out.println("the mode of a parameter is unknown.");
       }
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData: getParameterType(int param)

   <source lang="java">

import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getMySqlConnection();
   String simpleProc = "{ call simpleproc(?) }";
   CallableStatement cs = conn.prepareCall(simpleProc);
   cs.registerOutParameter(1, java.sql.Types.INTEGER);
   cs.execute();
   int param1 = cs.getInt(1);
   System.out.println("param1=" + param1);
   ParameterMetaData pmeta = cs.getParameterMetaData();
   if (pmeta == null) {
     System.out.println("Vendor does not support ParameterMetaData");
   } else {
     System.out.println(pmeta.getParameterType(1));
   }
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData: getParameterTypeName(int param)

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   String query = "select * from survey where id > ? and name = ?";
   PreparedStatement pstmt = conn.prepareStatement(query);
   ParameterMetaData paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       String paramTypeName = paramMetaData.getParameterTypeName(param);
       System.out.println("param SQL type name=" + paramTypeName);
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData: isNullable(int param)

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   PreparedStatement pstmt = null;
   ParameterMetaData paramMetaData = null;
   String query = "select * from survey where id > ? and name = ?";
   pstmt = conn.prepareStatement(query);
   paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       int nullable = paramMetaData.isNullable(param);
       if (nullable == ParameterMetaData.parameterNoNulls) {
         System.out.println("parameter will not allow NULL values.");
       } else if (nullable == ParameterMetaData.parameterNullable) {
         System.out.println("parameter will allow NULL values.");
       } else {
         System.out.println("nullability of a parameter is unknown.");
       }
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData.parameterModeIn

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   PreparedStatement pstmt = null;
   ParameterMetaData paramMetaData = null;
   String query = "select * from survey where id > ? and name = ?";
   pstmt = conn.prepareStatement(query);
   paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       int paramMode = paramMetaData.getParameterMode(param);
       System.out.println("param mode=" + paramMode);
       if (paramMode == ParameterMetaData.parameterModeOut) {
         System.out.println("the parameter"s mode is OUT.");
       } else if (paramMode == ParameterMetaData.parameterModeIn) {
         System.out.println("the parameter"s mode is IN.");
       } else if (paramMode == ParameterMetaData.parameterModeInOut) {
         System.out.println("the parameter"s mode is INOUT.");
       } else {
         System.out.println("the mode of a parameter is unknown.");
       }
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData.parameterModeInOut

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   PreparedStatement pstmt = null;
   ParameterMetaData paramMetaData = null;
   String query = "select * from survey where id > ? and name = ?";
   pstmt = conn.prepareStatement(query);
   paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       int paramMode = paramMetaData.getParameterMode(param);
       System.out.println("param mode=" + paramMode);
       if (paramMode == ParameterMetaData.parameterModeOut) {
         System.out.println("the parameter"s mode is OUT.");
       } else if (paramMode == ParameterMetaData.parameterModeIn) {
         System.out.println("the parameter"s mode is IN.");
       } else if (paramMode == ParameterMetaData.parameterModeInOut) {
         System.out.println("the parameter"s mode is INOUT.");
       } else {
         System.out.println("the mode of a parameter is unknown.");
       }
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData.parameterModeOut

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   PreparedStatement pstmt = null;
   ParameterMetaData paramMetaData = null;
   String query = "select * from survey where id > ? and name = ?";
   pstmt = conn.prepareStatement(query);
   paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       int paramMode = paramMetaData.getParameterMode(param);
       System.out.println("param mode=" + paramMode);
       if (paramMode == ParameterMetaData.parameterModeOut) {
         System.out.println("the parameter"s mode is OUT.");
       } else if (paramMode == ParameterMetaData.parameterModeIn) {
         System.out.println("the parameter"s mode is IN.");
       } else if (paramMode == ParameterMetaData.parameterModeInOut) {
         System.out.println("the parameter"s mode is INOUT.");
       } else {
         System.out.println("the mode of a parameter is unknown.");
       }
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

ParameterMetaData.parameterNoNulls

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ParameterMetaData; import java.sql.PreparedStatement; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   
   PreparedStatement pstmt = null;
   ParameterMetaData paramMetaData = null;
   String query = "select * from survey where id > ? and name = ?";
   pstmt = conn.prepareStatement(query);
   paramMetaData = pstmt.getParameterMetaData();
   if (paramMetaData == null) {
     System.out.println("db vendor does NOT support ParameterMetaData");
   } else {
     System.out.println("db vendor supports ParameterMetaData");
     // find out the number of dynamic parameters
     int paramCount = paramMetaData.getParameterCount();
     System.out.println("paramCount=" + paramCount);
     System.out.println("-------------------");
     for (int param = 1; param <= paramCount; param++) {
       System.out.println("param number=" + param);
       int nullable = paramMetaData.isNullable(param);
       if (nullable == ParameterMetaData.parameterNoNulls) {
         System.out.println("parameter will not allow NULL values.");
       } else if (nullable == ParameterMetaData.parameterNullable) {
         System.out.println("parameter will allow NULL values.");
       } else {
         System.out.println("nullability of a parameter is unknown.");
       }
     }
   }
   pstmt.close();
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

}

 </source>

Java by API/java.sql/ParameterMetaData

Содержание

ParameterMetaData: getParameterClassName(int param)

ParameterMetaData: getParameterCount()

ParameterMetaData: getParameterMode(int param)

ParameterMetaData: getParameterType(int param)

ParameterMetaData: getParameterTypeName(int param)

ParameterMetaData: isNullable(int param)

ParameterMetaData.parameterModeIn

ParameterMetaData.parameterModeInOut

ParameterMetaData.parameterModeOut

ParameterMetaData.parameterNoNulls

Навигация

Персональные инструменты

Пространства имён

Варианты

Просмотры

Ещё

Поиск

Разделы

Навигация

Инструменты