JSP Storing Data, Datatype vale in SQL
Storing Data, Datatype vale in SQL
View Answers
February 28, 2008 at 2:54 PM
Storing Data, Datatype vale in SQL
<html>
<head>
<title>Current Date Insert value in database</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h1><center>Current Date Insert value in Database</center></h1>
<form method="POST" action="InsertAction.jsp">
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" valign="right"><b>Name:</b></td>
<td width="50%"><input type="text" name="username" size="30"></td>
</tr>
<tr>
<td width="50%" valign="right"><b>Job-Position:</b></td>
<td width="50%"><input type="text" name="jobposition" size="30"></td>
</tr>
<tr>
<td width="50%" valign="right"> </td>
<td width="50%" valign="right"> </td>
</tr>
</table>
<p><input type="submit" value="Submit" name="B1">
<input type="reset" value="Reset" name="B2"></p>
</form>
</td>
</tr>
</table>
</body>
</html>
Actionpage
InsertAction.jsp
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
String username=request.getParameter("username");
String jobposition=request.getParameter("jobposition");
DateFormat dformat = new SimpleDateFormat("yyyy-MM-dd");
try{
date = new java.util.Date();
s = dformat.format(date);
System.out.println("Today = " + s);
}
catch(Exception e){
e.getMessage();
}
int val = st.executeUpdate("insert user_details values('"+username+"','"+jobposition+"','"+s+"')");
con.close();
out.println("success");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
<html>
<head>
<title>Current Date Insert value in database</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h1><center>Current Date Insert value in Database</center></h1>
<form method="POST" action="InsertAction.jsp">
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" valign="right"><b>Name:</b></td>
<td width="50%"><input type="text" name="username" size="30"></td>
</tr>
<tr>
<td width="50%" valign="right"><b>Job-Position:</b></td>
<td width="50%"><input type="text" name="jobposition" size="30"></td>
</tr>
<tr>
<td width="50%" valign="right"> </td>
<td width="50%" valign="right"> </td>
</tr>
</table>
<p><input type="submit" value="Submit" name="B1">
<input type="reset" value="Reset" name="B2"></p>
</form>
</td>
</tr>
</table>
</body>
</html>
Actionpage
InsertAction.jsp
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
java.util.Date date;
String s=null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
String username=request.getParameter("username");
String jobposition=request.getParameter("jobposition");
DateFormat dformat = new SimpleDateFormat("yyyy-MM-dd");
try{
date = new java.util.Date();
s = dformat.format(date);
System.out.println("Today = " + s);
}
catch(Exception e){
e.getMessage();
}
int val = st.executeUpdate("insert user_details values('"+username+"','"+jobposition+"','"+s+"')");
con.close();
out.println("success");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
March 3, 2008 at 4:37 PM
Thank you for ur help
Related Tutorials/Questions & Answers:
Storing and retrieving data alongwith image in mysql db using jsp
Storing and retrieving data alongwith image in mysql db using jsp I want to store and retrieve the whole data as shown below in mysql db. I've put in my all efforts for building this jsp but I'm not able to understand where's
Storing and retrieving data alongwith image in mysql db using jsp I want to store and retrieve the whole data as shown below in mysql db. I've put in my all efforts for building this jsp but I'm not able to understand where's
Advertisements
Produces XML file but format not correct for storing data using JSP and XML
Produces XML file but format not correct for storing data using JSP and XML hii I have created a project using JSP and XML as database to store data entered by user in XML file ,It stores data entered in XML file
Produces XML file but format not correct for storing data using JSP and XML hii I have created a project using JSP and XML as database to store data entered by user in XML file ,It stores data entered in XML file
iphone storing and fetching data
iphone storing and fetching data How to store and fetch data in an iphone application
iphone storing and fetching data How to store and fetch data in an iphone application
Storing and Reading data
Storing and Reading data Hello, I'm developing a GUI application as part of an assignment but stuck on how my program stores and reads the data... that limits the data type and the character size that can be entered
Storing and Reading data Hello, I'm developing a GUI application as part of an assignment but stuck on how my program stores and reads the data... that limits the data type and the character size that can be entered
storing data into flat files
storing data into flat files how can i retrive data from database and store data in flat files Hi Friend, Try the following code:ADS_TO_REPLACE_1 import java.io.*; import java.sql.*; import java.util.*; class
storing data into flat files how can i retrive data from database and store data in flat files Hi Friend, Try the following code:ADS_TO_REPLACE_1 import java.io.*; import java.sql.*; import java.util.*; class
storing data in xml - XML
storing data in xml Can u plz help me how to store data in xml using java Hi Friend, Try the following code: import java.io.*; import java.util.*; import org.w3c.dom.*; import javax.xml.parsers.*; import
storing data in xml Can u plz help me how to store data in xml using java Hi Friend, Try the following code: import java.io.*; import java.util.*; import org.w3c.dom.*; import javax.xml.parsers.*; import
Storing Multiple image in sql using java
Storing Multiple image in sql using java Hi, How to store and retrieve a multiple image in sql using java but already i have created sql table if i want to insert a image while runtime execution. Can anyone tell me solution
Storing Multiple image in sql using java Hi, How to store and retrieve a multiple image in sql using java but already i have created sql table if i want to insert a image while runtime execution. Can anyone tell me solution
jsp code for storing login and logout time to an account
jsp code for storing login and logout time to an account I need simple jsp code for extracting and storing login and logout time in a database table...://www.roseindia.net/jsp/loginstatus.shtml
jsp code for storing login and logout time to an account I need simple jsp code for extracting and storing login and logout time in a database table...://www.roseindia.net/jsp/loginstatus.shtml
data fecth from data base in( sql 2000) htmlform and jsp
data fecth from data base in( sql 2000) htmlform and jsp hi iam using jsp and html form data fecth from database display the textbox help me i want whenever select from dropdown list select the projectname to display
data fecth from data base in( sql 2000) htmlform and jsp hi iam using jsp and html form data fecth from database display the textbox help me i want whenever select from dropdown list select the projectname to display
how to insert array data into sql server using jsp
how to insert array data into sql server using jsp hello, i have problem to insert array data into my sql server from jsp form. beloW is my code... from form, but not insert into my sql database. try { //String
how to insert array data into sql server using jsp hello, i have problem to insert array data into my sql server from jsp form. beloW is my code... from form, but not insert into my sql database. try { //String
to fetch data from ms word and storing into database
to fetch data from ms word and storing into database i want to know how to fetch datafields from ms word and storing into database??? please answer soon .its urgent
to fetch data from ms word and storing into database i want to know how to fetch datafields from ms word and storing into database??? please answer soon .its urgent
how to use float datatype in mysql? - SQL
how to use float datatype in mysql? how to use float datatype in mysql? hi Chitra this code help u CREATE TABLE `paging` ( `Id` float(10,2) NOT NULL default '0.00', `name` varchar(255) default NULL
how to use float datatype in mysql? how to use float datatype in mysql? hi Chitra this code help u CREATE TABLE `paging` ( `Id` float(10,2) NOT NULL default '0.00', `name` varchar(255) default NULL
jsp - JDBC
JSP Storing Data, Datatype vale in SQL Storing Data, Datatype vale in SQL Storing Data, Datatype vale in SQL <html><head>..., will help you in storing date in sql database.See how to insert data from html
JSP Storing Data, Datatype vale in SQL Storing Data, Datatype vale in SQL Storing Data, Datatype vale in SQL <html><head>..., will help you in storing date in sql database.See how to insert data from html
SQL and JSP
using sql data base.. 2.JSP pages 1.login screen which will have user id...SQL and JSP 1.sql database 1.store login and password details... with the data is backend(data base)..if match found,then opehs next page or else show
using sql data base.. 2.JSP pages 1.login screen which will have user id...SQL and JSP 1.sql database 1.store login and password details... with the data is backend(data base)..if match found,then opehs next page or else show
getting and storing dropdown list in database in jsp
getting and storing dropdown list in database in jsp i have a drop... into data(language) values('"+selectedValue+"')"); out.println("Data... lyk this. but it storing null value in the database. :\ what to do
getting and storing dropdown list in database in jsp i have a drop... into data(language) values('"+selectedValue+"')"); out.println("Data... lyk this. but it storing null value in the database. :\ what to do
jsp -sql - JSP-Servlet
jsp -sql Hello Sir/Madam, Please send me the error in the following sql code if any. I did not get any error message and iam not getting... by entrydate" What is the data type of "entrydate" if "entrydate" is Date type
jsp -sql Hello Sir/Madam, Please send me the error in the following sql code if any. I did not get any error message and iam not getting... by entrydate" What is the data type of "entrydate" if "entrydate" is Date type
storing details in database on clicking submit button - JSP-Servlet
storing details in database on clicking submit button I am using JSP......Tell me where an what code should I write to store the values in data base table? JSP Page Name
storing details in database on clicking submit button I am using JSP......Tell me where an what code should I write to store the values in data base table? JSP Page Name
Data Conversion In Sql Server 2005
Data Conversion In Sql Server 2005 Hi I am working vb.net & sql server 2005 database. I am storing date (MM/DD/YYYY) format. now I have problem in sql date conversion (DD/MM/YYYY). Can you help how to convert date
Data Conversion In Sql Server 2005 Hi I am working vb.net & sql server 2005 database. I am storing date (MM/DD/YYYY) format. now I have problem in sql date conversion (DD/MM/YYYY). Can you help how to convert date
sql/xml query in jsp - JSP-Servlet
sql/xml query in jsp Sir I am coding in jsp and trying to retrieve xml data from db2 using sql/xml query in jsp but getting no result. When running jsp file in browser the output
sql/xml query in jsp Sir I am coding in jsp and trying to retrieve xml data from db2 using sql/xml query in jsp but getting no result. When running jsp file in browser the output
Transfer Data to Sql Database
Transfer Data to Sql Database Hey guys, how to Transfer data to SQl database using Java? Transfer data already stored in excel to Sql databse using Java? Looking for an easier method so i can comprehend
Transfer Data to Sql Database Hey guys, how to Transfer data to SQl database using Java? Transfer data already stored in excel to Sql databse using Java? Looking for an easier method so i can comprehend
retriving data from sql server using jsp code and placing them in text fields of html code
retriving data from sql server using jsp code and placing them in text fields of html code Hi, my question is how to retrieve data from sql server 2008 using a jsp file and place the values in the text fields of a html file
retriving data from sql server using jsp code and placing them in text fields of html code Hi, my question is how to retrieve data from sql server 2008 using a jsp file and place the values in the text fields of a html file
SQL Decimal
SQL Decimal SQL Decimal is used to specify the values in decimal datatype. The Decimal datatype... point (p,s). The DECIMAL data type can store decimal floating-point numbers up
SQL Decimal SQL Decimal is used to specify the values in decimal datatype. The Decimal datatype... point (p,s). The DECIMAL data type can store decimal floating-point numbers up
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing. <html> <..."> <title>JSP Page</title> <style type
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing. <html> <..."> <title>JSP Page</title> <style type
jsp sql server 2005 connectivity
jsp sql server 2005 connectivity your jsp mysql tutorial is very help full.Please tell me how to connect jsp with SQL server 2005
jsp sql server 2005 connectivity your jsp mysql tutorial is very help full.Please tell me how to connect jsp with SQL server 2005
sql exception - JSP-Servlet
sql exception Dear sir , I am working in a web-based project, In my system it is working fine but at client side getting the following...: no data passed to obfuscation toolkit ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT
sql exception Dear sir , I am working in a web-based project, In my system it is working fine but at client side getting the following...: no data passed to obfuscation toolkit ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT
JSP SQL Error
JSP SQL Error Hi While trying to execute the below code i'm getting the following error "java.sql.SQLException: Io exception: Got minus one from a read call ". please help me out. <% try{ String Username
JSP SQL Error Hi While trying to execute the below code i'm getting the following error "java.sql.SQLException: Io exception: Got minus one from a read call ". please help me out. <% try{ String Username
Import Data to SQL database in Java
Import Data to SQL database in Java Hi, I'm a beginner and I'm wondering how to Import Data to SQL database in Java? Thanks (Platform: Eclipse/SQL
Import Data to SQL database in Java Hi, I'm a beginner and I'm wondering how to Import Data to SQL database in Java? Thanks (Platform: Eclipse/SQL
sql/xml query in jsp - JSP-Servlet
sql/xml query in jsp Sir Here is my code which is not working Testing JSP select id from "SYSTEM..." name:PROFILE columns:id (bigint) and INFO (xml) data stored:id=1 and info=nitin
sql/xml query in jsp Sir Here is my code which is not working Testing JSP select id from "SYSTEM..." name:PROFILE columns:id (bigint) and INFO (xml) data stored:id=1 and info=nitin
jsp data in excel - JSP-Servlet
jsp data in excel i have create jsp page which has button for excel.this calls jsp which contains code which has and then code for present data in jsp using table. and getting this data from servlet which has query
jsp data in excel i have create jsp page which has button for excel.this calls jsp which contains code which has and then code for present data in jsp using table. and getting this data from servlet which has query
Inserting Data into mysql - SQL
Inserting Data into mysql My sincere apologize for this post. I noticed there is no category for php. However am hoping my question will fit into the SQL category though under php. I need help with reading from a csv file
Inserting Data into mysql My sincere apologize for this post. I noticed there is no category for php. However am hoping my question will fit into the SQL category though under php. I need help with reading from a csv file
SQL Query - JSP-Servlet
SQL Query AS mysql backend updation query shows a syntax error. I gave the full query and the generated error here. Please send me the correct... SQL syntax; check the manual that corresponds to your MySQL server version
SQL Query AS mysql backend updation query shows a syntax error. I gave the full query and the generated error here. Please send me the correct... SQL syntax; check the manual that corresponds to your MySQL server version
data grid - JSP-Servlet
to implement data grid in jsp Thanks varun kumar Hi friend, I... information. http://www.roseindia.net/jsp/data-grid.shtml Thanks...data grid how can we implement data grid (we have data grid
to implement data grid in jsp Thanks varun kumar Hi friend, I... information. http://www.roseindia.net/jsp/data-grid.shtml Thanks...data grid how can we implement data grid (we have data grid
SQL error - JSP-Servlet
SQL error Hello friends, Can we update a column with referrence to that column value. For example, the query ----------------------------------------------------------------------------- "update feedback set msgid
SQL error Hello friends, Can we update a column with referrence to that column value. For example, the query ----------------------------------------------------------------------------- "update feedback set msgid
storing csv into oracle database
storing csv into oracle database i want jsp code for storing csv file into oracle database
storing csv into oracle database i want jsp code for storing csv file into oracle database
Datatype convertion
Datatype convertion it possible to convert long datatype into string in java if possible means how
Datatype convertion it possible to convert long datatype into string in java if possible means how
Mysql nchar Datatype
Mysql nchar Datatype MySQL nchar define the datatype nchar that stores fixed-length character data. The data can be a string single-byte or multibyte letters, digits
Mysql nchar Datatype MySQL nchar define the datatype nchar that stores fixed-length character data. The data can be a string single-byte or multibyte letters, digits
fetching data using servlets - SQL
fetching data using servlets I have successfully made connection with the oracle10g database that i am using and also able to put in data using JSP...-jsp-data-list.shtml Hope that it will be helpful for you. Thanks
fetching data using servlets I have successfully made connection with the oracle10g database that i am using and also able to put in data using JSP...-jsp-data-list.shtml Hope that it will be helpful for you. Thanks
data copy - SQL
data copy how to copy values of one column from one table into another column of another table? Hi INSERT INTO table_name (column_name) AS SELECT DISTINCT VALUES FROM table_name (column_name
data copy how to copy values of one column from one table into another column of another table? Hi INSERT INTO table_name (column_name) AS SELECT DISTINCT VALUES FROM table_name (column_name
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...("sName"); String phno = request.getParameter("phno"); String sql = "insert
JSP data base validation please explain how to validate form input string with database n also how its notify that entered data exists already...("sName"); String phno = request.getParameter("phno"); String sql = "insert
data are not display in JSP from database - JSP-Servlet
data are not display in JSP from database i want to finding some data through a SQL query from SQL server database to a JSP page based on some... of this jsp page. like.. School Result and three request parameters 'class', 'from
data are not display in JSP from database i want to finding some data through a SQL query from SQL server database to a JSP page based on some... of this jsp page. like.. School Result and three request parameters 'class', 'from
delete data from database - SQL
delete data from database HOw to delete specific data from table> I want to delete one record from database. Thnx Hi friend.... http://www.roseindia.net/jsp/user-search.shtml Thanks
delete data from database HOw to delete specific data from table> I want to delete one record from database. Thnx Hi friend.... http://www.roseindia.net/jsp/user-search.shtml Thanks
data grid - JSP-Servlet
data grid i am trying to do the example in the following link http://www.roseindia.net/jsp/data-grid.shtml but i am not able to find... this example Hi friend, To visit again http://www.roseindia.net/jsp/data
data grid i am trying to do the example in the following link http://www.roseindia.net/jsp/data-grid.shtml but i am not able to find... this example Hi friend, To visit again http://www.roseindia.net/jsp/data
correct the sql error and retrive data....plez
correct the sql error and retrive data....plez i am getting a SQL Error while retriving data from access to jframe called "datatype mismatch in criteria expression" plez do help me and studentId's datatye is number
correct the sql error and retrive data....plez i am getting a SQL Error while retriving data from access to jframe called "datatype mismatch in criteria expression" plez do help me and studentId's datatye is number
Java servlet with jsp on sql server
Java servlet with jsp on sql server How to delete a user by an admin with check box in Java Servlet with jsp on Sql Server? Here is a jsp example that can delete the multiple record from the database by selecting
Java servlet with jsp on sql server How to delete a user by an admin with check box in Java Servlet with jsp on Sql Server? Here is a jsp example that can delete the multiple record from the database by selecting
ModuleNotFoundError: No module named 'phovea_data_sql'
ModuleNotFoundError: No module named 'phovea_data_sql' Hi, My... named 'phovea_data_sql' How to remove the ModuleNotFoundError: No module named 'phovea_data_sql' error? Thanks Hi, In your python
ModuleNotFoundError: No module named 'phovea_data_sql' Hi, My... named 'phovea_data_sql' How to remove the ModuleNotFoundError: No module named 'phovea_data_sql' error? Thanks Hi, In your python
Ads
