retrieve message contents

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>
------------------------------------

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();
}

%>

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

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