Date operation

Home Answers Viewqa JDBC Date operation

QuestionAsk Questions?

Deebapriya

Date operation
1 Answer(s) 4 years and 11 months ago
Posted in : JDBC

View Answers

July 15, 2008 at 6:38 PM

Hi friend,

<html>
<head>
<title>registration form in jsp</title>
</head>

<body>
<table border="1" width="50%" bgcolor="pink">
<tr>
<td width="100%">
<form method="POST" action="dateCastAction.jsp" >

<h2 align="center">Employee registration form</h2>
<table border="1" width="100%">
<tr>
<td width="50%"><b>User id:</b></td>
<td width="50%"><input type="text" name="userid" size="5"/> </td>
</tr>
<tr>
<td width="50%"><b>Employee Name:</b></td>
<td width="50%"><input type="text" name="name" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Department Name:</b></td>
<td width="50%"><input type="text" name="dept_name" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Date of Birth:</b></td>
<td width="50%"><input type="text" name="date" size="20"></td>
</tr>

</table>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset"></p>

</form>
</td>
</tr>
</table>
</body>
</html>
----------------------------------

dateCastAction.jsp

<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>

<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String userid=request.getParameter("userid");
String name=request.getParameter("name");
String dept=request.getParameter("dept_name");
String dat= request.getParameter("date");

int val = st.executeUpdate("insert userSearch values('"+userid+"','"+name+"','"+dept+"','"+dat+"')");
con.close();
out.println("Successfully insert Date into database.");
out.println("<br/><a href=searchForm.jsp><b>Back to Register Form</b></a>");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}

%>

--------------------------------------------

Thanks.

Date operation - JDBC
Date operation can anybody help me how to cast a java.util.Date... DateFormatTest { public static void main(String[] args) { Date date = Calendar.getInstance().getTime(); // Display a date in day, month, year format

Date operation - JDBC
Date operation The same what i asked already.Still i didnt get... the html text obj into sql Date obj? Hi friend, registration...: Department Name: Date of Birth

Calendar Operation
Calendar Operation I have a date - example - 22-09-2012(start date) I have to find my end date based on the current quarter My input are month... is 23, it falls tomorrow and is not yet over so my end date should be calculated

Searching operation in JAva
Searching operation in JAva Sir, I have made a project... on a particular date. Now there are thousands of letters dispatched on a particular date. I want to refine my search. Can anybody plz tell me how can I perform

how to do CRUDE operation in iphone?-RV
how to do CRUDE operation in iphone?-RV .h file #import <sqlite3.h> @interface RootViewController : UIViewController { IBOutlet... = "insert into photo_table(photo_name,photo_date) Values

SQL Date, SQL Date Examples
SQL Date Mysql Date Today The Tutorial illustrate an example from Date Today in My sql. The Query used in the below example the now

Parsing into date object
Parsing into date object Here is my code: String de = (String..."); Date d=new Date(); out.println(d); Date toDt; int oneDay = 24*60*60*1000; toDt.... But, it is showing error at the line where i performed parsing operation. Please help me

search operation - Java Beginners
search operation how to retrive all the similar elements (search operation ) on xml document using regular expressions

Insert Operation Error - WebSevices
Insert Operation Error Hai, How i store my full resume in database[Mysql] using PHP. Any one Know the code..... Help me

date
date how to insert date in database? i need coding

login/logout operation
login/logout operation how to do log in/out operations in jsp plz kindly send the steps leing behind this operation

Java code for buffer operation...!!!
Java code for buffer operation...!!! Implement a buffer operation using character array, storing last 100 characters inserted by user. Make method to get and retrieve??? The given code accepts the characters from

Add Years To Date
Add Years To Date This tutorial explains you how to add years to date. Java provides an easy way of date time manipulation by Calendar class. Through this class, you can add or subtract date, month and year as per your requirement

login/logout operation
login/logout operation how to do log in/out operations in jsp plz kindly send the steps leing behind this operation

arithmetic operation on float number
arithmetic operation on float number hi here is my code class divs { public static void main(String args[]) { double dub=14.2f,dou; int num; num=(int)dub; dou=dub-num

date
date can u tell me how to calculate difference between a user provided date and the system date in java

date
date i want difference between the date entered in a jtextfield and the system date in java

date
date how to insert date using html through the combobox

Insert Operation - WebSevices

Array List and string operation

DATE
DATE I have the following as my known parameter Effective Date... of calcultion starts My question is how to find the date of Thursday This cycle... the date of all the thursdays of the given year. import java.util.*; import

date

Mysql Time Operation
Mysql Time Operation Mysql Time Operation performs the subtraction and addition of time. Understand with Example The Tutorial illustrate an example from Mysql Time Operation

Java file read write operation

Push and Pop operation of stack.
Description: In this tutorial of data-structure you will see push and pop operation of stack. In the previous tutorial is clearly explained the push pop operation. The drawback of implementing stack is that the size of stack

PHP Date and Time Date and time Tutorial
both date and mktime function, you will be able to perform any time operation...Date and time Learn how to use PHP Date and Time functions To get formatted date and time value you can use date() function. It is very easy to pass any

Using JOINING Operation in JDBC
Using JOINING Operation in JDBC Whenever we need to select data from two or more tables, we have to perform a join operation. Tables in a database can be related to each other with keys

java.sql.SQLException: Operation not allowed after ResultSet closed
java.sql.SQLException: Operation not allowed after ResultSet closed package processing; import java.io.; import java.math.BigDecimal; import java.sql.; import java.util.*; public class Processing { public static void

Html+jsp+database is enough to do the small operation
Html+jsp+database is enough to do the small operation Hai , If u want to do simple insetion and data retrival operation throw jsp ?.you need not to bother about whole code.just u consentration on html,ajax,jsp,any db.here i

date format - Date Calendar
date format how to convert dd-mmm-yyyy date format to gregorian... to convert date to calender. import java.util.*; import java.text.*; public...="19-Sep-2008"; DateFormat format ; Date date ; format = new

PHP Mathematical Operation

Join tables with the NATURAL RIGHT JOIN operation
Join tables with the NATURAL RIGHT JOIN operation... the NATURAL RIGHT JOIN operation of table in a specific database. This operation join... the tables through the NATURAL RIGHT JOIN operation. See detail information given

Join tables with the NATURAL LEFT JOIN operation
Join tables with the NATURAL LEFT JOIN operation ... operation and how to retrieve data through it. In this operation we are going... JOIN: In this operation both tables are merged to each other according to common

Date format - Date Calendar
Date format please convert dd-mmm-yy date format to gregorian calendar date format. Hi friend, Code related your Problem: import...]); Calendar calendar = new GregorianCalendar(pdt); Date time = new Date

Setting the close button operation for the frame in Java
Setting the close button operation for the frame in Java Introduction In this section, you... automatically. The close button of the frame has to be set for the desired operation (i.e.

date - Date Calendar
date hi, sir i am doing student details project in swing but i am not getting current date in jtextfield in date it is giving ambigious error... label=new JLabel("Current Date: "); JTextField text=new JTextField(15

Date Formay - Date Calendar
Date Formay Sir, How to comapare two different date format in java. Hi friend, Code to compare two different date import...)) System.out.print("Current date(" + new SimpleDateFormat("dd/MM/yyyy"). format

Date format - Date Calendar
Date format Hi All, I am getting a date from database as a format 2010-15-07.I need to change it to 07/15/2010 and display it on my date field.Every time i need to check the format of the date field and make sure the correct

Date limit on Dojo Date picker - Date Calendar
Date limit on Dojo Date picker Hi all, I am using dojo for date picker in my project. When user click on date text box, date picker will pop up. Using that component user can select date. Now I trying something different. I

convert current date into date format
convert current date into date format How to get current date and convert into date format in Java or PHP

date convertion
date convertion How to convert the string date format 23/11/2009 to original date format in asp.net

Mysql Date from Date
Mysql Date from Date Mysql Date from Date Time in Mysql return the Current date...'. To grasp this example, we use date(current_trimestamp ( )) query that return

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