package com.model.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.model.bean.UserInfo;
public class AddUserDaoImp implements AddUserDao {
private Connection conn;
public AddUserDaoImp(Connection conn) {
this.conn = conn;
}
@Override
public boolean validateUsername(UserInfo user) throws SQLException {
String sql="select * from userinfo1 where username=?";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, user.getUsername());
ResultSet rs=ps.executeQuery();
boolean flag;
if(rs.next()){
flag=true;
}else{
flag=false;
}
ps.close();
return flag;
}
@Override
public void saveUser(UserInfo user) throws SQLException {
String sql="insert into userinfo1(username,password,newpassword,name,email,phone,role,skin) values(?,?,?,?,?,?,?,?)";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, user.getUsername());
ps.setString(2, user.getPassword());
ps.setString(3, user.getNewpassword());
ps.setString(4, user.getName());
ps.setString(5, user.getEmail());
ps.setString(6, user.getPhone());
ps.setString(7, user.getRole());
ps.setString(8, user.getSkin());
ps.executeUpdate();
ps.close();
}
}
