دوستان سپاسگذارم از معرفت و لطف شما
این فایلی هست که واسه ارتباط با sql نوشتم، و از کانکشن های زیر استفاده کردم آیا باید تغییری تو نحوه اتصال به بانک بدم؟
بازم سپاسگذارم که بنده حقیر شرمنده کردید و مورد لطف خودتون قرار دادید.
ان شاء الله همیشه موفق و سرافراز باشید
خدا خیرتون بده
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<HEAD>
<TITLE>
MadarPardazan.Co
</TITLE>
</HEAD>
<body>
<h2 align="center">
MadarPardazan.Co
</h2>
<h4 align="right"><a href="index.jsp"> <b> ???? ????</b></a></h4>
<%
String name=request.getParameter("name");
// String action=request.getParameter("Action");
String action=request.getParameter("Action");
%>
<%@ page import="java.sql.*"
import="java.util.Vector"
import="javax.swing.*"
%>
<%
String driver = "org.gjt.mm.mysql.Driver";
String connectionURL ="jdbc:mysql://localhost:3306/madarpardazan";
String Serach_Query="";
ResultSet srs=null;
Connection conn=null;
Statement stmt=null;
int i=0;
try
{
Class.forName(driver).newInstance();
//out.print("<br>"+driver + " loaded. ");
}
catch(java.lang.ClassNotFoundException e)
{
out.print("ClassNotFoundException: ");
out.print(e.getMessage());
out.print("\n >>> Please check your CLASSPATH variable <<<\n");
}
try
{
conn= DriverManager.getConnection(connectionURL, "root","salavat");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITI VE,ResultSet.CONCUR_UPDATABLE);
//out.println("<br>"+connectionURL + " loaded.<br>");
if (action.equals("name"))
// Serach_Query="SELECT * FROM pieces WHERE piece_name LIKE" + "'%" + name + "%'" + "";
Serach_Query="SELECT * FROM pieces WHERE piece_name LIKE" + "'%" + name + "%'" +"Order By piece_name Asc"+ "";
if (action.equals("price"))
//Serach_Query="SELECT * FROM pieces WHERE gh_forush="+ name + "";
Serach_Query="SELECT * FROM pieces WHERE gh_forush LIKE" + "'%" + name + "%'"+"Order By piece_name Asc" + "";
srs = stmt.executeQuery(Serach_Query);
srs.beforeFirst();
%>
<%if (name!=null) {%> <TABLE BORDER="10" DIR="rtl"WIDTH="990" cellspacing="3" cellpadding="7">
<TR><TH>????</TH><TH>??? ????</TH><TH>???? ???? (????)</TH><TH>???? ????</TH></TR>
<% while (srs.next())
{
%>
<TR>
<TD DIR="ltr">
<%=
++i
%>
</TD>
<TD DIR="ltr">
<%=
srs.getString("piece_name")
%>
</TD>
<TD DIR="ltr">
<%=
srs.getString("gh_forush")
%>
</TD>
<TD DIR="ltr">
<a target="_blank" href="<%=srs.getString("url")%>">
<%=srs.getString("url")%>
</a>
</TD>
</TR>
<% } %>
</TABLE>
<%
}
if (srs!=null) srs.close();
stmt.close();
conn.close();
}
catch (SQLException e)
{
out.println(e.getMessage());
out.println("The driver could not connect : " + e.getMessage());
}
%>
</body>
</html>