data base question

Home Answers Viewqa Java-Interview-Questions data base question

QuestionAsk Questions?

kalavathi

data base question
1 Answer(s) 4 years and 4 months ago
Posted in : Java Interview Questions

View Answers

January 16, 2009 at 11:32 PM

Hi,

Query to create table "employee"

Create table employee(ID int,name nvarchar (10),salary int,start_date datetime,city nvarchar (10),region char (1))

Alter table "employee" with primary key :

ALTER TABLE Employee ADD CONSTRAINT PK_EmployeeID PRIMARY KEY (ID)

For any more information,Examples and Tutorials on Mysql visit to :

http://www.roseindia.net/mysql/

Thanks

Data base related question
Data base related question sir my table has only one element(that is pno),i am using ms-access as backend. i put only one element i want to retrieve that element .how can i retrieve that element,using jdbc technology. please

data base question - Java Interview Questions
data base question first we create a table with out create primary kay,after that i want to create same record with primary key,but no duplicate record,no deletion and after creation. Hi, Query to create

data base
data base how to connect coding in data base ? The given code connects JSP page to database. You need to import the mysql connection jar file to jdk as well as to the lib of tomcat. Moreover you need to set classpath

DATA BASE
DATA BASE Create a program to establish a connection to the PCTBC... the data using a J Table. Here is a code that connects to MySql... main(String[] args) { Vector columnNames = new Vector(); Vector data = new Vector

question
question Good Afternoon Sir, give me the source code to submit attendance to data base using System IP Address with system date and time.using JPanel+mysql+java

question
question i need a jsp/html program which includes drop down menu for leave types and a button for apply leave.and need another jsp to validate types of leave and then insert in to data base using mysql

question
question how to put every data base connections (selection,insertion ,updation and so on) in one jsp page and how to import that in other pages of one project

question
question good afternoon sir, i need a jsp/html program which includes drop down menu for leave types and a button for apply leave.and need another jsp to insert types of leave which is selected by the user ,in to data base

question
question good afternoon sir, i have a project in jsp which contains attendance marking.i could mark present successfully but i want to list absentees.i need a jsp code to insert absent,half day leave in to data base while user

Data base Connectivity
Data base Connectivity How to configure JDBC connection for Oracle data base.In configuring it is asking select Data server name and TNS.I typed Oracle for Data Server Name and IN TNS what to type? I pulled the list for TNS

JSP data base validation
JSP data base validation please explain how to validate form input string with database n also how its notify that entered data exists already... bol = ps.execute(); out.println("Data Added Successfully

Data base - JDBC
Data base I want to do this Inserting a record with Object type column using PreparedStatement but wht should b the column datatype this is te..."); con.close(); }//main }//class For this should i create a user defined data type

please send me the banking data base in swings
please send me the banking data base in swings sir, please send me how to create the banking data base program in swings

for store data in data base - JSP-Servlet
for store data in data base i want to a job site, in this site user can registered by a form.. in this form there are his information... i use..... and on 3rd form i use submit button... data of form 1 and 2 can also be store

Retrive the data from the table in data base using jdbc
Retrive the data from the table in data base using jdbc Retrive the data from the table in data base using jdbc JDBC Tutorials

insert excel value in to oracle data base
insert excel value in to oracle data base Hi All I am using...); System.out.println("Data is inserted... the data from the excel file using JDBC. For this you need to create dsn

Lang and Util Base Libraries
Lang and Util Base Libraries The Base libraries provides us the fundamental features and functionality of the Java platform. Lang and Util Packages Lang... and fetch/ retrieve preferences of system and user and also data

java code for threading example for connecting data base
java code for threading example for connecting data base Write a program that has two threads First thread queries the database and fetches all the employee records from the emp table. Stores the employee objects

when refreshing the page the data is stored in data base again
when refreshing the page the data is stored in data base again Hi, In my application, I am adding form data in database on click of submit button.But the problem is, when user refreshes the page, the data added one more time

Other Base Packages
Other Base Packages I/O For handling i/o of an application in java , java.io & java.nio package is available. Object Serialization Object... for processing of XML data and documents. Java Native Interface (JNI) JNI stands for Java

Retrieving data from data base using jsp combo box
Retrieving data from data base using jsp combo box Hi guys please help me , i have on GUI page int that Server type(like apache,jboss,weblogic) one combo box is there and another filed is version of the server(like 1.0,2.0) like

retrive data from data base and print it in every page until logout
retrive data from data base and print it in every page until logout suppose that a user login your website through user name & password. now after completion of login he goto home page.inside home page i want to print

JAVA QUESTION
ENTER THE DATA THAT WILL BE SUCCESSFULLY SAVED INTO DATA BASE WITH OUT WRITING... THE DYNAVALIDATORACTIONFORM THIS WILL BE SUCCESFULL. NOW MY REQUIERMENT IS TO GET DATA FROM DATABASE AND SEND TO USER IN FORM LIKE WITH OUT PRINTING DATA IT WILL RETURN LIKE A DATA

data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp with script of data base plz help me

question
question how to insert data in to table using bean + jsp

question
question sir, i need a jsp+mysql query to select data from two table for a perticular user eg:select data from employee and leave table for john.please help me

question
question how do i select four late from data base.late represents 'L

question
question I am doing a project using struts framework and spring jdbc .I have a issue that when data is inserted into database if we click the refresh button then the same data is again inserted in to the database.What

question
question i need a jsp and mysql program to retrieve data from employee table and attendance table using user name and password at a time

question
question i need to select data from database using mysql+java script+html Please specify some more details

question
question how to solve this problem com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect time value: ' 0:34:13 PM' for column 'afternoon' at row 1

question
question Sir, Could You please send me Data Flow Diagrams(DFD) for " A DISTRIBUTED PROTOCOL TO SERVE DYNAMIC GROUPS FOR PEER-TO-PEER STREAMING

Question
Question Sir, give me a Java program to read data from keyboard up to names , sort in alphabetical order using bubble sort

question
question i need a jsp and mysql program to retrieve data from employee table and attendance table using user name and password at a time for a Sign in user

Question
Question Sir, please help me to write a JAVA program to read data from keyboard up to names and sort in alphabetical order using bubble sort

question
question how to retreive data from database of a particular user after login using jsp+hiberante+struts configuration. Please go through the following links: http://www.roseindia.net/struts/hibernate-spring

question
question Good morning sir , we employ the following support formula, which is inspired by the well-known problem of finding frequent item sets in data mining [7], to measure the interestingness of a particular keyword/phrase ci

question
)); } for(StudentData data:list){ if(data.getMarks()>=60... record: "); int rec=input.nextInt(); for(StudentData data:list

question
void handleText(final char[] data, final int pos) { list.add(new String(data)); } public void handleStartTag(Tag... handleComment(final char[] data, final int pos) { } public void

question
question hi good morning. how to retrive the data from one form of jsp to another form.please help me Hi Friend, Try the following code: 1)form1.jsp: <html> <form method="post" action="form2.jsp"> <

getting int values from form and insert it in data base in jsp
getting int values from form and insert it in data base in jsp how... = Integer.parseInt(s); Then you can write JDBC code to insert data...=st.executeUpdate("insert into data(name,age, address) values('"+name+"',"+age

How to create a Student data base using Linked List in java
How to create a Student data base using Linked List in java I want a program by using linked list in java. The data stored must... no to display: "); String rec=input.next(); for(StudentData data:list

J2ME Record Data Base
J2ME Record Data Base This Application is used to explain how to store data in the database... the RecordStore class. The RecordStore class is used to get the data through

how to insert the bulk data into the data base from the table of jsp page to another jsp page
how to insert the bulk data into the data base from the table of jsp page to another jsp page pls help i'm doing the project called centralized... to insert the marks details into the data base i have retrive the rollno and name

Core Java Interview Question, Interview Question
Core Java Interview Question Page 25 Question: What are null or Marker..., this is to convey the compiler that they have to be treated differently Question

project related question
project related question 1- how to insert a date through hibernate 2- how to insert exact time ,date separetly in the data base for current time date

Core Java Interview Question, Interview Question
data contained in any part of a file. Question: What happens when you add a double... Core Java Interview Question Page 21 Question: How are the elements of a GridLayout

C++ Question 2
data members from base class 2.create class. Shape accepts two values... area of Triangle and rectangle using data members from base class. Use one virtual function to display data. The given code defines a base class

Core Java Interview Question, Interview Question
in data structure Question: What are 4 pillars of object oreinted... and code and the data is not exposed outside the object Question: What... Core Java Interview Question Page 24

Core Java Interview Question, Interview Question
the entire loop to be abandoned. Question: What is the base class from... wrong data or I/O problems Question: What are runtime exceptions Answer... Core Java Interview Question Page 29

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics