QuestionAsk Questions?
Shridhu Chandel
View Answers
March 21, 2009 at 2:38 AM
Hi friend,
Code to help in solving the problem :
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">;
<%@ page import="java.sql.*,java.text.*,java.util.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>Connection with mysql database</title>
</head>
<body>
<h1>Connection status </h1>
<table>
<tr><td>Item Name</td><td>Company</td><td>Address</td></tr>
<%
try {
Date date = new Date();
// Some examples
Format formatter = new SimpleDateFormat("yyyy-MM-dd");
String currentdate = formatter.format(date);
/* Create string of connection url within specified format with machine name,
port number and database name. Here machine name id localhost and
database name is usermaster. */
String connectionURL = "jdbc:mysql://localhost:3306/usermaster";;
// declare a connection by using Connection interface
Connection connection = null;
// Load JBBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes parameters of
string type connection url, user name and password to connect to database. */
connection = DriverManager.getConnection(connectionURL, "root", "root");
Statement stmt = connection.createStatement();
String query = "select * from table where itemdate='"+currentdate+"'";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
%>
<tr><td><%=rs.getString("item_name")%></td><td><%=rs.getString("company")%></td><td><%=rs.getString("address")%></td></tr>
<%
}
}
catch(Exception ex){
%>
</font>
<font size="+3" color="red"></b>
<%
out.println("Unable to connect to database.");
}
%>
</table>
</font>
</body>
</html>
Thanks
Code to help in solving the problem :
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">;
<%@ page import="java.sql.*,java.text.*,java.util.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>Connection with mysql database</title>
</head>
<body>
<h1>Connection status </h1>
<table>
<tr><td>Item Name</td><td>Company</td><td>Address</td></tr>
<%
try {
Date date = new Date();
// Some examples
Format formatter = new SimpleDateFormat("yyyy-MM-dd");
String currentdate = formatter.format(date);
/* Create string of connection url within specified format with machine name,
port number and database name. Here machine name id localhost and
database name is usermaster. */
String connectionURL = "jdbc:mysql://localhost:3306/usermaster";;
// declare a connection by using Connection interface
Connection connection = null;
// Load JBBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes parameters of
string type connection url, user name and password to connect to database. */
connection = DriverManager.getConnection(connectionURL, "root", "root");
Statement stmt = connection.createStatement();
String query = "select * from table where itemdate='"+currentdate+"'";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
%>
<tr><td><%=rs.getString("item_name")%></td><td><%=rs.getString("company")%></td><td><%=rs.getString("address")%></td></tr>
<%
}
}
catch(Exception ex){
%>
</font>
<font size="+3" color="red"></b>
<%
out.println("Unable to connect to database.");
}
%>
</table>
</font>
</body>
</html>
Thanks
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
