deletecharge.java

来自「宠物医院管理系统 包含宠物的注册 管理 收费 诊断等一系列过程控制 还包含配应」· Java 代码 · 共 31 行

package yd.pethospital.chargecommon;

import java.sql.*;
import yd.pethospital.share.SystemShare;
import yd.pethospital.chargeregister.view.ChargeRegister;

public class DeleteCharge {
	
	public DeleteCharge(){
		
		try {
			SystemShare.getConnection();
			SystemShare.pst=SystemShare.con.prepareStatement("select * from ChargeInfo ",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
			
			SystemShare.rs=SystemShare.pst.executeQuery();                                                            //rs用于返回SQL语句对数据库的查询等操作  
			SystemShare.rs.absolute(ChargeRegister.BTCK.getSelectedRow()+1);                                 //记录被选择的行
			
			SystemShare.con.prepareStatement("delete ChargeInfo where petcode="+SystemShare.rs.getString("petcode")).executeUpdate();   //调用preparement方法进行数据库操作
			ChargeRegister.frame.dispose();
			
			SystemShare.delsuccess();
			new ChargeRegister();
			
		}catch (SQLException e) {
			SystemShare.delfail();
		}
		SystemShare.close();
	}
	
}