Untitled

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>

<html>
<head>
<title>PARC AUTO</title>
</head>

<body background="images/black3.bmp">
<br />
<table border = "1" align = center width = "60%" height = "200">
	<tr height="180">
		<td  background="./images/banner1.jpg"></td>
	</tr>
	<tr background="images/button6.jpg" height="30">
		<td>
		<p style="text-align:right; color:white">
		    Acasa &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp Cauta &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			Masini &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp Adauga &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			Contact &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
		</p>
		</td>
	</tr>
	<tr>
		<td bgcolor = "#070B0B">
		<jsp:useBean id = "stringBean" class = "SQLBean.image" scope = "session" />
<%!
	Statement statement = null;
    Connection conn = null;
    ResultSet rs = null;
    ResultSetMetaData rsmd = null ;
    String sql = "";
    int numColumns ;
    Blob image = null;
%>
<%
	try
	{
		String connectionURL = "jdbc:mysql://localhost:3306/autovehicule";
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        conn = DriverManager.getConnection(connectionURL, "root", "");

       /** if(!conn.isClosed())
        	out.println("Successfully connected to " + "MySQL server using TCP/IP...");*/
    }catch(Exception ex)
    {
    	out.println("Unable to connect to database.");
    }

    statement = conn.createStatement();
    //SELECT * FROM db_autovehicule
    sql = "SELECT * FROM db_autovehicule";
    rs = statement.executeQuery(sql);
%>
<table border = "1" align = center width = 100% style="color:#B3B3B3" >
<tr>
	<td></td>
	<td align = center>ID</td>
	<td align = center>MODEL</td>
	<td align = center>MARCA</td>
	<td align = center>NR. INMATRICULARE</td>
	<td align = center>AN</td>
	<td align = center>PRET</td>
</tr>
<%
	while(rs.next())
	{
%>
	<tr>
		<td width = 138 height = 107>&nbsp<img src="./poza.jsp?imgID= <%= rs.getInt(2) %>" WIDTH=130 HEIGHT=97/></td>
		<td align = center><%= rs.getInt(2) %></td>
		<td align = center><%= rs.getString(3) %><br /></td>
		<td align = center><%= rs.getString(4) %><br /></td>
		<td align = center><%= rs.getString(5) %><br /></td>
		<td align = center><%= rs.getString(6) %><br /></td>
		<td align = center><%= rs.getString(7) %><br /></td>
	</tr>
<% } %>
<%
rs.close();
statement.close();
conn.close();
%>
</table>
		</td>
	</tr>
<table>
<p align = "center" ><code>Copyright 2009-2010 All Rights Reserved.</code></p>
</body>
</html>