 |
 |
 |
 |
 |
 |
 |
|
 |
 |
<%
String chSQL="select * from bizz_tip";
String count="none",db_tip_d_o_e="",db_tip_title="",db_tip_author="",db_tip_description="";
String smessagesErr="";
//out.println(chSQL+"
");
java.sql.Connection conn = null;
java.sql.Statement stat = null;
String sErr = loadDriver();
conn = cn();
stat = conn.createStatement();
if ( ! sErr.equals("") ) {
try {
out.println(sErr);
}
catch (Exception e) {
out.println(e.toString());
}
}
try {
// Execute SQL statement
java.sql.ResultSet rs = null;
rs = openrs( stat, chSQL);
out.println("Daca am intrebari, pe cine contactez?
Pentru orice intrebari contactati-ne la office@bizangels.ro
");
while (rs.next())
{ count="yes";
db_tip_d_o_e=rs.getString("tip_d_o_e");
db_tip_title=rs.getString("tip_title");
db_tip_author=rs.getString("tip_author");
db_tip_description=rs.getString("tip_description");
db_tip_description = replace(db_tip_description,CRLF,"
");
out.println("");
out.println("Data Publicarii :"+db_tip_d_o_e+"
");
out.println("Titlu :"+db_tip_title+"
");
out.println("Autor :"+db_tip_author+"
");
out.println("Descriere :"+db_tip_description+"
");
out.println(" |
");
}//end while
if(count.equalsIgnoreCase("none"))
{out.println("");
out.println("Nici un rezultat in baza de date
|
");}
if ( rs != null ) rs.close();
if ( stat != null ) stat.close();
if ( conn != null ) conn.close();
}//end try
catch(java.sql.SQLException e) {
smessagesErr = e.toString();
out.println(smessagesErr);
}
%>
|
 |
 |
 |
 |
 |
 |
 |
|
