该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
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;
}
}