计算机192-06.rar

package com.ppdxzz.dao; import com.ppdxzz.entity.Tickets; import com.ppdxzz.util.Database; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class TicketsDao { // // //添加学生信息 // public boolean addStudent(Students student) { // String real_name=student.getReal_name(); // String stu_sex=student.getStu_sex(); // String stu_age=student.getStu_age(); // String id=student.getId(); // String native_place=student.getNative_place(); // String dorm_id=student.getDorm_id(); // String real_password=student.getReal_password(); // Database db = new Database(); // Statement stmt=db.getStatement(); // String sql="insert into students values('"+real_name+"','"+stu_sex+"','"+stu_age+"','"+id+"','"+native_place+"','"+dorm_id+"','"+real_password+"')"; // if (real_name.equals("")||stu_sex.equals("")||stu_age.equals("")||id.equals("")||native_place.equals("")||dorm_id.equals("")||real_password.equals("")) { // return false; // }else { // try { // int result = stmt.executeUpdate(sql); // if (result == 1) { // return true; // } else { // return false; // } // } catch (SQLException e) { // e.printStackTrace(); // } finally { // if(stmt != null) { // try { // stmt.close(); // } catch (SQLException e) { // e.printStackTrace(); // } // } // } // } // // return false; // } //通过 班次号 删除车票信息 public boolean deleteByBusnumber(String Busnumber) { Database db = new Database(); Statement stmt=db.getStatement(); String sql="delete from tickets where Busnumber='"+Busnumber+"'"; try { int result=stmt.executeUpdate(sql); if (result == 1) { return true; }else { return false; } } catch (SQLException e) { e.printStackTrace(); } return false; } //通过 账号 删除车票信息 public boolean deleteByAccount(String account) { Database db = new Database(); Statement stmt=db.getStatement(); String sql="delete from tickets where account='"+account+"'"; try { int result=stmt.executeUpdate(sql); if (result == 1) { return true; }else { return false; } } catch (SQLException e) { e.printStackTrace(); } return false; } //通过 班次号 检索车票信息 public Tickets selectByBusnumber(String Busnumber) { Tickets tickets=new Tickets(); Database db=new Database(); Statement stmt=db.getStatement(); String sql="select * from tickets where Busnumber = '"+Busnumber+"'"; try { ResultSet rs=stmt.executeQuery(sql); while (rs.next()) { tickets.setBusnumber(rs.getString(1)); tickets.setDeparture(rs.getString(2)); tickets.setDestination(rs.getString(3)); tickets.setDepatime(rs.getString(4)); tickets.setDepadate(rs.getString(5)); tickets.setFare(rs.getString(6)); tickets.setAccount(rs.getString(7)); tickets.setOrdertime(rs.getString(8)); tickets.setTicketype(rs.getString(9)); tickets.setPassengers(rs.getString(10)); tickets.setSeatnumber(rs.getString(11)); tickets.setTicketnumber(rs.getString(12)); return tickets; } } catch (SQLException e) { e.printStackTrace(); }finally { if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } } return tickets; } //通过 账号 检索车票信息 public Tickets selectByAccount(String account) { Tickets tickets=new Tickets(); Database db=new Database(); Statement stmt=db.getStatement(); String sql="select * from tickets where account = '"+account+"'"; try { ResultSet rs=stmt.executeQuery(sql); while (rs.next()) { tickets.setBusnumber(rs.getString(1)); tickets.setDeparture(rs.getString(2)); tickets.setDestination(rs.getString(3)); tickets.setDepatime(rs.getString(4)); tickets.setDepadate(rs.getString(5)); tickets.setFare(rs.getString(6)); tickets.setAccount(rs.getString(7)); tickets.setOrdertime(rs.getString(8)); tickets.setTicketype(rs.getString(9)); tickets.setPassengers(rs.getString(10)); tickets.setSeatnumber(rs.getString(11)); tickets.setTicketnumber(rs.getString(12)); return tickets; } } catch (SQLException e) { e.printStackTrace(); }finally { if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } } return tickets; } //通过 车票编号 检索车票信息 public Tickets selectByTicketnumber(String Ticketnumber) { Tickets tickets=new Tickets(); Database db=new Database(); Statement stmt=db.getStatement(); String sql="select * from tickets where Ticketnumber = '"+Ticketnumber+"'"; try { ResultSet rs=stmt.executeQuery(sql); while (rs.next()) { tickets.setBusnumber(rs.getString(1)); tickets.setDeparture(rs.getString(2)); tickets.setDestination(rs.getString(3)); tickets.setDepatime(rs.getString(4)); tickets.setDepadate(rs.getString(5)); tickets.setFare(rs.getString(6)); tickets.setAccount(rs.getString(7)); tickets.setOrdertime(rs.getString(8)); tickets.setTicketype(rs.getString(9)); tickets.setPassengers(rs.getString(10)); tickets.setSeatnumber(rs.getString(11)); tickets.setTicketnumber(rs.getString(12)); return tickets; } } catch (SQLException e) { e.printStackTrace(); }finally { if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } } return tickets; } //查询所有车票信息 public List<Tickets> selectAll() { List<Tickets> list = new ArrayList<>(); Database db = new Database(); Statement stmt=db.getStatement(); String sql="select * from tickets"; try {