save switch data into database 1 Answer(s) 3 years and 8 months ago
Posted in : Java Beginners
View Answers
October 9, 2009 at 10:23 AM
Hi Friend,
Try the following code: import java.sql.*; import java.io.*; import java.util.*;
class Student{ public int id; public String name;
public Student(){} public Student(int id, String name) { super(); this.id = id; this.name = name; } public int getId() { return id; } public String getName() { return name; } } public class RegistrationSystem {
public static void main(String[] args) throws Exception { List<Student> list = new ArrayList<Student>(); list.add(new Student(1, "A")); list.add(new Student(2, "B")); list.add(new Student(3, "C")); list.add(new Student(4, "D"));
Scanner scan = new Scanner(System.in); int menu = 0; System.out.println("School Registration System Main Menu"); System.out.println(); System.out.println("1. Add a student"); System.out.println("2. Remove a student"); System.out.println("3. Display student list"); System.out.println("4. Exit"); boolean quit = false; do{ System.out.print("Please enter your choice: "); menu = scan.nextInt(); System.out.println();
switch(menu) { case 1: System.out.print("Enter student ID: "); int ID = scan.nextInt(); System.out.print("Enter your name: "); String name= scan.next(); list.add(new Student(ID,name)); for (Student s : list){ System.out.println(s.getId()+" " +s.getName()); } try{ Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root"); Statement st=con.createStatement(); int i=st.executeUpdate("insert into student values('"+ID+"','"+name+"')"); } catch(Exception e){}
break; case 2: System.out.print("Enter Student id to remove the student from list: "); int id = scan.nextInt(); int i=id-1; list.remove(i); break; case 3: System.out.println("Id Name"); for (Student s : list){ System.out.println(s.getId()+" " +s.getName()); } break; case 4: quit = true; break; default: System.out.println("Invalid Entry!"); } }
while (!quit); } }
Thanks
Related Pages:
save switch data into database - Java Beginners saveswitchdata into database switch(menu) {
case 1://add a student
System.out.print("Enter student ID: ");
int ID = scan.nextInt...();
switch(menu) {
case 1:
System.out.print("Enter student ID: ");
int ID
To save table format data in pdf/excel in jsp
To save table format data in pdf/excel in jsp Hello,
I am doing web application project in jsp. In webform ,I am displaying databasedata in html table. So my question is ,I want so save this html format data in pdf/excel format
Save JRadioButton Text in to database - Java Beginners Save JRadioButton Text in to database Hello Sir I have Two JaradioButtons
1)Semwise Course
2)Yearwise Course
I want To Save Text from...();
JOptionPane.showMessageDialog(null,"Data is successfully inserted into database.");
}
catch
code save word file in 10g database - SQL
code save word file in 10g database I am not having any idea to save the whole word document in Oracle 10g. Please help me. Hi Friend...(file);
pstmt = conn.prepareStatement("insert into file( file, file_data
Insert image from user using and save in database
Insert image from user using and save in database when i am trying to upload a image from user and trying to save into oracle9i database....
Apache Tomcat/6.0.29 We have used MySQl database.
1)page.jsp:
<
Switch Statement Switch Statement How we can use switch case in java program ?
Note:-Switch case provides built-in multiway decision statement.It...");
String data = br.readLine();
days= Integer.parseInt(data
save data in excel savedata in excel hello sir,
i'm new to this field i want to know can i savedata in excel by html forms input,means if any one fill up form online then it is save offline in excel how can i do it can you give me solution sir
save data in excel savedata in excel hello sir,
i'm new to this field i want to know can i savedata in excel by html forms input,means if any one fill up form online then it is save offline in excel how can i do it can you give me solution sir
how to show data in database ?
how to show data in database ? how to show the data in the database to the user in the textbox so that user can modify it and save it again
save data DAO savedata DAO how to savedata in db
package com.tcs.ignite.dao;
import com.tcs.ignite.bean.User;
import com.tcs.ignite.connection.Connectiondetails;
import java.sql.ResultSet;
import java.sql.SQLException;
import
How i upload file and save that record in database using JSP?
How i upload file and save that record in database using JSP? Hi All,
I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database.
Ex. There is one employee detail form
How to save form data to a csv file using jquery or ajax
How to save form data to a csv file using jquery or ajax Please let...)
{// code for IE7+, Firefox, Chrome, Opera, Safari
data=new XMLHttpRequest();
}
else
{// code for IE6, IE5
data=new ActiveXObject
retrive data from database?
retrive data from database? hellow
i have a database sheet name as db1. it's contain sixty(60) sn,name ,rollno(primary key),father's name etc... from db1 and enter value in text box according there name,rollno and save
Java save file to database
Java save file to database
In this section, you will learn how to insert file to database.
Description of code:
Firstly, we need to establish a connection between MySql database and java
file with the help of various types of APIs
How to save data - Swing AWT
How to save data Hi,
I have a problem about how to savedata ,but
first before datasave to dababase, data must view in jLisit or Jtable... savedata from jList and Jtable(in jList or jTable data will be many).Thank's
GWT -- retrive the data from Database
GWT -- retrive the data from Database the user can create an event. In the create page, we have three buttons. Save as draft, preview and save and post buttons. Once the user entered all the datas and if he clicks the Preview
Save the input data until user get changed Save the input data until user get changed I would like to know how to store the give input data and perform the calculations even after re-opening... and save this amount until he changes it again.
Thank You
Save the input data until user get changed Save the input data until user get changed I would like to know how to store the give input data and perform the calculations even after re-opening... and save this amount until he changes it again.
Thank You
How can we save a data list in jsf?
How can we save a data list in jsf? I have a code in jsf that fires a query in Data Base each time it is called, i have added a validation check... it is called again. I tried using save State but it did not help as other functions got
Save the input data until user get changed Save the input data until user get changed I would like to know how to store the give input data and perform the calculations even after re-opening... and save this amount until he changes it again.
Thank You
SQL database parameters should save at where?
SQL database parameters should save at where? Hi,
Currently... the script will be running for very long time,
I like to move the SQL database..., if there is a database changed (hostname, username or password)
It should
Save Table - SQL Save Table Where Oracle Tables or Database is saved?
How to see Oracle Tables ?
What are the websites to learn step by step Oracle.
Help Me
how to save uploaded image in database using javascript
how to save uploaded image in database using javascript Please can you tell me how to store uploaded image in database using java I'll use...;
Now i want to store it on database...
Please help me
Thanks in Advance
SQLGrammarException while trying to save data in db
SQLGrammarException while trying to savedata in db //hibernate cfg file//
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN
image save to folder in java
image save to folder in java Hi,
I am working with java. In my application i want to give facility to user to add and change image. I use open... folder and that path stored into database, for furhter retrivation.
Please guide me
Export Database table to CSV File
Export Database table to CSV File
In this tutorial, you will learn how to retrieve data from database and save
it to CSV File.
The Comma-separated values... a normal
text file, and save the fetched data to it. There is no need to use any
Display Data from Database in JSP
, to show data from the database
click on the link that calls another .jsp file named...;body>
<h2>Data from the table 'stu_info' of database 'student'</h2...;
<html>
<head>
<title>display data from
Java Switch Statement
Java Switch
Statement
In java, switch is one of the control statement which
turns the normal flow... then switch statement can be used. It checks your choice and
jump on that case label
how to insert data in database using html+jsp
how to insert data in database using html+jsp anyone know what... and database name. Here machine name id localhost and
database name... = null;
// declare a resultset that uses as a table for output data from
what is the jsp coding to insert a data in database tables
what is the jsp coding to insert a data in database tables Dear Sir,
I Want to know the coding for insert the data from jsp to oracle database.. my... departmentname and departmentid and click submit i want to save this data in my
Insert XML file data to database
to read the xml file data and save the values
of an XML file to a Database...Insert XML file data to database
In this tutorial, you will learn how to insert the xml file data to database
using dom parser.
You all are aware of XML
Display Data from Database in JSP
Display Data from Database
in JSP
This is detailed java program to connect java
application with mysql database... and run.
This page has a link, to show data from the database
click
Insert Image into Mysql Database through Simple Java Code
simple java code that how save image
into mysql database. Before running this java code you need to create data base and
table to save image in same database. In the example given below we have used
database 'mahendra' and table 'save
data update data update sir, I have a table consist of huge data.I have displayed that data in table format be side of a table an edit button which will edit the entire data which is retreived .After editing the data i want to save
data update data update sir, I have a table consist of huge data.I have displayed that data in table format be side of a table an edit button which will edit the entire data which is retreived .After editing the data i want to save
data update data update sir, I have a table consist of huge data.I have displayed that data in table format be side of a table an edit button which will edit the entire data which is retreived .After editing the data i want to save
data update data update sir, I have a table consist of huge data.I have displayed that data in table format be side of a table an edit button which will edit the entire data which is retreived .After editing the data i want to save
data update data update sir, I have a table consist of huge data.I have displayed that data in table format be side of a table an edit button which will edit the entire data which is retreived .After editing the data i want to save
data update data update sir, I have a table consist of huge data.I have displayed that data in table format be side of a table an edit button which will edit the entire data which is retreived .After editing the data i want to save
data update data update sir, I have a table consist of huge data.I have displayed that data in table format be side of a table an edit button which will edit the entire data which is retreived .After editing the data i want to save