package com.jnshu.dbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public   class DatebaseStudentMethodImpl implements DatebaseStudentMethod {
 public long insert(Student c) {
  String sql = "insert into Student(Name,Qq,Type,School,Wish,Introducer)values(?,?,?,?,?,?)";
  Connection conn =DatebaseConnection.open(null);
  try {
   PreparedStatement pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, c.getName());
   pstmt.setLong(2, c.getQq());
   pstmt.setString(3, c.getType());
   pstmt.setString(4, c.getSchool());
   pstmt.setString(5, c.getWish());
   pstmt.setString(6, c.getIntroducer());
   pstmt.executeUpdate();
  } catch (SQLException e) {
   e.printStackTrace();
  }finally {
   DatebaseConnection.close();
  }
  return c.getId();
 }
 public void Update(Student c) {
  String sql = "update student set Name=?,Qq=? ，Type=?,School=?,Wish=？，Introducer=?where id = ?";
  Connection conn = DatebaseConnection.open(null);
  try {
   PreparedStatement pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, c.getName());
   pstmt.setLong(2, c.getQq());
   pstmt.setLong(3,  c.getId());
   pstmt.setString(4, c.getType());
   pstmt.setString(5, c.getType());
   pstmt.setString(6, c.getType());
   pstmt.setLong(7, c.getId());
   pstmt.executeUpdate();
  } catch (SQLException e) {
   e.printStackTrace();
  }finally {
   DatebaseConnection.close();
  }
 }
 public Student GetStudentByid(long id) {
  // TODO Auto-generated method stub
  return null;
 }
 public void Delete(long id) {
  // TODO Auto-generated method stub  
 }

 public long Insert(Student c) {
  // TODO Auto-generated method stub
  return c.getId()+1;
 }
}