validservice.java

用java 语言开发的webservice源代码 包含webservice的发布和怎样在程序中 调用webservice

package org.accp.service;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.sql.*;
public class validservice implements validinter{

	private Connection conn;
	private PreparedStatement pstmt;
	private ResultSet rs;
	private String str;
	
	public String getvalid(String userid){
		double balance=0;
		try{
		Context ic=new InitialContext();
		DataSource source=(DataSource)ic.lookup("java:comp/env/jdbc/bank");
		conn=source.getConnection();
		pstmt=conn.prepareStatement("select * from userinfo where userID=?");
		pstmt.setString(1, userid);
		rs=pstmt.executeQuery();
		if(rs.next()){
			balance=rs.getDouble("balance");
			System.out.println(balance);
		}
		if(balance<0){
			str= "请您尽快还款！";
		}else if(balance>0 && balance<100000){
			str= "欢迎光临！";
		}else if(balance>100000){
			str= "欢迎光临，您是我们的贵宾！为您服务是我们的荣幸！";
		}else if(balance==0){
			str= "非法用户！";
		}
		}catch(Exception ex){
			ex.printStackTrace();
			System.out.println("数据库连接有错！");
		}
		
		return str;
	}
	
	public static void main(String[] args) {
		validservice service=new validservice();
		service.getvalid("id001");
	}
}