java,sql 4 Answer(s) 2 years and 7 months ago
Posted in : JDBC
Hello sir,iam sireesha studying MCA.I want a project code on JDBC,ODBC connection to display student administration system (or) student information system (or) college administraion system.Please send me the code sir,its very urgent.......
editbtn2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent ae){ try{ int x=JOptionPane.showConfirmDialog(p2,"Confirm edit? All data will be replaced"); if(x==0){ try{ String value1=tf7.getText(); String value2=tf8.getText(); String value3=tf9.getText(); String value4=tf10.getText(); int id=Integer.parseInt(value1); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:access"); Statement st=con.createStatement(); st.executeUpdate("update student set FirstName='"+value2+"', LastName='"+value3+"', Address='"+value4+"' where id="+id+""); JOptionPane.showMessageDialog(p2,"Updated successfully"); con.close(); } catch(Exception ex){ JOptionPane.showMessageDialog(p2,"Error in updating edit fields"); } } } catch(Exception ex){ JOptionPane.showMessageDialog(p2,"Error"); } } }); delbtn.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent ae){
String value1=tf5.getText(); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:access"); PreparedStatement st=con.prepareStatement("DELETE FROM student WHERE id = ?"); st.setString(1,value1); st.executeUpdate(); JOptionPane.showMessageDialog(p3,"Record is deleted successfully."); con.close(); } catch(Exception exp3) { JOptionPane.showMessageDialog(p3,"Error in deleting record."); } } }); } void dis(){ f.getContentPane().add(tp); tp.addTab("View Record",p3); tp.addTab("Add Record",p1); tp.addTab("Edit Record",p2); tp.addTab("Delete Record",p4); f.setSize(450,180); f.setVisible(true); f.setResizable(true); } public static void main(String z[]){ StudentInformation pro=new StudentInformation(); pro.dis(); } }
October 7, 2010 at 6:49 PM
Thank you very much for sending the required code which is suitable to my question.But you din't send the backend queries i.e sql queries.But its ok for me,i can manage myself.
Related Pages:
java,sql java,sql Hello sir,iam sireesha studying MCA.I want a project code on JDBC,ODBC connection to display student administration system (or) student information system (or) college administraion system.Please send me the code sir
java - SQL
java hi .
i am asifa and i for the last few days i was trying to display the backend fields to the frontend ,am using sql as the backend am using ecclipseeuropa IDE .can u please send the code for displaying the backend fields
java,sql java,sql Hello sir,iam an MCA student.I want a project code of jdbc,odbc connection for educational details of a student.please send me the code. you din't send me the reply,please send it fastly sir
java,sql java,sql Hello sir,iam sireesha studying MCA.i want a project on educational details of a student by using jdbc,odbc connection including sql queries.please send me the reply. Hi,
Please visit http://roseindia.net
JAVA to SQL JAVA to SQL package abhijeet;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import...;
}
}
plzzz help mw wid dis...
1: i hav read and Excel file in java
java .sql java .sql where are the interfaces of java.sql like STATEMENT,CONNECTION are defined
Java sql Exception Javasql Exception difference between sql exception class and sql warning class
Java to SQL Server Connectivity Java to SQL Server Connectivity Hi, heres my code
private void bookedButton()
{
try
{
Class.forName... with sql server connectivity at the background to save the data.
Now, after
java sql - JSP-Servlet java sql I need to diplay only 10 records per page from my resultset.
while(rs.next())loops through entire rs. How can I use a for loop in conjunction with the while loop to display only 10 records per page and then continue
Java and SQL - SQL Java and SQL i have a problem with regard to connecting my java code in getting a data to SQL. my problem is on how to come up with a pop up alert message in the user interface where in the message will be coming from the SQL
java-sql - JDBC java-sql how to convert excel file into sql database usin java programming
java,sql - JSP-Servlet java,sql Hi Amardeep,
Thank you from the bottom of my heart for giving me some excellent well thought out code.
Can you please... any appreciable result. Unfortunately, my java coding skills are not as sharp
java and sql server NOT Mysql - JSP-Servlet java and sql server NOT Mysql Hi guys.
Thank you all for the various helps you render to everyone. Please the question I asked the last time... image from MS SQL server NOT MySQL. Or is it not possible to do it in MS SQL server
Create a counter in mySQL 5 database through Java - SQL
,
Thanks for your valuable Java code example for JFileChooser.
I had another question regarding Java & mySQL 5 database... statistics) for total number of searches for a particular word using Java handing
Introduction To Hibernate 4.0
map data types of Java to SQL data types...Hibernate is a Object-relational mapping (ORM) tool for Java. It was initiated by Gavin King in 2001. ORM methodology is used to map classes to tables, class
question
question Dear Sir,
could you please send me a simple example of java and database connectivity with java and sql
Please visit the following link:
JDBC Tutorials
createdatabase - SQL
createdatabase hello
please help me...
I'm a student and I want to create database using SQL how I can Connect java with SQL.
thanks Hi Friend,
Please visit the following link:
http://www.roseindia.net/jdbc
SQL connection error in android SQL connection error in android hi,
i am android developer . recently i made one application connect with sql server 2005 using jtds lib.application run android2.2,2.3 but run in android4.0.3 it give exception:
java
need project
need project hi im new on this site so dnt knw actual procedure . but i need a project on banking system in java with sql database. which should contain following attributes
create new account for new customer
retrieve
JDBCTutorials
up the process. Yet searches on such terms as "JavaSQL framework" and "JDBC... is to provide an introduction to the JDBC interface for connecting Java programs with SQL-based databases. The course is interwoven with flexible exercises
Writing First Hibernate Code
/Relational Mapping and Transparent Object Persistence for Java and SQL
Databases... - org.hibernate.dialect.PostgreSQLDialect
Mckoi SQL - org.hibernate.dialect.MckoiDialect
Microsoft SQL... table.
Writing First Persistence Class
Hibernate uses the Plain Old Java Objects
Complete Hibernate 4.0 Tutorial
and attributes are mapped
to table columns. It also map data types of Java to SQL...) tool for Java. It was
initiated by Gavin King in 2001. ORM methodology... data from
Java environment to database table. Persistence is a storing 
Accessing database from JSP
, ResultSet
and Statement are associated with the Javasql.
"con"...
1.
Java
I/O
Tim Ritchey
2.
Java & XML,2