java商城遇到的问题_做一个商城的登录功能，遇到一个问题。

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

DAO类：

package com.st.dao.impl;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.st.bean.UserInfo;

import com.st.dao.UserInfoDao;

import com.st.util.DBUtil;

public class UserInfoDaoImpl implements UserInfoDao{

@Override

public UserInfo findyByName(UserInfo userInfo) {

//定义一个数据库链接对象属性

Connection con=DBUtil.getCon();

//定义SQL语句

String sql="select * from st_userinfo where u_name=? and u_pwd=?";

UserInfo us=null;

try {

PreparedStatement ps=con.prepareStatement(sql);

ps.setString(1, userInfo.getuName());

ps.setString(2, userInfo.getuPwd());

ResultSet rs=ps.executeQuery();

if(rs.next()){

us=new UserInfo();

us.setuId(rs.getString("u_id"));

us.setuName(rs.getString("u_name"));

us.setuPwd(rs.getString("u_pwd"));

us.setuTel(rs.getInt("u_tel"));

us.setuEmail(rs.getString("u_email"));

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return us;

}

@Override

public UserInfo addUser(UserInfo userInfo) {

Connection con=DBUtil.getCon();

String sql="insert into st_userinfo(u_id,u_name,u_pwd,u_tel,u_email) values(st_userinfo_sq.nextval,?,?,?,?)";

try {

PreparedStatement ps=con.prepareStatement(sql);

ps.setString(2, userInfo.getuName());

ps.setString(3, userInfo.getuPwd());

ps.setInt(4, userInfo.getuTel());

ps.setString(5, userInfo.getuEmail());

int rs=ps.executeUpdate();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return userInfo;

}

}