Java by API/java.sql/SQLData

implements SQLData

   <source lang="java">

import java.math.BigDecimal; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLData; import java.sql.SQLException; import java.sql.SQLInput; import java.sql.SQLOutput; import java.sql.Statement; import java.text.NumberFormat; import java.util.Map; class Employee implements SQLData {

 public BigDecimal SSN;
 public String FirstName;
 public String LastName;
 public BigDecimal Salary;
 private String sqlUdt;
 public void writeSQL(SQLOutput stream) throws SQLException {
   stream.writeBigDecimal(SSN);
   stream.writeString(FirstName);
   stream.writeString(LastName);
   stream.writeBigDecimal(Salary);
 }
 public String getSQLTypeName() throws SQLException {
   return sqlUdt;
 }
 public void readSQL(SQLInput stream, String typeName) throws SQLException {
   sqlUdt = typeName;
   SSN = stream.readBigDecimal();
   FirstName = stream.readString();
   LastName = stream.readString();
   Salary = stream.readBigDecimal();
 }
 public String calcMonthlySalary() {
   double monthlySalary = Salary.doubleValue() / 12;
   NumberFormat nf = NumberFormat.getCurrencyInstance();
   String str = nf.format(monthlySalary);
   return str;
 }

} public class Main {

 public static void main(String[] args) throws Exception {
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@myserver:1521:ORCL", "yourName", "mypwd");
   Statement stmt = conn.createStatement();
   Map map = conn.getTypeMap();
   map.put("EMP_DATA", Class.forName("Employee"));
   conn.setTypeMap(map);
   ResultSet rs = stmt.executeQuery("SELECT * from Emp");
   Employee employee;
   while (rs.next()) {
     int empId = rs.getInt("EmpId");
     employee = (Employee) rs.getObject("Emp_Info");
     System.out.print("Employee Id: " + empId + ", SSN: " + employee.SSN);
     System.out.print(", Name: " + employee.FirstName + " " + employee.LastName);
     System.out.println(", Yearly Salary: $" + employee.Salary + " Monthly Salary: "
         + employee.calcMonthlySalary());
   }
   conn.close();
 }

}

 </source>