注册 登录
编程论坛 J2EE论坛

谁来帮忙看看这个javabean我那里写错了

cx521007 发布于 2007-11-26 02:03, 1086 次点击
请帮忙看一看那里写错了

package com.bean;
import java.sql.*;
public class loginjdbc{
 private Connection conn=null;
 private Statement st=null;
 private ResultSet rt=null;
 private newuser user;
 boolean cc;
 public loginjdbc(){
  final String forname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  final String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=luntan";
  final String user="sa";
  final String pwd="sa";
  try{
   Class.forName(forname);
   conn=DriverManager.getConnection(url,user,pwd);
  }catch(Exception e){
   e.printStackTrace();
  }
 }
 public void setUser(newuser c){
  user=c;
 }
 public boolean getUser(){
  try{
   st=conn.createStatement();
   String username=user.getUsername();
   String password=user.getPassworda();
   String sql="select * from newuser where Name='"+username+"' and Pwd '"+password+"'";   
   rt=st.executeQuery(sql);
   if(rt.next()){
    cc=true;
   }
  }catch(Exception e){
   e.printStackTrace();
  }
  return cc;
 }
}


页面部分
<%@ page c language="java" import="java.sql.*"%>
<jsp:useBean id="user" scope="request" class="com.bean.newuser">
<jsp:setProperty name="user" property="*"/>
</jsp:useBean>
<jsp:useBean id="login" scope="request" class="com.bean.loginjdbc"/>
<%
String username=request.getParameter("username");
String passworda=request.getParameter("passworda");
if(!username.equals("") && username!=null && !passworda.equals("") && passworda!=null){
    login.setUser(user);
 if(login.getUser()==true){
 out.print("111");
 }else{
 out.print("222");
 }}
%>
3 回复
#2
cx5210072007-11-26 02:14
这样总是给我回复false
不知道为什么~请高手指教拉
#3
无缘今生2007-11-26 10:52
if(!username.equals("") && username!=null && !passworda.equals("") && passworda!=null)上面的if应该是这样的吧:
if((!username.equals("") || username!=null) &&( !passworda.equals("") || passworda!=null))

在下面两句的后面加上“.trim()”并加个类型转换试试:
String username=(String)request.getParameter("username").trim();
String passworda=(String)request.getParameter("passworda").trim();
#4
cx5210072007-11-27 01:30
谢谢~
1