QuestionAsk Questions?
Manoj Kumar Singh
Retrieve data from Database in JSP and JDBC connection.
View Answers
April 2, 2008 at 8:51 PM
retrivedata.jsp
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<html>
<head>
<title>Retrive value from database</title>
</head>
<body>
<table border="0" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h2><font color="#FF0033">Retrive data from database</font></h2>
<form method="POST" >
<table border="1" width="50%" cellspacing="0" cellpadding="0" bgcolor="#66FFCC">
<tr>
<td width="50%" valign="right"><b>ID</b></td>
<td width="50%" valign="right"><b>Employee Name</b></td>
<td width="50%" valign="right"><b>Position</b></td>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
String query = "SELECT * FROM emp_details";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
%>
<tr>
<td width="50%" valign="right"><%=rs.getInt("empno")%></td>
<td width="50%" valign="right"><%=rs.getString("empname")%><br/></td>
<td width="50%" valign="right"><%=rs.getString("job")%><br/></td>
</tr>
<%
}
rs.close();
con.close();
}
catch(SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
<%@ page language="java" import="java.sql.*,java.util.*,java.text.*" %>
<html>
<head>
<title>Retrive value from database</title>
</head>
<body>
<table border="0" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h2><font color="#FF0033">Retrive data from database</font></h2>
<form method="POST" >
<table border="1" width="50%" cellspacing="0" cellpadding="0" bgcolor="#66FFCC">
<tr>
<td width="50%" valign="right"><b>ID</b></td>
<td width="50%" valign="right"><b>Employee Name</b></td>
<td width="50%" valign="right"><b>Position</b></td>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
String query = "SELECT * FROM emp_details";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
%>
<tr>
<td width="50%" valign="right"><%=rs.getInt("empno")%></td>
<td width="50%" valign="right"><%=rs.getString("empname")%><br/></td>
<td width="50%" valign="right"><%=rs.getString("job")%><br/></td>
</tr>
<%
}
rs.close();
con.close();
}
catch(SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
%>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
April 8, 2008 at 4:04 PM
hi friend,
jsp only for view , we should use for presentation don t combine databse code and jsp, it is not good approach,use separate class for connection from that class get values.
jsp only for view , even html designers can do this, we are java programmers keep mind
jsp only for view , we should use for presentation don t combine databse code and jsp, it is not good approach,use separate class for connection from that class get values.
jsp only for view , even html designers can do this, we are java programmers keep mind
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
