thanks for reply..
actually the problem is ,
database -table -record is to be updated through linux, from where some text file has to be created and shell script is executed for storing the text file to database as record in single field.after storing the text file it has to be retrieved in browser using Jsp program.
so how i can replace the \n to <br \> tag when i dont have a \n in my text file. i really confused.
database table data shown
| total: used: free: shared: buffers: cached:
Mem: 515952640 510210048 5742592 0 2199552 118583296
Swap: 1077469184 572231680 505237504
MemTotal: 503860 kB
MemFree: 5608 kB
MemShared: 0 kB
Buffers: 2148 kB
Cached: 62224 kB
SwapCached: 53580 kB
Active: 382952 kB
ActiveAnon: 354608 kB
ActiveCache: 28344 kB
Inact_dirty: 72288 kB
Inact_laundry: 14928 kB
Inact_clean: 6720 kB
Inact_target: 95376 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 503860 kB
LowFree: 5608 kB
SwapTotal: 1052216 kB
SwapFree: 493396 kB
HugePages_Total: 0
HugePages_Free: 0
Hugepagesize: 4096 kB |
1 row in set (0.44 sec)
code attached
-
-
<%@ page import="java.sql.*" %>
-
<%@ page import="javax.servlet.*" %>
-
<%@ page import="javax.sql.*" %>
-
<%@ page import="javax.servlet.http.*" %>
-
-
<%
-
ResultSet rs=null;
-
Connection con =null;
-
%>
-
-
<html>
-
<head>
-
<h3>Sample Database Reterival</h3></head>
-
<table><tr><th>Memory Information</th></tr>
-
-
<body>
-
-
<%
-
try
-
{
-
Class.forName("com.mysql.jdbc.Driver");
-
con=DriverManager.getConnection("jdbc:mysql://192.168.1.8:3306/test","root","prastsys");
-
Statement st=con.createStatement();
-
rs=st.executeQuery("select * from charchk");
-
while(rs.next())
-
{
-
String mem=rs.getString(1);
-
%>
-
-
<tr>
-
<td>
-
<%
-
out.println(mem);
-
%>
-
<br>
-
</td>
-
<br>
-
</tr>
-
<%
-
}
-
%>
-
</table>
-
<%
-
}
-
catch(Exception e)
-
{
-
out.println(e);
-
}
-
%>
-
-
</body>
-
</html>
-
output from browser:
Sample Database Reterival
Memory Information
total: used: free: shared: buffers: cached:
Mem: 515952640 510210048 5742592 0 2199552 118583296 Swap: 1077469184 572231680 505237504
MemTotal: 503860 kB MemFree: 5608 kB MemShared: 0 kB Buffers: 2148 kB Cached: 62224 kB SwapCached: 53580 kB
Active: 382952 kB ActiveAnon: 354608 kB ActiveCache:
28344 kB Inact_dirty: 72288 kB Inact_laundry: 14928
kB Inact_clean: 6720 kB Inact_target: 95376 kB HighTotal: 0 kB HighFree: 0 kB LowTotal: 503860 kB LowFree: 5608 kB SwapTotal:
1052216 kB SwapFree: 493396 kB HugePages_Total: 0 HugePages_Free: 0 Hugepagesize: 4096 kB
--
this is what the output displayed in browser. there is no order /alignment has done when displayed but mysql shows the contents by one by one line in order .. so please tel me some detailed solution for this..
Thank you