package cn.cdu.edu.school.dao.impl;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import cn.cdu.edu.school.dao.StudentDao;
import cn.cdu.edu.school.model.Sel;
import cn.cdu.edu.school.model.Student;
import cn.cdu.edu.school.utils.DBUtils;
public class StudentDaoImpl implements StudentDao{
@Override
public Student login(String tel, String password) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
Student student=null;
try {
conn = DBUtils.getConnection();
ps = conn.prepareStatement("select * from student where tel=? and password=?");
ps.setString(1, tel);
ps.setString(2, password);
rs=ps.executeQuery();
if(rs.next()) {
student=new Student();
student.setAddress(rs.getString("address"));
student.setAge(rs.getInt("age"));
student.setId(rs.getInt("id"));
student.setName(rs.getString("name"));
student.setPassword(rs.getString("password"));
student.setSex(rs.getString("sex"));
student.setTel(rs.getString("tel"));
student.setType(rs.getString("type"));
student.setVip(rs.getInt("vip"));
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(rs, ps, conn);
}
return student;
}
@Override
public List<Student> findByPage(int page) {
List<Student> list = new ArrayList<Student>();
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
Student student=null;
String sql = "select * from student limit ?,?";
try {
conn = DBUtils.getConnection();
ps = conn.prepareStatement(sql);
ps.setInt(1, (page - 1) * Student.PAGE_SIZE);
ps.setInt(2, Student.PAGE_SIZE);
rs = ps.executeQuery();
while (rs.next()) {
student=new Student();
student.setAddress(rs.getString("address"));
student.setAge(rs.getInt("age"));
student.setId(rs.getInt("id"));
student.setName(rs.getString("name"));
student.setPassword(rs.getString("password"));
student.setSex(rs.getString("sex"));
student.setTel(rs.getString("tel"));
student.setType(rs.getString("type"));
student.setVip(rs.getInt("vip"));
list.add(student);
}
ps.close();
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
@Override
public int getCount() {
int count = 0;
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
String sql = "select count(*) from student ";
try {
conn=DBUtils.getConnection();
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
if(rs.next()) {
count = rs.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(rs, ps, conn);
}
return count;
}
@Override
public Sel findbyid(int studentid) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
Sel sel=null;
try {
conn = DBUtils.getConnection();
ps = conn.prepareStatement("select * from sel where studentid=?");
ps.setInt(1, studentid);
rs=ps.executeQuery();
if(rs.next()) {
sel=new Sel();
sel.setCoachid(rs.getInt("coachid"));
sel.setStudentid(rs.getInt("studentid"));
sel.setSeldate(rs.getDate("seldate"));
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(rs, ps, conn);
}
return sel;
}
@Override
public boolean selectstudent(int studentid) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
System.out.println("da"+studentid);
Date date=new Date(System.currentTimeMillis());
try {
conn = DBUtils.getConnection();
ps = conn.prepareStatement("update sel set seldate=? where studentid=?");
ps.setDate(1,date);
ps.setInt(2, studentid);
int i=ps.executeUpdate();
if(i!=0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(rs, ps, conn);
}
return false;
}
@Override
public boolean delstudent(int studentid) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
conn = DBUtils.getConnection();
ps = conn.prepareStatement("delete from coach where studentid=?");
ps.setInt(1, studentid);
int i=ps.executeUpdate();
if(i!=0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(rs, ps, conn);
}
return false;
}
public void addStudent(Student student) {
Connection conn= null;
PreparedStatement ps=null;
try {
conn = DBUtils.getConnection();
String sql= "insert into student(name,sex,age,tel,address,password,type,vip) values(?,?,?,?,?,?,?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, student.getName());
ps.setString(2, student.getSex());
ps.setInt(3, student.getAge());
ps.setString(4, student.getTel());
ps.setString(5, student.getAddress());
ps.setString(6, student.getPassword());
ps.setString(7, student.getType());
ps.setInt(8, 0);
int i = ps.executeUpdate();
if (i>0) {
System.out.println("加入成功!");
}else {
throw new RuntimeException("插入失败!");
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(null, ps, conn);
}
}
@Override
public void deleteStudent(int id) {
System.out.println(id);
Connection conn = null;
try {
conn = DBUtils.getConnection();
String sql = "delete from student where id=?";
PreparedStatement pt = conn.prepareStatement(sql);
pt.setInt(1, id);
int i = pt.executeUpdate();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
finally {
DBUtils.closeAll(null, null, conn);
}
}
@Override
public List<Student> findAll() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<Student> list = new ArrayList<Student>();
try {
conn = DBUtils.getConnection();
String sql = "select * from student";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
Student s = new Student();
s.setId(rs.getInt("id"));
s.setName(rs.getString("name"));
s.setSex(rs.getString("sex"));
s.setAge(rs.getInt("age"));
s.setTel(rs.getString("tel"));
s.setAddress(rs.getString("address"));
s.setPassword(rs.getString("password"));
s.setType(rs.getString("type"));
s.setVip(rs.getInt("vip"));
list.add(s);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(rs, ps, conn);
}
return list;
}
@Override
public int updatastudent(Student student) {
int i = 0;
PreparedStatement pt= null;
Connection conn = null;
String sql = "update student set password=? where id=?";
try {
conn = DBUtils.getConnection();
pt = conn.prepareStatement(sql);
pt.setString(1, student.getPassword());
pt.setInt(2,student.getId());
i = pt.executeUpdate();
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
DBUtils.closeAll(null, pt, conn);
return i;
}
public void SelectCoach(int cid, int sid) {
Connection conn= null;
PreparedStatement ps=null;
try {
conn = DBUtils.getConnection();
String sql= "insert into sel(studentid,coachid) values(?,?)";
ps = conn.prepareStatement(sql);
ps.setInt(1, sid);
ps.setInt(2, cid);
int i = ps.executeUpdate();
if (i>0) {
System.out.println("加入成功!");
}else {
throw new RuntimeException("插入失败!");
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.closeAll(null, ps, conn);
}
}
@Override
public void money(int id) {
Connection conn= null;
PreparedStatement ps=null;
try {
c
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于servlet的简单驾校系统.zip (177个子文件)
StudentDaoImpl.class 9KB
PlaceDaoImpl.class 7KB
LoginServlet.class 5KB
CoachDaoImpl.class 5KB
AddStudentServlet.class 3KB
Sendsms.class 3KB
CoachFindServlet.class 3KB
UpdataStudentServlet.class 3KB
MakePracticePlaceServlet.class 3KB
MakeExamPlaceServlet.class 3KB
CheckStudentServlet.class 3KB
CheckImgServlet.class 3KB
PlaceServiceImpl.class 3KB
Student.class 3KB
StudentServiceImpl.class 3KB
AddCoachServlet.class 3KB
Coach.class 3KB
ChangeCoachPasswordServlet.class 3KB
AddEaddressServlet.class 2KB
CoachManagerServlet.class 2KB
StudentFindServlet.class 2KB
AddPaddressServlet.class 2KB
SelectExamPlaceServlet.class 2KB
SelectPracticePlaceServlet.class 2KB
DelExamServlet.class 2KB
SelectStudentServlet.class 2KB
DelPracticeServlet.class 2KB
DelSelectServlet.class 2KB
DelCoachServlet.class 2KB
CoachServiceImpl.class 2KB
AdminDaoImpl.class 2KB
DeleteStudentServlet.class 2KB
SelectCoachServlet.class 2KB
DBUtils.class 2KB
PhoneServlet.class 2KB
Examaddress.class 2KB
MoneyServlet.class 2KB
Sel.class 1KB
Practiceaddress.class 1KB
Eaddress.class 1KB
Paddress.class 1KB
Admin.class 1KB
Code.class 1KB
PlaceService.class 904B
AdminServiceImpl.class 893B
PlaceDao.class 892B
StudentDao.class 827B
StudentService.class 785B
CoachService.class 499B
CoachDao.class 487B
AdminDao.class 236B
AdminService.class 219B
.classpath 2KB
org.eclipse.wst.common.component 483B
org.eclipse.wst.jsdt.ui.superType.container 49B
common.css 3KB
comm.css 2KB
index.css 2KB
reset.css 1KB
indexlink.css 1KB
mysql-connector-java-5.0.8-bin.jar 528KB
jstl-1.2.jar 405KB
standard-1.1.2.jar 384KB
dom4j-1.6.1.jar 307KB
commons-httpclient-3.0-rc4.jar 272KB
commons-beanutils-1.8.3.jar 227KB
commons-io-2.2.jar 170KB
commons-logging-1.1.1.jar 59KB
commons-fileupload-1.2.2.jar 58KB
commons-codec-1.3.jar 46KB
StudentDaoImpl.java 9KB
PlaceDaoImpl.java 7KB
LoginServlet.java 5KB
CoachDaoImpl.java 4KB
Sendsms.java 3KB
UpdataStudentServlet.java 2KB
AddStudentServlet.java 2KB
AddCoachServlet.java 2KB
CoachFindServlet.java 2KB
CheckImgServlet.java 2KB
PlaceServiceImpl.java 2KB
AddEaddressServlet.java 2KB
CheckStudentServlet.java 2KB
MakeExamPlaceServlet.java 2KB
SelectExamPlaceServlet.java 2KB
MakePracticePlaceServlet.java 2KB
SelectPracticePlaceServlet.java 2KB
Student.java 2KB
StudentServiceImpl.java 2KB
AddPaddressServlet.java 2KB
StudentFindServlet.java 2KB
CoachManagerServlet.java 2KB
ChangeCoachPasswordServlet.java 2KB
SelectCoachServlet.java 2KB
Coach.java 2KB
DelExamServlet.java 2KB
DeleteStudentServlet.java 2KB
PhoneServlet.java 1KB
MoneyServlet.java 1KB
DelPracticeServlet.java 1KB
共 177 条
- 1
- 2
资源评论
白话机器学习
- 粉丝: 9790
- 资源: 7681
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功