Answer / shanu zabeen

import java.sql.*;
import java.io.*;
public class Employeedetails
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:employeeds");
Statement st=con.createStatement();
ResuleSet rs=st.executeQuery("select * from emp");//this
executes the query and get all the details from the table
employeeds
System.out.println("EId Ename Salary\n");
while(rs.next())
{
System.out.println(+rs.getInt(1)+"
"+rs.getString(2)+" "+rs.getString(3));

}//here 1 2 3 mentioned are the indices which are unique and
instead of 1 2 3 u can also provide the name of that
particular column name
and getXXX(index) ,here xxx is the type of the column like
int or float or string
st.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}

}
}

Answer / kiran kamble

Here is d coding for JDBC Connectivity to retrieve employee
details
I hv provided comments also so u can understand it better
--------------------*-----------------------------

/**
*
* @author KIRAN
*/

import java.sql.*;
import java.io.*;

public class JDBCConnection
{

public static void main(String args[])
{
Connection conn;
Statement stmt;
ResultSet rs;

try
{
//loads JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
e.printStackTrace();
}

try
{
//set connection string

conn=DriverManager.getConnection("jdbc:odbc:employeedsn");//here
loads dsn named empdsn

//creates statement
stmt=conn.createStatement();

//to get records from database using
resultset
rs=stmt.executeQuery("select * from emp");//for dis 1st
create emp named table
System.out.println("EId
Ename DOB Dept
Salary\n");
while(rs.next())//moves cursor to the next record until
it reaches d last record
{

System.out.println(+rs.getInt(1)+"
"+rs.getString(2)+" "+rs.getString(3)+"
"+rs.getString(4)+" "+rs.getInt(5));

}
stmt.close();
conn.close();
}

catch(Exception e)
{
e.printStackTrace();
}
}
}

Note:
-create emp table 1st wid attributes eid,ename,dob,dept,n
salary
-to add dsn(data source name)go to control
panel->Administrative Tools->Data Sources (ODBC) then one
small window will get opend..
-click on System DSN tab->Add->n select "Microsoft Access
Drive(*.mdb)"->finish->type Data Source Name(as i hv typed
in program "employeedsn" if u dnt want to change that dsn
which is written in d line
conn=DriverManager.getConnection("jdbc:odbc:employeedsn")

-you can give ne name tht u want instead of employeedsn...u
only need to provide d same name in Data Source Name

-next is no need to provide nethng for description
-then click on->select(to select database in *.mdb form)
---to select database table select drive on which u hv
saved ur database table n select that table by going to d
folder where u hv stored it by going to an appropriate directory
----if u select correct directory,table name will b
displyed in left hand side list box which then u need to
select n click on "OK" n again click on "OK"
----Your DSN will be displyed in System Data Sources List
---click on Ok n once you done this run the program

how to create a (*)pyramid using java codes???

5 Answers   Infosys,

---

Bubble Sort. java thereafter the user will be asked to inpout the size of the list,sort the list in ascending order and display the sorted list in a horizontal manner???

0 Answers  

---

write a java program to create a Frame with three scrolls, change the back ground color of the frame using functions with values of scrolls.

0 Answers  

---

Can we run Applet in Web browser with security policy files

0 Answers  

---

does anyone know the code to display a triangle using a applet?

1 Answers  

---

---

Write a program to convert a decimal number to binary form?

1 Answers   Oracle,

---

1+(2*3)+(4*5*6)+(7*8*9*10)+... specified input value

1 Answers   MAQ,

---

Financial: credit card number validation) Credit card numbers follow certain patterns. A credit card number must have between 13 and 16 digits. It must start with: ■ 4 for Visa cards ■ 5 for Master cards ■ 37 for American Express cards ■ 6 for Discover cards In 1954, Hans Luhn of IBM proposed an algorithm for validating credit card numbers. The algorithm is useful to determine whether a card number is entered correctly or whether a credit card is scanned correctly by a scanner. All credit card numbers are generated following this validity check, commonly known as the Luhn check or the Mod 10 check, which can be described as follows (for illustration, consider the card number 4388576018402626): 1. Double every second digit from right to left. If doubling of a digit results in a two-digit number, add up the two digits to get a single-digit number. 2 * 2 = 4 2 * 2 = 4 4 * 2 = 8 1 * 2 = 2 6 * 2 = 12 (1 + 2 = 3) 5 * 2 = 10 (1 + 0 = 1) 8 * 2 = 16 (1 + 6 = 7) 4 * 2 = 8 2. Now add all single-digit numbers from Step 1. 4 + 4 + 8 + 2 + 3 + 1 + 7 + 8 = 37 3. Add all digits in the odd places from right to left in the card number. 6 + 6 + 0 + 8 + 0 + 7 + 8 + 3 = 38 4. Sum the results from Step 2 and Step 3. 37 + 38 = 75 5. If the result from Step 4 is divisible by 10, the card number is valid; otherwise, it is invalid. For example, the number 4388576018402626 is invalid, but the number 4388576018410707 is valid. Write a program that prompts the user to enter a credit card number as a long integer. Display whether the number is valid or invalid. Design your program to use the following methods: /** Return true if the card number is valid */ public static boolean isValid(long number) /** Get the result from Step 2 */ public static int sumOfDoubleEvenPlace(long number) /** Return this number if it is a single digit, otherwise, return * the sum of the two digits */ public static int getDigit(int number) /** Return sum of odd place digits in number */ public static int sumOfOddPlace(long number) /** Return true if the digit d is a prefix for number */ public static boolean prefixMatched(long number, int d) /** Return the number of digits in d */ public static int getSize(long d) /** Return the first k number of digits from number. If the * number of digits in number is less than k, return

0 Answers  

---

is public static void main() work in java?is "String arg[]" needed as argument?

4 Answers   Tech Mahindra,

---

how to store and retrive a set of values without using an array

8 Answers   FCS, HCL, Maximus,

---

write a program in java to solve a system of n-variabled simultaneous equations using the guassian elimination method. let the maximum possible value of n be 100. run the program using hypothetical values for a set of 10- variables simultaneous equations. print out the program, the input equation and the results generated by the program.

0 Answers   TCS,

---

Why we r using String args[] in main() even though v r not passing any arguments in command line?

2 Answers  

---