Java Code for implementation of Scrollable Resultset(movenext,moveprevious,movefirst,movelast)

import java.io.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
class slip2 extends Frame implements ActionListener
{
Button b1,b2,b3,b4;
TextField t1,t2,t3,t4;
Label l1,l2,l3,l4;
Connection con=null;
Statement st=null;
ResultSet rs=null;
slip2()
{ try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:emp1");
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=st.executeQuery("select * from emp");
} catch(Exception ee) {
System.out.println("fsfsddsf"+ee);
}
l1=new Label("Enter No");
l2=new Label("Enter Name");
l3=new Label("Enter Salary");
t1=new TextField();
t2=new TextField();
t3=new TextField();
b1=new Button("First");
b2=new Button("Last");
b3=new Button("Next");
b4=new Button("Previous");
setLayout(null);
add(l1);
l1.setBounds(10,50,100,30);
add(t1);
t1.setBounds(120,50,150,30);
add(l2);
l2.setBounds(10,100,100,50);
add(t2);
t2.setBounds(120,100,150,30);
add(l3);
l3.setBounds(10,150,100,50);
add(t3);
t3.setBounds(120,150,150,30);
add(b1);
b1.setBounds(20,200,60,30);
add(b2);
b2.setBounds(80,200,60,30);
add(b3);
b3.setBounds(140,200,60,30);
add(b4);
b4.setBounds(200,200,60,30);
setVisible(true);
setSize(500,500);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
}
public void actionPerformed(ActionEvent ae)
{
String str=ae.getActionCommand();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:emp1");
} catch(Exception ee)
{ System.out.println("fsfsddsf"+ee);
}
if(str.equals("First"))//function for Move First
{ try
{rs.first();
t1.setText(Integer.toString(rs.getInt(1)));
t2.setText(rs.getString(2));
t3.setText(Integer.toString(rs.getInt(3)));
System.out.println("Saved");
} catch(Exception ee)
{ System.out.println(ee);
} }
if(str.equals("Last"))//function for Move Last
{ try
{rs.last();
t1.setText(Integer.toString(rs.getInt(1)));
t2.setText(rs.getString(2));
t3.setText(Integer.toString(rs.getInt(3)));
System.out.println("Saved");
} catch(Exception ee) {
System.out.println(ee);
} }
if(str.equals("Next"))/function for Move Next
{ try {
rs.next();
t1.setText(Integer.toString(rs.getInt(1)));
t2.setText(rs.getString(2));
t3.setText(Integer.toString(rs.getInt(3)));
System.out.println("Saved");
} catch(Exception ee) {
System.out.println(ee);
} }
if(str.equals("Previous"))//function for Move Previous
{ try
{ rs.previous();
t1.setText(Integer.toString(rs.getInt(1)));
t2.setText(rs.getString(2));
t3.setText(Integer.toString(rs.getInt(3)));
System.out.println("Saved");
}
catch(Exception ee)
{
System.out.println(ee);
} } }
public static void main(String arg[])
{
new slip2();
}
}

Comments

Post a Comment

Popular posts from this blog

Edit/Modify existing PDF using Java(iText)

import java.io.FileOutputStream; import java.io.IOException; import com.itextpdf.text.DocumentException; import com.itextpdf.text.pdf.BaseFont; import com.itextpdf.text.pdf.PdfContentByte; import com.itextpdf.text.pdf.PdfReader; import com.itextpdf.text.pdf.PdfStamper; public class EditExistingPDF { public static void main(String[] args) throws IOException, DocumentException { PdfReader reader = new PdfReader("C:\\signed.pdf"); // input PDF PdfStamper stamper = new PdfStamper(reader,new FileOutputStream( "C:\\test.pdf")); // output PDF BaseFont bf = BaseFont.createFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); // set font // loop on pages (1-based) for (int i = 1; i // get object for writing over the existing content; // you can also use getUnderContent for writing in the bottom // layer PdfContentByte over = stamper.getOverContent(i); // write text over.beginText(); over.setFontAndSize(bf, 10); // set font and size over....
Read more

Verify Digital Signature in PDF using Java(iText) and cacerts

Jars Files: itext-2.1.7.jar itextpdf-5.4.2.jar bcprov-ext-jdk14-1.47.jar bcprov-1.39.jar ---------------------------------------------------------------- import java.io.FileNotFoundException; import java.io.IOException; import java.security.KeyStore; import java.security.KeyStoreException; import java.security.NoSuchAlgorithmException; import java.security.SignatureException; import java.security.cert.CertificateException; import java.util.ArrayList; import java.util.Calendar; import java.util.Enumeration; import com.lowagie.text.pdf.AcroFields; import com.lowagie.text.pdf.PdfPKCS7; import com.lowagie.text.pdf.PdfReader; public class VerifySignature { public static void main(String[] args) throws KeyStoreException, NoSuchAlgorithmException, CertificateException, FileNotFoundException, IOException, SignatureException { //loads all the keystore imported in cacerts. To load your certificate from cacerts, first it needs to be imported using k...
Read more

Steps to create SOAP Web service using Eclipse

Image
Step 1 : Go to File -> New -> Dynamic Web Project Step 2 : Enter Project name as “SOAPWebSErvice” as created in below screenshot. Step 3 : Create below packages under src folder: a. com.test.controller b. com.test.model Step 4 : Add Employee.java under package - com.test.model Add EmployeeController.java under package - com.test.controller. Employee.java package com.test.model; public class Employee { private String id; private String name; public String getId() { return id; } public String getName() { return name; } public void setId(String id) { this.id = id; } public void setName(String name) { this.name = name; } } ------------------------------------------------------------------------------------------------------------------ EmployeeController.java package com.test.controller; import com.test.model.Employee; public class EmployeeController { public Employee employee; public Employee setEmployee(...
Read more