oraclemobilesdao.java

ｊｓｐ／ｓｅｒｖｌｅｔ中国移动模拟收费系统

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javabean.TMobiles;

public class OracleMobilesDAO implements MobilesDAO {
	
	private final String GET_AN_TOMIBLE = "select * from tmobiles where mobile_number=?";
	private final String UPDATE_AN_TOMIBLE ="update tmobiles set is_available='N' where mobile_number=?";
	//select is_available from tmobiles where mobile_number='13455556666';
	//update tmobiles set is_available='N' where mobile_number='13666668888';
	
	//鍒ゆ柇is_available鐨勫