package com.project.qd.service;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.project.qd.bean.Student;
import com.project.qd.dao.DBUtil;
import com.project.qd.dao.StudentDao;
public class StudentDaoImpl implements StudentDao {
public void register(Student student) {
// TODO Auto-generated method stub
String sql = "insert into tb_student(id,name,password,address) values (?,?,?,?)";
Connection conn = DBUtil.getConn();
PreparedStatement ps = DBUtil.preparedSt(conn, sql);
try {
ps.setInt(1, student.getId());
ps.setString(2, student.getName());
ps.setString(3, student.getPsd());
ps.setString(4, student.getAddress());
System.out.println(sql);
ps.execute();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DBUtil.psClose(ps);
DBUtil.connClose(conn);
}
public void login(Student student) {
// TODO Auto-generated method stub
}
//得到所有的student
public List<Student> getAllStudents() {
// TODO Auto-generated method stub
String sql="select * from tb_student";
Connection conn = DBUtil.getConn();
PreparedStatement ps = DBUtil.preparedSt(conn, sql);
List<Student> list = new ArrayList<Student>();
ResultSet rs = null;
try {
rs = ps.executeQuery();
while(rs.next()){
Student s = new Student();
s.setName(rs.getString("name"));
s.setPsd(rs.getString("password"));
s.setAddress(rs.getString("address"));
list.add(s);
}
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DBUtil.psClose(ps);
DBUtil.connClose(conn);
return list;
}
//检查该账号是否被注册过
public Student check(Student s) {
// TODO Auto-generated method stub
String sql = "select * from tb_student where address = ?";
Connection conn =DBUtil.getConn();
PreparedStatement ps = DBUtil.preparedSt(conn, sql);
ResultSet rs =null;
try {
ps.setString(1, s.getAddress());
rs =ps.executeQuery();
if(!rs.next()){
return null;
}
s.setId(rs.getInt("id"));
s.setName(rs.getString("name"));
s.setPsd(rs.getString("password"));
s.setAddress(rs.getString("address"));
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DBUtil.psClose(ps);
DBUtil.connClose(conn);
return s;
}
}