www.pudn.com > students.rar > Delete_crouse.java

package students; 
import java.sql.*; 
public class Delete_crouse { 
	public static void delete(String stu,String str1,String str2,String str3,String str4,String str5){ 
		if(str1!=null){ 
			fun(stu,str1); 
		} 
		if(str2!=null){ 
			fun(stu,str2); 
		} 
		if(str3!=null){ 
			fun(stu,str3); 
		} 
		if(str4!=null){ 
			fun(stu,str4); 
		} 
		if(str5!=null){ 
			fun(stu,str5); 
		} 
	} 
	public static void fun(String stu,String sql){ 
		Connection con = null; 
		Statement stmt = null; 
		ResultSet rs = null; 
		try { 
			con = Database.connectToDb(); 
			String strSQL = "delete from sel_crouses where ID='"+stu+"' and cro_id='"+sql+"'"; 
			stmt = con.createStatement(); 
			stmt.executeUpdate(strSQL); 
			} catch (SQLException e) { 
				e.printStackTrace(); 
			} catch (Exception e) { 
				e.printStackTrace(); 
			} finally { 
				if (con != null) { 
					try { 
						con.close(); 
					} catch (SQLException e) { 
						e.printStackTrace(); 
					} 
					con = null; 
				} 
			} 
		} 
	}