java、MYSQL作业上传系统

package Dao; import java.sql.*; import database.DB; import actionForm.PingFen; import actionForm.Student; import actionForm.Tea_Message; import actionForm.Teacher; public class TeacherManager { private static final String insertTeacher="insert into teacher values(null,?,?)"; private static final String insertTeacherPing="insert into score values(null,?,?,?,?)"; private static final String insertStudent="insert into student values(?,?,?,?)"; private static final String uploadfileTeacher="insert into teacherfile values(null,?,?,now())"; private static final String uploadfileStudent="insert into studentfile values(null,?,?,now())"; private static final String addmessage="insert into tea_stu_message values(null,?,?,?,now())"; private static final String addmessage2="insert into allmessage values(null,?,?,now())"; private static TeacherManager instance=new TeacherManager(); private TeacherManager(){} public static TeacherManager getinstance(){ return instance; } public boolean teacherReg(Teacher t){ boolean temp=false; Connection conn=DB.getConnection(); try{ PreparedStatement pst=conn.prepareStatement(insertTeacher); pst.setString(1,t.getName()); pst.setString(2, t.getPassword()); pst.executeUpdate(); pst.close(); temp=true; }catch(SQLException e){ e.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public boolean studentReg(Student t){ boolean temp=false; Connection conn=DB.getConnection(); try{ PreparedStatement pst=conn.prepareStatement(insertStudent); pst.setInt(1, t.getId()); pst.setString(2,t.getName()); pst.setString(3, t.getPassword()); pst.setInt(4, t.getTeacherid()); pst.executeUpdate(); pst.close(); temp=true; }catch(SQLException e){ e.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public boolean teacherUploadFile(String path,String teacher_id){ boolean temp=false; int tid=Integer.parseInt(teacher_id); Connection conn=DB.getConnection(); try{ PreparedStatement pst=conn.prepareStatement(uploadfileTeacher); pst.setString(1,path); pst.setInt(2,tid); pst.executeUpdate(); pst.close(); temp=true; }catch(SQLException e){ e.printStackTrace(); }catch(NumberFormatException ee){ ee.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public boolean studentUploadFile(String path,String student_id){ boolean temp=false; int tid=Integer.parseInt(student_id); Connection conn=DB.getConnection(); try{ PreparedStatement pst=conn.prepareStatement(uploadfileStudent); pst.setString(1,path); pst.setInt(2,tid); pst.executeUpdate(); pst.close(); temp=true; }catch(SQLException e){ e.printStackTrace(); }catch(NumberFormatException ee){ ee.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public int teacherFindId(String rose,String name,String password){ int temp=-1; String sql = "select * from " + rose + " where "+rose+"_name='"+name+"' and "+rose+"_password='"+password+"'"; Connection conn = DB.getConnection(); Statement pst = null; System.out.println(sql); try { pst = conn.createStatement(); ResultSet rs = pst.executeQuery(sql); if(rs.next()){ //System.out.println(rs.getString("name")); temp=rs.getInt("teacher_id"); } rs.close(); pst.close(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); }finally{ try { if(conn!=null){ conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public int studentFindId(String rose,String name,String password){ int temp=-1; String sql = "select * from " + rose + " where "+rose+"_name='"+name+"' and "+rose+"_password='"+password+"'"; Connection conn = DB.getConnection(); Statement pst = null; System.out.println(sql); try { pst = conn.createStatement(); ResultSet rs = pst.executeQuery(sql); if(rs.next()){ //System.out.println(rs.getString("name")); temp=rs.getInt("student_id"); } rs.close(); pst.close(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); }finally{ try { if(conn!=null){ conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public boolean teacherAddMessage(Tea_Message t){ boolean temp=false; Connection conn=DB.getConnection(); try{ PreparedStatement pst=conn.prepareStatement(addmessage); pst.setString(1,t.getTitle()); pst.setString(2, t.getCont()); pst.setInt(3, t.getTeacherid()); pst.executeUpdate(); pst.close(); temp=true; }catch(SQLException e){ e.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public boolean teacherAddMessage2(Tea_Message t){ boolean temp=false; Connection conn=DB.getConnection(); try{ PreparedStatement pst=conn.prepareStatement(addmessage2); pst.setString(1,t.getTitle()); pst.setString(2, t.getCont()); pst.executeUpdate(); pst.close(); temp=true; }catch(SQLException e){ e.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } public boolean teacherPing(PingFen t){ boolean temp=false; Connection conn=DB.getConnection(); try{ PreparedStatement pst=conn.prepareStatement(insertTeacherPing); pst.setInt(1,t.getStudentid()); pst.setInt(2,t.getTeacherid()); pst.setString(3, t.getKemu()); pst.setDouble(4, t.getFenshu()); pst.executeUpdate(); pst.close(); temp=true; }catch(SQLException e){ e.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return temp; } }