|
|
| JSP Storing Data, Datatype vale in SQL |
Expert:effert
<p>Storing Data, Datatype vale in SQL </p> |
| Answers |
Storing Data, Datatype vale in SQL <br /><br /><html><br /><br /><head><br /><title>Current Date Insert value in database</title><br /></head><br /><br /><body><br /><br /><table border="1" width="50%" cellspacing="0" cellpadding="0"><br /> <tr><br /> <td width="100%"><br /> <h1><center>Current Date Insert value in Database</center></h1><br /> <form method="POST" action="InsertAction.jsp"><br /> <br /> <table border="1" width="100%" cellspacing="0" cellpadding="0"><br /> <tr><br /> <td width="50%" valign="right"><b>Name:</b></td><br /> <td width="50%"><input type="text" name="username" size="30"></td><br /> </tr><br /> <tr><br /> <td width="50%" valign="right"><b>Job-Position:</b></td><br /> <td width="50%"><input type="text" name="jobposition" size="30"></td><br /> </tr><br /> <tr><br /> <td width="50%" valign="right">&nbsp;</td><br /> <td width="50%" valign="right">&nbsp;</td><br /> </tr><br /> </table><br /> <p><input type="submit" value="Submit" name="B1"><br /> <input type="reset" value="Reset" name="B2"></p><br /> </form><br /> </td><br /> </tr><br /></table><br /></body><br /></html><br /><br /><br /><br /><br />Actionpage<br /><br />InsertAction.jsp<br /><br /><br /><%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %><br /><br /><%<br /><br />Connection con = null;<br /> String url = "jdbc:<a href="mysql://localhost:3306/""; target="_blank">mysql://localhost:3306/"</a>;;<br /> String db = "register";<br /> String driver = "com.mysql.jdbc.Driver";<br /> java.util.Date date;<br /> String s=null;<br /> try{<br /> Class.forName(driver);<br /> con = DriverManager.getConnection(url+db,"root","root");<br /> try{<br /> Statement st = con.createStatement();<br /> String username=request.getParameter("username");<br /> String jobposition=request.getParameter("jobposition");<br /> DateFormat dformat = new SimpleDateFormat("yyyy-MM-dd");<br /><br /> try{<br /> date = new java.util.Date(); <br /> s = dformat.format(date);<br /> System.out.println("Today = " + s);<br /> }<br /> catch(Exception e){<br /> e.getMessage();<br /> }<br /> int val = st.executeUpdate("insert user_details values('"+username+"','"+jobposition+"','"+s+"')");<br /> con.close();<br /> out.println("success");<br /> }<br /> catch (SQLException ex){<br /> System.out.println("SQL statement is not executed!");<br /> }<br /> }<br /> catch (Exception e){<br /> e.printStackTrace();<br /> }<br /><br />%><br />
|
Above given program, will help you in storing date in sql database.<br /><br />See how to insert data from html to sql database using JSP and Servlet here...<br /><a href="http://www.roseindia.net/answers/viewanswers/272.html"; target="_blank">http://www.roseindia.net/answers/viewanswers/272.html</a><br /><br />
|
Thank you for ur help
|
| More Questions |
|
|
Post Answers
Ask Question
Facing Programming Problem?
|
|
|
|
|
