Suji N

Ranch Hand
+ Follow
since Sep 04, 2001
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Suji N

Hi Friends
see the below statement
java Hello > a.txt
By using the above statement the output of Hello.java will be stored at a.txt.
Can we store the error messages using
javac Hello.java in a txt file ??
i mean like javac.Hello.java > a.txt
If possible please tell me how can i store the error messages while compiling.
Thanksinadvance
Yours
Suji
19 years ago
Thankyou Mr. Jamie
Your Code is Working Fine
Thankyou Very Much

Originally posted by Jamie Robertson:
[B]The following works for me:
Non-portable MSAccess specific:

Portable --> recommended

Jamie
[This message has been edited by Jamie Robertson (edited November 12, 2001).][/B]


Hai Friends
I am using MS ACCESS 2000 Database
I am using the following sqlString in AWT Frame class to fetch the date from MS ACcess Database
I heard that while comparing with >= or <= we need to include # symbol between the date.<br /> I was tried by using #. But i am not able to get the results.<br /> please see the sql query and give me the solution.<br /> Thanksinadvance<br /> Yours<br /> Rajesh<br /> if(Enddate.getText().trim().equals(""))<br /> {<br /> sqlString = "select * from data_comm_err where log_date >= '" + Startdate.getText() + "'";
}
if(Startdate.getText().trim().equals(""))
{
sqlString = "select * from data_comm_err where log_date <= '" + Enddate.getText() + "'";
}
Hi Friends
Can Anybody give Insertion Query to insert data into MS ACCESS Database thru JDBC Application
I am using the following Query
st.execute("insert into Testaccess values ('abcde','abcde')");
But the above query is not inserting data into ms access
Thanksinadvance
Yours
Rajesh
Hi
I am new to java.
Pl help me.
I have a JFrame Class Which contains a MenuItem.
and a JPanel Class Which Contains a RadioButton.
When the user selects the radio button, that menu item should get disabled.
I am facing a lot of pblms with this one in my project.
Please help me
Thanksinadvance
Yours
Suji
19 years ago
Hi
I have a doubt
While inserting Data to .csv / text file from java application there should be atleast one column should specify manually.
Is there anyway to specify the column name [in .csv file] through java application.
thanksinadvance
Yours
Suji
Hi
I am able to access data from excel file.
But I am not able to access the data from .csv file
I connected to that dsn.
If anybody knows about this please tell me.
If possible please send a small sample program
Yours
Suji
Dear Hemanth
Your Code Helped me a lot
Thankyou Verymuch
Yours
Suji

Originally posted by hemanth kumar:
Hi rakesh
Steps are :
1)Create System DSN to ur Excel Workbook i.e. excel file using Microsoft Excel Driver.
2)In ur java source code connect to that workbook i.e. excel file
3)then open recordset with the sheet name becoming ur table name
4)the columns become ur field names
thats abt it
Here's the working source code
<code>
import java.sql.*;
public class ConnectToExcel
{
public static void main(String a[])
{

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Connect to Excel DSN
String url = "jdbc dbc:test";
Connection connection =
DriverManager.getConnection(url, "", "");
Statement st=connection.createStatement();
// here sheet name equals to table name [sheet1]
String query = "SELECT * from [sheet1$]";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
String s = rs.getString("EName");
System.out.println(" field values for EName are " + s);
}

}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
</code>
Here test is the DSN name.Sheet1 is the table name and this1 is the column name
Hope the above helps.
So how was ur space flight .just joking
Hemanth


Hi Friends
How to insert data into .csv file through jdbc program
pl send insert statement to insert into .csv file
i dont know how to create dsn in odbc for ms excel.
pl give me some help
yours
Suji
Hi Friends.
I have a AWT Frame which will display the SQL Database Data using JDBC ODBC
Now I want to export that database data to MS Excel
In MS Excel I want to create the .csv file with this SQL Database Data
How to do this
Pl give some references
If possible with some sample code
Thanksinadvance
Yours
Suji
19 years ago
Hi
In Swings we have JOptionPane to display Dialog box.
for ex :
JOptionPane.showMessageDialog(this,"Message Here"
,"Title",JOptionPane.WARNING_MESSAGE);
In AWT i am able to display dialog by using another class which extends dialog. But,
Is there any thing like that in AWT to display dialog box ? [similar to JOptionPane]
Thanksinadvance
Yours
Suji
19 years ago
Hi
In Swings we have setToolTipText(String) to display some Tip Text.
Similarly is there any think like that in AWT ??
thanksinadvance
Yours
Suji
19 years ago
Thankyou Jamie
The page that you specified is very use ful for me
Thanksa lot
Yours
Suji
Hi Friends
What is "Connection Pooling"
I am developing Java Application using ms sql server 2000 database
Pl explain me about this
thanxinadvance
yours
Suji
Hai
I am new to java
Pl help me.
**********
I have a class called a , in package a;
another class called b , in package b;
another class called c , in package c;
**********
in class a, i have method called a1;
in class b, i have method called b1;
in class c, i have method called c1;
**********
now my doubt is
what is the way of calling the funtionality of b1 method and c1 method into class a.
in the same way what is the way of calling the funtionality of a1 method and c1 method into class b
**********
pl give a sample code with the above variables with packages.
i am developing a swings application.
pl help me with as many examples as possible.
thanks in advance
yours
rajesh
20 years ago