Hi,
I have this Code for Accessing Database. And Its Working Fine But the Problem is That I Want to Get Control When the Results Coming.
This is The Code\\
Ajax Code
Quote:
function init(){
var val = dojo.byId("userV").value
if (val.length > 5) {
var url = "CheckUsername.jsp"
url = url + "?user=" + val
httpObject = getHTTPObject();
if (httpObject != null) {
httpObject.open("GET", url, true);
httpObject.send(null);
httpObject.onreadystatechange = display;
}
}
}
function display() {
if(httpObject.readyState == 4){
dojo.byId('content').innerHTML = httpObject.responseText;
}
}
function getHTTPObject(){
if (window.ActiveXObject) return new ActiveXObject("Microsoft.XMLHTTP");
else if (window.XMLHttpRequest) return new XMLHttpRequest();
else {
alert("Browser Dosent Support`s");
return null;
}
}
var httpObject = null;
|
and This is The CheckUsername.jsp Code
Quote:
String user = request.getParameter("user").toString();
String data ="";
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "MyDBname";
String driver = "com.mysql.jdbc.Driver";
String userName = "My Username";
String password = "My Password";
int sumcount=0;
Statement st;
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,pa ssword);
String query = "select username from login_info where username='"+user+"'";
st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
if(rs.next())
{
%>
<table bgcolor="#ffffff" border="0">
<tr>
<td valign="middle" bgcolor="#ffffff">
<IMG src="Images/load-r.gif">
</td>
<td valign="top" bgcolor="#ffffff">
<font color="red" face="tahoma" size="1"> Not Allowed</font>
</td>
</tr>
</table>
<%
}
else
{
%>
<table bgcolor="#ffffff" border="0">
<tr>
<td valign="middle" bgcolor="#ffffff">
<IMG src="Images/load-g.gif">
</td>
<td valign="top" bgcolor="#ffffff">
<font color="green" face="tahoma" size="1">Its Allowed </font>
</td>
</tr>
</table>
<%
}
out.println(data);
}
catch (Exception e) {
e.printStackTrace();
}
|
I want To Chek Wether The Result Come from IF part Or Else Part.
Could Any One Help Me ???
Thanks In Advanced