QuestionAsk Questions?
View Answers
January 13, 2009 at 5:17 AM
Hi friend,
<html>
<title>Content Application</title>
<head>
<script type="text/javaScript">
function validateForm(theForm){
if(theForm.name.value==""){
//Please enter username
alert("Please enter user Name!");
theForm.name.focus();
return false;
}
if(theForm.content.value==""){
//please enter content
alert("Please enter discription!");
theForm.content.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<center>
<table border="1" width="50%" cellpadding="0" cellspacing="0">
<tr>
<td width="100%">
<form method="POST" action="insertAction.jsp" onsubmit="return validateForm(this);">
<table border="1" width="100%" cellpadding="0" cellspacing="0">
<h1>Content Page Application</h1>
<tr>
<td width="50%"><b>Name:</b></td>
<td width="50%"><input type="text" name="name" size="30"></td>
</tr>
<tr>
<td width="50%"><b>Description:</b></td>
<td width="50%">
<textarea name="content" type="text" cols="40" rows="15" size=100>
</textarea>
</td>
</tr>
<tr>
<td><p><input type="submit" value="Sumbit" name="sumbit"></td>
<td><p><input type="reset" value="Clear" name="reset"></td>
</tr>
</table>
</p>
</form>
</td>
</tr>
</table>
</center>
</body>
</html>
------------------------------------
<html>
<title>Content Application</title>
<head>
<script type="text/javaScript">
function validateForm(theForm){
if(theForm.name.value==""){
//Please enter username
alert("Please enter user Name!");
theForm.name.focus();
return false;
}
if(theForm.content.value==""){
//please enter content
alert("Please enter discription!");
theForm.content.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<center>
<table border="1" width="50%" cellpadding="0" cellspacing="0">
<tr>
<td width="100%">
<form method="POST" action="insertAction.jsp" onsubmit="return validateForm(this);">
<table border="1" width="100%" cellpadding="0" cellspacing="0">
<h1>Content Page Application</h1>
<tr>
<td width="50%"><b>Name:</b></td>
<td width="50%"><input type="text" name="name" size="30"></td>
</tr>
<tr>
<td width="50%"><b>Description:</b></td>
<td width="50%">
<textarea name="content" type="text" cols="40" rows="15" size=100>
</textarea>
</td>
</tr>
<tr>
<td><p><input type="submit" value="Sumbit" name="sumbit"></td>
<td><p><input type="reset" value="Clear" name="reset"></td>
</tr>
</table>
</p>
</form>
</td>
</tr>
</table>
</center>
</body>
</html>
------------------------------------
January 13, 2009 at 5:18 AM
data insert action file:
<%@ page language="java" import="java.sql.*" %>
<%
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";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String name=request.getParameter("name");
String content = request.getParameter("content");
int val = st.executeUpdate("insert contentDetail values('"+name+"','"+content+"')");
con.close();
out.println("successfully insert data into database!");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
--------------------------
<%@ page language="java" import="java.sql.*" %>
<%
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";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String name=request.getParameter("name");
String content = request.getParameter("content");
int val = st.executeUpdate("insert contentDetail values('"+name+"','"+content+"')");
con.close();
out.println("successfully insert data into database!");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
--------------------------
January 13, 2009 at 5:19 AM
display content code:
<%@ page language="java" import="java.io.*, java.sql.*" %>
<html>
<head>
<title>display data</title>
</head>
<body>
<center>
<H1>Display Record From Database<H1>
<br>
<table border="1" cellpadding="0" cellspacing="0" width="500px" height="69">
<tr>
<td></td>
</tr>
<tr>
<td><b>Id<b></td>
<td><b>Name<b></td>
<td><b>Discription No<b></td>
</tr>
<%
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";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String sqlQuery = "Select * from contentDetail";
System.out.println("sqlQuery>>>>>>>" + sqlQuery);
ResultSet rs = st.executeQuery(sqlQuery);
int sno = 0;
while(rs.next()){
sno++;
%>
<tr style="background-color:#CCFFFF;">
<td><%=sno%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("content")%></td>
</tr>
<%
}
rs.close();
con.close();
st.close();
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
<a href="contentPage.html">Home Page</a>
</center>
</body>
</html>
------------------------------------
visit for more information:
http://www.roseindia.net/jsp/
Thanks.
Amardeep
<%@ page language="java" import="java.io.*, java.sql.*" %>
<html>
<head>
<title>display data</title>
</head>
<body>
<center>
<H1>Display Record From Database<H1>
<br>
<table border="1" cellpadding="0" cellspacing="0" width="500px" height="69">
<tr>
<td></td>
</tr>
<tr>
<td><b>Id<b></td>
<td><b>Name<b></td>
<td><b>Discription No<b></td>
</tr>
<%
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";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String sqlQuery = "Select * from contentDetail";
System.out.println("sqlQuery>>>>>>>" + sqlQuery);
ResultSet rs = st.executeQuery(sqlQuery);
int sno = 0;
while(rs.next()){
sno++;
%>
<tr style="background-color:#CCFFFF;">
<td><%=sno%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("content")%></td>
</tr>
<%
}
rs.close();
con.close();
st.close();
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
<a href="contentPage.html">Home Page</a>
</center>
</body>
</html>
------------------------------------
visit for more information:
http://www.roseindia.net/jsp/
Thanks.
Amardeep
Related Pages:
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
