package client;
import java.util.*;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBClient {
DataSource dataSource;
public DBClient(DataSource dataSource) {
this.dataSource = dataSource;
}
public CountInfo checkmoney (String tno) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
CountInfo it=new CountInfo();
strSql = "select * from countinfo where tno='"
+ tno+ "'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(strSql);
if ( rs.next()) {
it.setTNO(rs.getString("TNO"));
it.setMONEY(Integer.parseInt(rs.getString("money")));
it.setFREECALL(Integer.parseInt(rs.getString("freecall")));
it.setFREEMES(Integer.parseInt(rs.getString("freemes")));
it.setFREEGPRS(Integer.parseInt(rs.getString("freegprs")));
it.setAVAILABLETIME(rs.getString("availabletime"));
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return it;
}
public Vector Viewcall(String tno) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
Vector it=new Vector();
strSql = "select * from cal where tno1='"
+ tno+ "'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(strSql);
while ( rs.next()) {
Call c=new Call();
c.setTno1(rs.getString("tno1"));
c.setTno2(rs.getString("tno2"));
c.setActi(rs.getString("acti"));
c.setRoam(rs.getString("roam"));
c.setCalltime(rs.getTimestamp("calltime"));
c.setTime(rs.getTime("tim"));
it.add(c);
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return it;
}
public Vector Viewmessage(String tno) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
Vector it=new Vector();
strSql = "select * from message where tno1='"
+ tno+ "'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(strSql);
while ( rs.next()) {
Message c=new Message();
c.setTno1(rs.getString("tno1"));
c.setTno2(rs.getString("tno2"));
c.setTime(rs.getTimestamp("senttime"));
c.setLength(rs.getInt("messlen"));
it.add(c);
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return it;
}
public Vector Viewgprs(String tno) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
Vector it=new Vector();
strSql = "select * from gprs where tno='"
+ tno+ "'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(strSql);
while ( rs.next()) {
Gprs c=new Gprs();
c.setTno(rs.getString("tno"));
c.setTime(rs.getTimestamp("time1"));
c.setBytes(rs.getInt("bytes"));
it.add(c);
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return it;
}
public int ChargeCheck(String chargeno,String password) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
int it=0;
strSql = "select * from chargeingcard where cardnum='"
+ chargeno+ "' and cardcode='"+password+"'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(strSql);
if( rs.next()) {
it=rs.getInt("money");
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return it;
}
public void DeleteChargeCard(String chargeno,String password) throws Exception{
Connection connect = null;
String strSql;
strSql = "delete from chargeingcard where cardnum='"
+ chargeno+ "' and cardcode='"+password+"'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
stmt.executeUpdate(strSql);
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return;
}
public void Charge(String tno,int money) throws Exception{
Connection connect = null;
String strSql;
strSql = "update countinfo set money=money+"+money+" where tno='"+tno+"'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
stmt.executeUpdate(strSql);
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return;
}
public int Viewvalue(String tno) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
int it=-1;
strSql = "select * from tvalue where tno='"
+ tno+ "'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(strSql);
if( rs.next()) {
it=rs.getInt("value");
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return it;
}
public void Subvalue(String tno,int money) throws Exception{
Connection connect = null;
String strSql;
strSql = "update tvalue set value=value-"+money+" where tno='"+tno+"'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
stmt.executeUpdate(strSql);
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return;
}
public Client Identify(String tno,String code) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
Client c=null;
strSql ="select * from clien where tno='"+tno+"' and tcode='"+code+"'";
//update set tno='cec',tname='wx' where tno='cce'
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs=stmt.executeQuery(strSql);
if(rs.next()){
c=new Client(rs.getString("tno"));
c.setTname(rs.getString("tname"));
c.setRegtime(rs.getTimestamp("regtime"));
c.setTadd(rs.getString("tadd"));
c.setTcode(rs.getString("tcode"));
c.setTemail(rs.getString("temail"));
c.setTidno(rs.getString("tidno"));
c.setTsex(rs.getString("tsex"));
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return c;
}
public Client GetClient(String tno) throws Exception{
Connection connect = null;
String strSql;
ResultSet rs;
Client c=null;
strSql ="select * from clien where tno='"+tno+"'";
try {
connect = dataSource.getConnection();
Statement stmt = connect.createStatement();
rs=stmt.executeQuery(strSql);
if(rs.next()){
c=new Client(rs.getString("tno"));
c.setTname(rs.getString("tname"));
c.setRegtime(rs.getTimestamp("regtime"));
c.setTadd(rs.getString("tadd"));
c.setTcode(rs.getString("tcode"));
c.setTemail(rs.getString("temail"));
c.setTidno(rs.getString("tidno"));
c.setTsex(rs.getString("tsex"));
}
}
catch(SQLException ex) {
ex.printStackTrace();
}
finally{
if(connect!=null)
connect.close();
}
return c;
}
public void update(Client c,int type) throws Exception{
Connection connect = null;
String strSql;
//strSql ="select * from clien where tn
网上营业厅java源码
5星 · 超过95%的资源 需积分: 35 96 浏览量
2013-06-05
17:27:59
上传
评论 5
收藏 949KB RAR 举报 
网上营业厅java源码 （442个子文件） 
DBClient.class 13KB index_jsp.class 11KB DBManage.class 8KB right_005fviewcall_jsp.class 8KB toissueop_jsp.class 7KB toviewhisbill_jsp.class 7KB person_005fhead_jsp.class 7KB code_005fhead_jsp.class 7KB ADVISEHEAD_jsp.class 7KB VALHEAD_jsp.class 7KB EXPHEAD_jsp.class 7KB he_jsp.class 7KB right_005fviewmessage_jsp.class 7KB right_005fviewgprs_jsp.class 7KB right_005fbegin_005fservice_jsp.class 6KB right_005fviewnewop_jsp.class 6KB DBClerk.class 6KB right_005fviewonop_jsp.class 6KB toexchange_jsp.class 6KB right_005fviewadvice_jsp.class 6KB tocharge_jsp.class 6KB info_jsp.class 6KB NEWCLKHEAD_jsp.class 5KB clerk_005fhead_jsp.class 5KB viewclerk_jsp.class 5KB updateclerk_jsp.class 5KB toviewbill_jsp.class 5KB checkavai_jsp.class 5KB NEWCLKLEFT_jsp.class 5KB toviewaccount_jsp.class 5KB clerk_005fleft_jsp.class 5KB right_005fviewhotop_jsp.class 5KB toviewhotop_jsp.class 5KB error_jsp.class 5KB visithead_jsp.class 5KB right_005fviewop_jsp.class 5KB addclerk_jsp.class 5KB right_005fviewacount_jsp.class 5KB NEWCLKRIGHT_jsp.class 5KB codechange_jsp.class 4KB EXPLEFT_jsp.class 4KB VALRIGHT_jsp.class 4KB le_jsp.class 4KB right_005fplace_jsp.class 4KB todeleteop_jsp.class 4KB EXPRIGHT_jsp.class 4KB toviewop_jsp.class 4KB servicepage_jsp.class 4KB toaddop_jsp.class 4KB Client.class 4KB ADVISELEFT_jsp.class 4KB visitleft_jsp.class 4KB VALLEFT_jsp.class 4KB place_jsp.class 4KB addAdvice_jsp.class 4KB ADVISERIGHT_jsp.class 4KB right_005fviewvalue_jsp.class 4KB ri_jsp.class 4KB viewAdvice_005fclerk_jsp.class 4KB viewNoRevert_jsp.class 4KB viewAdvice_jsp.class 4KB passupdateclerk_jsp.class 4KB deleteclerk_jsp.class 4KB Newclient.class 3KB Picture.class 3KB Login.class 3KB Addclerk.class 3KB Updateclerk.class 3KB Passclk.class 3KB Info.class 2KB Vtoexp.class 2KB Charge.class 2KB Addop.class 2KB Codechange.class 2KB AddAdviceAction.class 2KB ViewDetail.class 2KB RevertAdviceAction.class 2KB Sercharge.class 2KB Viewhismessage.class 2KB Viewhiscall.class 2KB Viewhisgprs.class 2KB Service.class 2KB Clerk.class 2KB Deleteop.class 2KB NewclientForm.class 2KB Viewvalue.class 2KB QueryAction.class 2KB ViewNoRevertAction.class 2KB ViewAdviceAction_clerk.class 2KB Issueop.class 2KB Deleteclerk.class 2KB Viewmessage.class 2KB Viewnewop.class 2KB Viewcall.class 2KB Viewgprs.class 2KB ViewAdviceAction.class 2KB Viewonop.class 2KB ViewAcount.class 2KB Viewop.class 2KB Manage.class 2KB共 442 条
- 1
- 2
- 3
- 4
- 5
评论8
最新资源