shujukubeifen.java

JSP开发的学生信息管理系统

package operator;
import conn.DataBaseConnection;
import java.sql.*;
import java.util.*;
import java.io.*;
public class ShujukuBeifen
{
	private Connection con=null;
	public ShujukuBeifen()
	{
		this.con=DataBaseConnection.getConnection();
	}
//是否存在名字
public boolean existName(String name) {
        try {
            PreparedStatement pstmt = con.prepareStatement(
                    "select backupId from shujukubeifen where backupName='" +name + "'");   
            ResultSet rst = pstmt.executeQuery();
            if (rst.next()) {
                return true;
            }
        } catch (Exception ex) {
            return false;
        }
        return false;
    }
 
 //数据库备份入录
 public String addBackup(String name,String backupTime)
	{
		
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("insert into shujukubeifen(backupName,backupTime) values(?,?)");
			pstmt.setString(1,name);
			pstmt.setString(2,backupTime);
			pstmt.execute();
			str="sucess";
		}catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{	
  	    		 if(pstmt!=null){
  	    		 	pstmt.close();
  	    		 }
  	    		 if(con!=null){
  	    		 	con.close();
  	    		 }
  	    		 
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	
  	    	}
  	    return str;	
	}

//删除数据库备份
public String deleteBackup(String backupId)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("delete from shujukubeifen where backupId=?"); 
			pstmt.setString(1,backupId);
			pstmt.execute();
			str="sucess";
		}
		catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{	
  	    		 if(pstmt!=null){
  	    		 	pstmt.close();
  	    		 }
  	    		 if(con!=null){
  	    		 	con.close();
  	    		 }
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	
  	    	}
  	    return str;	
	}
	
	//
	public ResultSet executeQuery(String sql)
  	{
  	     Statement stmt=null;
  	     ResultSet rst=null;
  	     try{
	  	      stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	  	      rst=stmt.executeQuery(sql);
  	    	}catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    	}
  	    	return rst;
  	 }
  	 
  	 //关闭
  	 public void close() 
        {
        	try{
        		con.close();
        	}
        	catch(SQLException e)
        	{
        	   e.printStackTrace();	
        	}
        	
        } 
 }