帮忙看看为什么不能在数据库中执行查询

[iamliuqiutong]

这是我的login.jsp代码
急急 大家帮帮忙


<?xml version="1.0" encoding="gb2312"?>
<InstantMessenger>
<% int r_value = -1 ; %>
<% try {// java.sql.Connection db = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/instantmessage","root","" );
java.sql.Connection db=com.msit.common.util.db.DbOperator.getConnection();
System.out.println("?????");
%>

<% java.sql.Statement st1 = db.createStatement(); %>
<% java.sql.Statement st2 = db.createStatement(); %>
<% java.sql.Statement st3 = db.createStatement(); %>

<% java.net.InetAddress addr ; %>

<% java.sql.ResultSet rs1 ; %>
<% java.sql.ResultSet rs2 ; %>

<% System.out.println("1");String l_name = new String(request.getParameter("LoginName").getBytes("ISO8859-1"),"GBK");%>
<% System.out.println("2");String l_password = request.getParameter("Password"); %>
<% String l_ip = request.getRemoteAddr(); %>

<% int ip = 0 ; %>
<% long l_count = 0 ; %>
<% long p_count = 0 ; %>
<%String sql1="select member_id from members where login_name ='" + l_name + "'";
System.out.println(sql1);%>

//程序只运行到这 就不在执行了

<% rs1 = st1.executeQuery(sql1); %>
<% if (rs1.next()) { %>
<% l_count = rs1.getLong("member_id"); %>
<% }
System.out.println(l_count);%>
<% if (l_count <= 0) { %>
<% r_value = 1 ; %>
<% } else if (l_count > 0) { %>
<%
String str="select member_id from members where login_name ='" + l_name + "' and password ='" + l_password + "'";
System.out.println("str2="+str);
rs2 = st2.executeQuery(str);
System.out.println(rs2); %>

<% if (rs2.next()) { %>
<% p_count = rs2.getLong("member_id"); %>
<% }
System.out.println(p_count);%>

<% if (p_count <= 0) { %>
<% r_value = 2; %>
<% } else if (p_count > 0) { %>
<% ip = st3.executeUpdate(" UPDATE members SET ip_add ='" + l_ip + "'" + " WHERE login_name ='" + l_name + "'"); %>

<% if (ip == 1 ) { r_value = 0 ; %>
<% } else { r_value = -1; %>
<% } %>
<% } %>
<% } %>
<auth>
<int> <%= r_value %> </int>
</auth>
<% } catch (java.sql.SQLException ex) { %>

<int> <%= r_value %> </int>

<% } %>

</InstantMessenger>

[Sunny319]

报什么错误啊

[Sunny319]

java.sql.Connection db=com.msit.common.util.db.DbOperator.getConnection();能取到数据库连接吗?

[sky12636642]

看到你写这样的代码,都不想说了,为什么要这样啊,放在一起,自己去单步调试吧,出错了,把结果贴出来就好,贴一大段,想看死人啊!~

[iamliuqiutong]

没有报错 急急 求救

[iamliuqiutong]

能连接到数据库 就是不能到数据库中进行身份验证

程序走到<%String sql1="select member_id from members where login_name ='" + l_name + "'";
System.out.println(sql1);%>
就不走了


也没有错误报告

[古月一刀2005]

fu l you !

[aimer311]

有必要这样吗？
<% int ip = 0 ; %>
<% long l_count = 0 ; %>
<% long p_count = 0 ; %>
<%String sql1="select member_id from members where login_name ='" + l_name + "'";
System.out.println(sql1);%>

把它放在同一个<%%>里边，其他再自己检查检查