Solved

ASP command change to  Java Command

Posted on 2001-06-06
6
255 Views
Last Modified: 2010-03-31
I am translating a ASP Program to Java Program

What Java commands that I need to use to replace the following ASP commands:

isnumeric()
isDate()
formatNumber()
left()
right()
ASC()
HexChar()
Chr()

Also, How can I find out the java commands about retrieving the field name and defined size of the field from a recordset by using field index in Java Command?

In ASP, field name can be obtained from :
rstemp.fields(i).name

In ASP, defined size of the field can be obtained from :
rstemp.fields(i).definedsize

0
Comment
Question by:leo_wh_cheung
  • 4
  • 2
6 Comments
 
LVL 14

Expert Comment

by:sudhakar_koundinya
Comment Utility
boolean isNumeric(String s)
{
     try
     {
          new java.util.Date(s);
          return true;
     }
     catch(Exception e)
     {
          return false;
     }
     
}

int Asc(char c)
{
     return (int)c;
}
boolean isNumeric(String s)
{
     try
     {
          Double.parseDouble(s);
          return true;
     }
     catch(Exception e)
     {
          return false;
     }
}
0
 
LVL 2

Expert Comment

by:xxMariusxx
Comment Utility
isnumeric()
isDate()
-----------
For these, you'll hafta do as suggested above...write a quick method or code block that'll try converting and return false if an exception is thrown.

formatNumber()
--------------
I'm not sure what this guy is supposed to do.

left()
right()
-------
For these two, just use substring().  Or write something similar to the following:

public static String left(String s, int spaces) {
   return s.substring(0, spaces);
}

public static String right(String s, int spaces) {
   return s.substring(s.length()-spaces, s.length());
}

ASC()
Chr()
-----

The ASCII character set still uses 0-255, so you're free to convert between chars and ints if you like.  Uhh...I forget which returns what, so maybe I'll have this backwards.

public static char Chr(int asc) {
   return (char)asc;
}

public static String sChr(int asc) {
   return String.valueOf((char)asc);
}

public static int Asc(char chr) {
   return (int)chr;
}

public static int Asc(String chr) {
   return Integer.valueOf(chr).intValue();
}

HexChar()
---------
I'm not sure what this guy does either, but Java converts between decimal and hex notation pretty easily.

The following data access examples use a JDBC ResultSet interface (the ADO equivalent of a RecordSet).  The info you're looking for comes from the ResultSetMetaData interface. (rs.getMetaData())

rstemp.fields(i).name
---------------------
rstemp.getMetaData().getColumnName();

rstemp.fields(i).definedsize
----------------------------
rstemp.getMetaData().getColumnDisplaySize();

For more info on all of this stuff, view the Java API at http://java.sun.com/j2se/1.3/docs/api/index.html

Your String related info will be under the 'java.lang' package.  Your JDBC info will be under 'java.sql'.

Hope this helps!

Marius
0
 
LVL 2

Expert Comment

by:xxMariusxx
Comment Utility
oops, my bad...it shoulda been:

rstemp.fields(i).name
---------------------
rstemp.getMetaData().getColumnName(i);

rstemp.fields(i).definedsize
----------------------------
rstemp.getMetaData().getColumnDisplaySize(i);

I forgot to supply the column index parameter.

Marius
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 14

Expert Comment

by:sudhakar_koundinya
Comment Utility
String formatNumber(double value)
{

return NumberFormat.getInstance().format(new java.math.BigDecimal(value).setScale(2,0))
}

//setScale is depends on ur program

String trim(String s)
{
   return s.trim();
}

boolean isDate(String s)
{
    try
    {
         new java.util.Date(s);
         return true;
    }
    catch(Exception e)
    {
         return false;
    }
   
}

int Asc(char c)
{
    return (int)c;
}
char Chr(int c)
{
   return (char)c;

}
boolean isNumeric(String s)
{
    try
    {
         Double.parseDouble(s);
         return true;
    }
    catch(Exception e)
    {
         return false;
    }
}
0
 
LVL 14

Expert Comment

by:sudhakar_koundinya
Comment Utility
boolean isNumeric(String s)
{
   try
   {
        Double.valueOf(s).doubleValue();
        return true;
   }
   catch(Exception e)
   {
        return false;
   }
}
0
 
LVL 14

Accepted Solution

by:
sudhakar_koundinya earned 50 total points
Comment Utility
s.substring(0,pos)->left
s.substring(s.length()-pos,s.length())->right
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
scoreUp challenge 14 47
countHi challenge 25 84
Understanding websocket example in spring 1 41
Java Jpanels and Jframe 8 19
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now