DAL in oracle
Answer / guest
public List<EEmployeeDetails> GetDetails(int
intEmpId, DateTime fromDate, DateTime toDate, int
intPageNo, int intPageSize, out int intTotalRecords, string
strOrderBy)
{
List<EEmployeeDetails> ListDetails = new
List<EEmployeeDetails>();
intTotalRecords = 0;
try
{
using (OracleDataReader objReader =
DataClient.ExecuteReader(ConnectionString,
CommandType.StoredProcedure, PROCEDURE_GET, GetDetailParams
(intEmpId, intReconciledstatus, fromDate, toDate,
intPageNo, intPageSize, strOrderBy)))
{
while (objReader.Read())
{
EEmployeeDetails
objEEmployeeDetails = new EEmployeeDetails();
if (!string.IsNullOrEmpty(objReader
["Employee_ID"].ToString()))
objEEmployeeDetails.EMPLOYEEId =
Convert.ToInt32(objReader["Employee_ID"]);
if (!string.IsNullOrEmpty(objReader
["EMPLOYEE_NUMBER"].ToString()))
objEEmployeeDetails.EMPLOYEENumber
= (string)(objReader["EMPLOYEE_NUMBER"]);
if (!string.IsNullOrEmpty(objReader
["EMPLOYEE_DATE"].ToString()))
if (!string.IsNullOrEmpty(objReader
["AMOUNT"].ToString()))
objEEmployeeDetails.Amount =
Convert.ToInt32(objReader["AMOUNT"]);
if (!string.IsNullOrEmpty(objReader
["TOTAL"].ToString()))
objEEmployeeDetails.Total =
Convert.ToInt32(objReader
["TOTAL"]);
intTotalRecords = Convert.ToInt32
(objReader["TOTAL"]);
ListDetails.Add
(objEEmployeeDetails);
}
}
}
catch (Exception ex)
{
bool rethrow =
ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw ex;
}
}
return ListDetails;
}
///<summary>
///helper class for get details
///
/// </summary>
public static OracleParameter[] GetDetailParams(int
intEmpId, DateTime fromDate, DateTime toDate, int
intPageNo, int intPageSize, string strOrderBy)
{
OracleParameter[] sqlParams = null;
try
{
sqlParams = DataClient.GetCachedParameterSet
(ConnectionString, PROCEDURE_GET);
if (sqlParams == null || sqlParams.Length
== 0)
{
sqlParams = new OracleParameter[]
{
new OracleParameter(PARAM_ID,
OracleDbType.Int32),
new OracleParameter(PARAM_STATUS ,
OracleDbType.Int32),
new OracleParameter(PARAM_FROMDATE,
OracleDbType.Date),
new OracleParameter(PARAM_TODATE,
OracleDbType.Date),
new OracleParameter
(PARAM_RETURN,OracleDbType.Int32),
new OracleParameter(PARAM_REFCURSOR,
OracleDbType.RefCursor),
new OracleParameter(PARAM_PAGENUM,
OracleDbType.Int32),
new OracleParameter(PARAM_PAGESIZE,
OracleDbType.Int32),
new OracleParameter (PARAM_TOTALCOUNT,
OracleDbType.Int32),
new OracleParameter(PARAM_ORDERBY,
OracleDbType.Char)
};
DataClient.CacheParameterSet
(DataClient.CONN_STRING, PROCEDURE_GET, sqlParams);
sqlParams
[0].Direction=ParameterDirection.InputOutput;
sqlParams[0].Value = intEmpId;
sqlParams[2].Value = fromDate;
sqlParams[3].Value =
toDate;
sqlParams
[4].Direction=ParameterDirection.Output;
sqlParams
[5].Direction=ParameterDirection.Output;
sqlParams[6].Value = intPageNo;
sqlParams[7].Value = intPageSize;
sqlParams[8].Direction =
ParameterDirection.Output;
sqlParams[9].Value = strOrderBy;
}
}
catch (Exception ex)
{
var rethrow =
ExceptionPolicy.HandleException(ex, "Propagate Policy");
if (rethrow)
{
throw ex;
}
}
return sqlParams;
}
Is This Answer Correct ? | 0 Yes | 0 No |
Write a Program to find the reverse of a given number.
Write a Program to find the sum of digits of a given number until the sum becomes a single digit. (e.g. 12345=>1+2+3+4+5=15=>1+5=6)
what full form name of B.K.U.
Design a timer circuit using VHDL which has the following: input : start_timer(ST) output: long_time(LT) short_time(ST) when the timer is triggered by the ST(either 0 or 1) signal the timer should generate two timing signals accordingly.While the long time is going ON the other should be OFF and vice versa.
Find out the list of roles which gives access to all t-codes in SAP? Thanks in advance.
What is the coding about how to recognize color in fuzzy logic using Matlab R2009b?
WORKING STORAGE 01 WS-LENGTH PIC 9(1) VALUE 5. 01 DFHCOMMAREA. COPY ABCDEF (COPYBOOK ABCDEF IS HAVING ONLY ONE VARIABLE OF LENGTH X (100).) .. PROCEDUER DIVISION. ... EXEC CICS XCTL PROGRAM (WS-PGM) COMMAREA (DFHCOMMAREA) LENGTH (WS-LENGTH) RESP (WC-RESPONSE) END-EXEC 1. What will be the value of EIBCALEN in program ABCDEF? 2. What will be length of commarea when in ABCDEF? 3. Will such a code thow any error while linking to called program? Thanks in Advance
Devise a program to implement the Fibonacci sequence.
Is it possible to write JAVA program without including any of the packages,such as "import java.io.*"; bcoz I instantly wrote a code without "import..." statement and runned the program on command Line & it worked. the code is: class Person { String name; int age; Person(String s,int a) { name = s; age = a; } accept() { System.out.println(name+"Hi!!!!!"); System.out.println(age); } } class Demo { public static void main(Strings args[])throws IOException { String name = args[0]; int age = Integer.parseInt(args[1]); Person p = new Person(name,age); p.accept(); } }
plzzzzzzzzz xplain this code import java.awt.*; import java.awt.event.*; import java.awt.MenuItem.*; import java.sql.*; import sun.jdbc.odbc.*; import java.io.*; public class ShopDelivery extends Frame implements ActionListener { Label l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13; Button exit,save,next,top,prev,botm,ad,show; TextField txtCMemoNo,txtConsNo,txtCMemoDt,txtConsName,txtAddr1,txtPhNo ,txtBookDtold,txtPrintDt,txtOldCMemNo,txtOldDlryDt,adr2,adr3 ,tot,stnry,rmrk; String ConsName; String Addr1; public static void main(String sr[]) { new ShopDelivery().setVisible(true); } public ShopDelivery() { super("Shop Delivery"); Statement stmt; ResultSet rs; //PreparedStatement pst; Connection con; try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:Agency"); if (con!=null); System.out.println ("connected"); stmt =con.createStatement (); } catch(Exception e1) { System.out.println (e1); } setSize(1280,800); setBackground(Color.CYAN); setLayout(null); l1=new Label("Cashmemo No"); l1.setBounds(260,60,90,30); l1.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l1.setAlignment(Label.CENTER); add(l1); l2=new Label("CONSMR NO"); l2.setBounds(30,60,90,30); l2.setFont(new Font("TimesRoman",Font.PLAIN,15)); l2.setAlignment(Label.CENTER); add(l2); l3=new Label("Book DATE"); l3.setBounds(520,60,90,30); l3.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l3.setAlignment(Label.CENTER); add(l3); l4=new Label("NAME"); l4.setBounds(30,150,45,30); l4.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l4.setAlignment(Label.CENTER); add(l4); l5=new Label("ADRS"); l5.setBounds(30,220,45,30); l5.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l5.setAlignment(Label.CENTER); add(l5); l6=new Label("PH NO"); l6.setBounds(500,150,45,30); l6.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l6.setAlignment(Label.CENTER); add(l6); l7=new Label("OldBkDt"); l7.setBounds(30,390,55,30); l7.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l7.setAlignment(Label.CENTER); add(l7); l8=new Label("Print Date"); l8.setBounds(320,390,65,30); l8.setFont(new Font("TimesRoman",Font.PLAIN,15)); l8.setAlignment(Label.CENTER); add(l8); l9=new Label("CMemo No"); l9.setBounds(700,390,65,30); l9.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l9.setAlignment(Label.CENTER); add(l9); l10=new Label("Del Date"); l10.setBounds(550,390,55,30); l10.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l10.setAlignment(Label.CENTER); add(l10); l13=new Label("REMARKS"); l13.setBounds (30,630,85,30); l13.setFont(new Font ("TimesRoman",Font.PLAIN,15)); l13.setAlignment (Label.CENTER); add(l13); txtCMemoNo=new TextField(); txtCMemoNo.setBounds(375,60,80,30); txtCMemoNo.setBackground(Color.white); add(txtCMemoNo); txtConsNo=new TextField(); txtConsNo.setBounds(130,60,80,30); txtConsNo.setBackground(Color.white); add(txtConsNo); txtCMemoDt=new TextField(); txtCMemoDt.setBounds(635,60,80,30); txtCMemoDt.setBackground(Color.white); add(txtCMemoDt); txtConsName=new TextField(); txtConsName.setBounds(100,150,200,30); txtConsName.setBackground(Color.white); add(txtConsName); txtAddr1=new TextField(); txtAddr1.setBounds(100,220,350,30); txtAddr1.setBackground(Color.white); add(txtAddr1); adr2=new TextField(); adr2.setBounds(100,250,350,30); adr2.setBackground(Color.white); add(adr2); adr3=new TextField(); adr3.setBounds(100,280,350,30); adr3.setBackground(Color.white); add(adr3); txtPhNo=new TextField(); txtPhNo.setBounds(570,150,150,30); txtPhNo.setBackground(Color.white); add(txtPhNo); txtBookDtold=new TextField(); txtBookDtold.setBounds(30,440,60,30); txtBookDtold.setBackground(Color.white); add(txtBookDtold); txtPrintDt=new TextField(); txtPrintDt.setBounds(320,440,60,30); txtPrintDt.setBackground(Color.white); add(txtPrintDt); txtOldCMemNo=new TextField(); txtOldCMemNo.setBounds(700,440,60,30); txtOldCMemNo.setBackground(Color.white); add(txtOldCMemNo); txtOldDlryDt=new TextField(); txtOldDlryDt.setBounds(550,440,60,30); txtOldDlryDt.setBackground(Color.white); add(txtOldDlryDt); rmrk=new TextField(); rmrk.setBounds(140,630,600,30); rmrk.setBackground(Color.white); add(rmrk); exit=new Button("EXIT"); exit.setBackground(Color.orange); exit.setBounds(760,700,40,40); exit.addActionListener(this); add(exit); save=new Button("SAVE"); save.setBackground(Color.orange); save.setBounds(715,700,40,40); save.addActionListener(this); add(save); next=new Button("NEXT"); next.setBackground(Color.orange); next.setBounds(90,700,40,40); next.addActionListener(this); add(next); top=new Button("TOP"); top.setBackground(Color.orange); top.setBounds(0,700,40,40); top.addActionListener(this); add(top); prev=new Button("PREV"); prev.setBackground(Color.orange); prev.setBounds(45,700,40,40); prev.addActionListener(this); add(prev); botm=new Button("BOTM"); botm.setBackground (Color.orange); botm.setBounds (135,700,40,40); botm.addActionListener (this); add(botm); ad=new Button("ADD"); ad.setBackground (Color.orange); ad.setBounds (300,700,40,40); ad.addActionListener (this); add(ad); show=new Button("SHOW"); show.setBackground (Color.orange); show.setBounds (345,700,40,40); show.addActionListener (this); add(show); } public void actionPerformed(ActionEvent e) { if(e.getSource()==exit) { this.dispose(); System.exit(0); } /*if(e.getSource()==save) { try { Connection con=DriverManager.getConnection("jdbc:odbc:Agency"); PreparedStatement pst=con.prepareStatement("INSERT INTO NewCon values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); pst.setInt (1,Integer.parseInt(txtConsNo.getText())); pst.setInt (2,Integer.parseInt(txtCMemoNo.getText())); pst.setString (3,txtCMemoDt.getText()); pst.setString (4,txtConsName.getText()); pst.setInt(5,Integer.parseInt (txtPhNo.getText())); pst.setString(6,txtAddr1.getText()); pst.setString(7,adr2.getText()); pst.setString(8,adr3.getText()); pst.setInt(9,Integer.parseInt (txtBookDtold.getText())); pst.setInt(10,Integer.parseInt (txtPrintDt.getText())); pst.setInt(11,Integer.parseInt (txtOldDlryDt.getText())); pst.setInt(12,Integer.parseInt (txtCMemoNo.getText())); pst.setInt(13,Integer.parseInt (tot.getText())); pst.setInt(14,Integer.parseInt (stnry.getText())); pst.setString(15,rmrk.getText()); pst.executeUpdate (); con.close(); } catch(Exception e2) {System.out.println(e2);} //cs(txtConsName.getText (),txtAddr1.getText()); }*/ if(e.getSource()==ad) { try { txtCMemoNo.setText(""); txtCMemoDt.setText(""); txtConsName.setText(""); txtAddr1.setText(""); txtPhNo.setText(""); txtBookDtold.setText(""); txtPrintDt.setText(""); //txtCMemoNo.setText(""); txtOldDlryDt.setText(""); adr2.setText(""); adr3.setText(""); tot.setText(""); //stnry.setText(""); //rmrk.setText(""); Connection con1=DriverManager.getConnection("jdbc:odbc:Agency"); Statement stmt1=con1.createStatement(); ResultSet rs1=stmt1.executeQuery("SELECT Max(Cons_No) FROM NewCon"); int nextcono = rs1.getInt ("Cons_No"); System.out.println (nextcono); nextcono=nextcono+1; txtConsNo.setText ("nextcono"); con1.close(); } catch(Exception e4){} } } }
i have two internal tables with customer and credit amount in one table then customer and debit amount in another table. now i need output in single list as customer, credit amount, debit amount and (credit - debit). help me please
1.Explain what happens to a session object when the browser associated with it is closed? 2.Explain how a session object is created and used. (Note: you are not required to provide the Java statements such as ‘getAttribute’)