i am using oracle sql+ and eclipse for my project on jsp,databases. i have to delete a record based on parameter passed,my code is
CODE
public class EmpInfoFactory
{
public void delete(int id)
{
Connection conn = null;
DatabaseManager dbManager = new DatabaseManager();
try{
conn=dbManager.connectToDatabase();
Statement stmt = conn.createStatement();
stmt.executeUpdate("delete from tcs_bgc_emp_info where id=@id);
stmt.executeQuery ("select * from tcs_bgc_emp_info ");
ResultSet rset=stmt.getResultSet();
while (rset.next())
{
System.out.println (rset.getString(1));
}
rset.close();
stmt.close();
conn.commit();
if(conn!= null)
{
conn.close();
}
} catch(Exception e)
{
System.out.print(e);
}
}
public static void main(String args[])
{
EmpInfoFactory obj = new EmpInfoFactory();
obj.delete(3);
}
}
its showing error" statement missing"
pls help me...
Mod Edit: Please use code tags when posting your code. Code tags are used like so =>
Thanks,
PsychoCoder
This post has been edited by PsychoCoder: 25 Jun, 2009 - 07:41 PM
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
| 
