.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> Javascript >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Update records from the database without using update command in java

Posted By:satyapriyanayak       Posted Date: October 02, 2014    Points: 40    Category: Javascript    URL: http://www.dotnetspark.com  

In this Code Snippets we will know how to update records from the database without using update command in java.
 

Table creation with records

create table employee(empno int,empname varchar(50),sal int)
insert into employee values(1,'raj',10000)
insert into employee values(2,'raju',20000)
insert into employee values(3,'rajesh',30000)

Creation of dsn(database source name) for Oracle
 
Start-Control panel- Administrative Tools- Data Sources (ODBC)-go to system dsn tab-click add button-select a driver for which you want to set up data source (for Oracle- Oracle in XE)-select it and click finish-give any name in data source name textbox-then click ok button.

Note:- Here Username=system, Password=pintu and Dsn name=dsn1

/*updating record without using update command */
import java.sql.*;
import java.util.*;
public class update
{
public static void main(String args[]) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:dsn1","system","pintu");
Statement stmt=con.createStatement(1004,1008);
Scanner sc=new Scanner(System.in);
System.out.print("Provide employee no :");
int no=sc.nextInt();
ResultSet rs=stmt.executeQuery("select * from employee where empno="+no);
if(rs.next())
{
System.out.print("New Salary :");
int s=sc.nextInt();
rs.updateInt("sal",s);
rs.updateRow();
System.out.println("***Data changed****");
}
else
System.out.println("No employee found ");
con.close();
}
}


Compile

Javac update.java
Java update


     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend