java
Hi friends yesterday i asked you this...How do i write a program that has maybe 5 labels and 5 textboxes for student details, name, surname, id no., address, cell no., student no.. Then when the user inputs data it is stored in the database. Access or excell. Your answer really helped, but i need the program to write to a file or directory. I have an example of your code mixed with mine and it does not work. Pls help, im begging you friends. Here is the example code:
package studentDetailsDatabase;
import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
import java.io.File;
import java.io.PrintWriter;
class FormDemo extends JFrame {
public static File dir;
public static File fileName;
JButton ADD;
JPanel panel;
JFrame f;
FormDemo(){
JLabel label1,label2,label3,label4,label5;
final JTextField text1,text2,text3,text4,text5;
label1 = new JLabel("Student ID:");
text1 = new JTextField(20);
label2 = new JLabel("First Name:");
text2 = new JTextField(20);
label3 = new JLabel("Last Name:");
text3= new JTextField(20);
label4 = new JLabel("Address:");
text4 = new JTextField(20);
label5= new JLabel("Contact No:");
text5= new JTextField(20);
ADD=new JButton("Enter");
ADD.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String v1=text1.getText();
String v2=text2.getText();
String v3=text3.getText();
String v4=text4.getText();
String v5=text5.getText();
int ide=Integer.parseInt(v1);
int no=Integer.parseInt(v5);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect =DriverManager.getConnection("jdbc:odbc:access","","");
Statement st=connect.createStatement();
int i=st.executeUpdate("insert into Student(id,FirstName,LastName,Address,ContactNo) values("+ide+",'"+v2+"','"+v3+"','"+v4+"',"+v5+")");
JOptionPane.showMessageDialog(null,"Inserted Successfully");
}
catch(Exception ex){
System.out.println(ex);
JOptionPane.showMessageDialog(null,"Error");
}
}
});
f=new JFrame();
panel=new JPanel(new GridLayout(6,2));
panel.add(label1);
panel.add(text1);
panel.add(label2);
panel.add(text2);
panel.add(label3);
panel.add(text3);
panel.add(label4);
panel.add(text4);
panel.add(label5);
panel.add(text5);
panel.add(ADD);
f.add(panel,BorderLayout.CENTER);
f.setTitle("STUDENT DETAILS");
f.setVisible(true);
f.pack();
}
public static void main(String[]args){
FormDemo ff=new FormDemo();
StringBuffer sb = new StringBuffer();
String detailLine1, detailLine2;
PrintWriter pw;
try {
//2. Point to the directory where the file is located
File dir = new File("dir");
System.out.println(dir.isDirectory());
//3. Point to the file
File fileName = new File(dir,"StudentDetails.csv");
System.out.println(fileName.isFile());
text1 = ("");
text2 = ("");
sb.append("Student List for the year ");
sb.append("\n\n\n");
sb.append(text1);
sb.append("\n");
sb.append(detailLine2);
sb.append("text2");
pw = new PrintWriter(fileName);
pw.write(sb.toString());
//8. Ensure that the last data is written and close the PrintWriter
pw.flush();
pw.close();
} catch (Exception e) {
System.out.println("*******THE ERROR THAT WE GET "+ e.getMessage());
e.printStackTrace();
}
}
}
Thank you for responding.
View Answers
September 28, 2010 at 10:56 AM
Hi Friend,
Try the following code:
import java.io.*;
import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
class FormDemo extends JFrame {
HSSFWorkbook wb;
HSSFSheet sheet;
JButton ADD;
JPanel panel;
JFrame f;
FormDemo(){
JLabel label1,label2,label3,label4,label5;
final JTextField text1,text2,text3,text4,text5;
label1 = new JLabel("Student ID:");
text1 = new JTextField(20);
label2 = new JLabel("First Name:");
text2 = new JTextField(20);
label3 = new JLabel("Last Name:");
text3= new JTextField(20);
label4 = new JLabel("Address:");
text4 = new JTextField(20);
label5= new JLabel("Contact No:");
text5= new JTextField(20);
wb = new HSSFWorkbook();
sheet = wb.createSheet("Excel Sheet");
HSSFRow rowhead = sheet.createRow((short)0);
rowhead.createCell((short) 0).setCellValue("ID");
rowhead.createCell((short) 1).setCellValue("First Name");
rowhead.createCell((short) 2).setCellValue("Last Name");
rowhead.createCell((short) 3).setCellValue("Address");
rowhead.createCell((short) 4).setCellValue("Contact No");
ADD=new JButton("Enter");
ADD.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String v1=text1.getText();
String v2=text2.getText();
String v3=text3.getText();
String v4=text4.getText();
String v5=text5.getText();
int ide=Integer.parseInt(v1);
int no=Integer.parseInt(v5);
September 28, 2010 at 10:57 AM
continue..
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect =DriverManager.getConnection("jdbc:odbc:access","","");
Statement st=connect.createStatement();
int i=st.executeUpdate("insert into Student(id,FirstName,LastName,Address,ContactNo) values("+ide+",'"+v2+"','"+v3+"','"+v4+"',"+v5+")");
JOptionPane.showMessageDialog(null,"Inserted Successfully");
ResultSet rs=st.executeQuery("select * from student");
int index=1;
while(rs.next()){
HSSFRow row = sheet.createRow((short)index);
row.createCell((short)0).setCellValue(rs.getInt(1));
row.createCell((short)1).setCellValue(rs.getString(2));
row.createCell((short)2).setCellValue(rs.getString(3));
row.createCell((short)3).setCellValue(rs.getString(4));
row.createCell((short)4).setCellValue(rs.getInt(5));
index++;
}
FileOutputStream fileOut = new FileOutputStream("c:/student.xls");
wb.write(fileOut);
fileOut.close();
}
catch(Exception ex){
System.out.println(ex);
JOptionPane.showMessageDialog(null,"Error");
}
}
});
f=new JFrame();
panel=new JPanel(new GridLayout(6,2));
panel.add(label1);
panel.add(text1);
panel.add(label2);
panel.add(text2);
panel.add(label3);
panel.add(text3);
panel.add(label4);
panel.add(text4);
panel.add(label5);
panel.add(text5);
panel.add(ADD);
f.add(panel,BorderLayout.CENTER);
f.setTitle("STUDENT DETAILS");
f.setVisible(true);
f.pack();
}
public static void main(String[]args){
FormDemo ff=new FormDemo();
}
}
Thanks
Related Tutorials/Questions & Answers:
javajava diff bt core
java and
java Advertisements
java java why iterator in
java if we for loop
Java Java Whether
Java is pure object oriented Language
JAVAJAVA how the name came for
java language as "
JAVA javajava explain technologies are used in
java now days and structure
java javajava different between
java & core
java javajava is
java open source
javajava what is
java reflection
java java in
java does not pointers concept but what is nullpointers in
java?
nullpointer is a runtime Exception
javawhat is the size of array in
java ? what is the size of array in
java ?
what is the mean of finalize in
java javajava why to set classpath in
java javajava RARP implementation using
java socket
javajava sample code for RARP using
java JavaJava how to do
java in command prompt
javajava how use
java method
javajava is
java purely object oriented language
javajava why multiple inheritance is not possible in
java javajava give a simple example for inheritance in
java javajava give a simple example for inheritance in
java javajava why to set classpath in
java javajava why to set classpath in
java javajava why to set classpath in
java java java What is ?static? keyword
javajava Does
java allows multiline comments
javajava Write a
java code to print "ABABBABCABABBA
javajava write a program in
java to acess the email
javajava send me
java interview questions
javajava what are
JAVA applications development tools
JavaJava Whether
Java is Programming Language or it is SOftware
javajava explain object oriented concept in
java java java difference between class and interface
JavaJava how to draw class diagrams in
java javajava write a
java program using filenotfoundexception
javajava how to edit text document by using
java
then how to edit starting and ending of text document by using
java javajava different between
java & core
java
print("code sample
java java how can use sleep in
java
which book learn of
java language
java java How to set
java Policy for applet using jdk 6
javajava pattern code for a given words
java pattern code for a given words pattern
javajava dear,
i want a field for date picker using
java/
java script
javajava create
java program for delete and update the details,without using database, just a normal
java program
javajava why methods in
java raise exceptions
Have a look at the following link:
Java Exceptions
javajava code to search the nodes how to write the
java code to search the nodes using routers
javajava online telephone directory i need coding for online telephone directory..by using
java....pls help me
javajava different between
java & core
java
print("code sample
javajava how to invoke one chart
java file from another
java file
javajava how to prepare the
java
Hi Friend,
If you want to learn how to install
java, creating and running a
java program then go through the following links:
http://www.roseindia.net/
java/beginners/index.shtml
http
javajava
java swing
Swing is a principal GUI toolkit for the
Java programming language. It is a part of the JFC (
Java Foundation Classes), which is an API for providing a graphical user interface for
Java programs
javajava what is the need of
java if
java is not there what will happen... work unless you have
Java installed, and more are created every day.
Java... to scientific supercomputers, cell phones to the Internet,
Java is everywhere!
http