package com;
import java.sql.*;
import java.util.*;
public class StudentInterfaceImpl implements StudentInterface {
@Override
public void save(Student stu) {
// TODO Auto-generated method stub
int num=stu.getNum();
String name=stu.getName();
String sex=stu.getSex();
// String sql="insert into student (num,name,sex) values('"+num+"','"+name+"','"+sex+"')";
String sql="insert into student(num,name,sex) values(?,?,?)";
try{
// Statement st=JDBCConn.conn.createStatement();
PreparedStatement ps=JDBCConn.conn.prepareStatement(sql);
ps.setInt(1,num);
ps.setString(2,name);
ps.setString(3,sex);
int rs=ps.executeUpdate();
if(rs>0){
System.out.println("保存成功!");
}
if(ps!=null){
ps.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
@Override
public void del(int num) {
// TODO Auto-generated method stub
// String sql="delete from student where num='"+num+"'";
String sql="delete from student where num=?";
try{
// Statement st=JDBCConn.conn.createStatement();
PreparedStatement ps=JDBCConn.conn.prepareStatement(sql);
ps.setInt(1,num);
int rs=ps.executeUpdate();
if(rs>0){
System.out.println("删除成功!");
}
if(ps!=null){
ps.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
@Override
public void upa(Student stu) {
// TODO Auto-generated method stub
int num=stu.getNum();
String name=stu.getName();
String sex=stu.getName();
// String sql="update student set name='"+name+"',sex='"+sex+"' where num='"+num+"'";
String sql="update student set name=?,sex=? where num=?";
try{
// Statement st=JDBCConn.conn.createStatement();
PreparedStatement ps=(PreparedStatement)JDBCConn.conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, sex);
ps.setInt(3, num);
int rs=ps.executeUpdate();
if(rs>0){
System.out.println("更新成功!");
}
if(ps!=null){
ps.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
@Override
public List<Student> getAll() {
List<Student> list=new ArrayList<>();
String sql="select * from student";
try{
Statement st=JDBCConn.conn.createStatement();
ResultSet rs=st.executeQuery(sql);
while(rs.next()){
Student student=new Student();
int num=Integer.parseInt(rs.getString(2));
String name=rs.getString(3);
String sex=rs.getString(4);
//建立student对象,将获取的记录封装到该对象内;
student.setNum(num);
student.setName(name);
student.setSex(sex);
//将student对象放入数组中;
list.add(student);
}
if(st!=null||rs!=null){
st.close();
rs.close();
}
}catch(Exception e){
e.printStackTrace();
}
return list;
}
@Override
public void sortStudent(List<Student> list) {
// TODO Auto-generated method stub
Student student1;
Student student2;
for(int i=0;i<list.size();i++){
for(int j=0;j<list.size()-1;j++){
student1=list.get(j);
student2=list.get(j+1);
if(student1.getNum()>student2.getNum()){
list.set(j,student2);
list.set(j+1,student1);
}
}
}System.out.println("succssed");
}
}