here is one sample in which i used MsSqlserver database for Calculating Salary for employees................
PHP Code:
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
public class Main
{
/** Creates a new instance of Main */
public Main()
{
}
/**
* @param args the command line arguments
*/
public static void main(String[] args)
{
Connection con = null;
Statement st = null;
PreparedStatement pt = null;
CallableStatement ct = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:jspTest", "sa", "Pdindia123");
//Statement
st = con.createStatement();
st.executeUpdate("insert into sample values('Jun', 3, 'Arun', 0, 34567)");
//Call Stored Procedure.
//CallableStatement(pname->procedure name , parameter)
// ct = con.prepareCall("{call pname(1)}");
// ct.execute();
//
//PreparedStatement
pt = con.prepareStatement("select * from sample");
ResultSet rs = pt.executeQuery();
System.out.println("Month\tNumber\tName\tLeave in days\tSalary");
System.out.println("------------------------------------------------------------");
while(rs.next())
{
System.out.print("\t"+rs.getString("month")+"\n");
System.out.print("\t"+rs.getInt("num")+"\n");
System.out.print("\t"+rs.getString("nam")+"\n");
System.out.print("\t"+rs.getInt("leave")+"\n");
System.out.print("\t"+rs.getInt("sal")+"\n");
}
System.out.println("----------------------------------------------------------------");
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}
Output:
---------
Month Number Name Leave in days Salary
----------------------------------------------------------------------------------
Jun 1 Smith 2 40234
Jun 2 Vimal 6 30094
Jun 3 Arun 0 34567
----------------------------------------------------------------------------------
08-20-2007, 09:00 AM
User defined functions in Java 
Linear Mode
Similar Threads 
