acvalid.java

来自「用java 语言开发的webservice源代码 包含webservice的发」· Java 代码 · 共 40 行

package org.accp.Service;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.sql.*;
import org.accp.Entity.*;

public class ACvalid implements ValidInterface{

	private Connection conn;
	private PreparedStatement pstmt;
	private ResultSet rs;
	public CustomerBean getvalid(String userid){
		CustomerBean customer=null;
		try{
		Context ic=new InitialContext();
		DataSource source=(DataSource)ic.lookup("java:comp/env/jdbc/bank");
		conn=source.getConnection();
		}catch(Exception ex){
			ex.printStackTrace();
			System.out.println("连接数据库出错！");
		}
		try{
			pstmt=conn.prepareStatement("select * from userinfo where userID=?");
			pstmt.setString(1, userid);
			rs=pstmt.executeQuery();
			if(rs.next()){
				customer=new CustomerBean();
				customer.setBalance(rs.getDouble("balance"));
				customer.setUserID(rs.getString("userID"));
				customer.setUsername(rs.getString("userName"));
			}
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("读取数据时出错！");
		}
		return customer;
	}
}