axis2 学习笔记 第二天

pojo 代码 服务端代码

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

import com.jl.pojo.User;
import com.jl.util.DBUtil;

public class TZBianLiChaXunService {
	public User getUserChaXun(int id){
		User user = new User();
		Connection conn = null;
		PreparedStatement ps = null;
		String sql = "select * from BIANLICHAXUN where id = ?";
		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setInt(1, id);
			System.out.println(id);
			ResultSet rs = ps.executeQuery();
			while(rs.next()){
				user.setTJCS(rs.getInt("TJCS"));
				user.setXM(rs.getString("XM"));
				user.setXB(rs.getString("XB"));
				user.setNL(rs.getInt("NL"));
				user.setDWMC(rs.getString("DWMC"));
				user.setTJRQ(rs.getString("TJRQ"));
				user.setZS(rs.getString("ZS"));
				user.setJY(rs.getString("JY"));
				user.setJCRQ(rs.getString("JCRQ"));
				user.setJCYS(rs.getString("JCYS"));
				user.setDJLSH(rs.getString("DJLSH"));
				user.setPHONE(rs.getString("PHONE"));
				user.setSYKH(rs.getString("SYKH"));
				user.setPWD(rs.getString("PWD"));
				user.setID(rs.getInt("ID"));
				user.setFLAG(rs.getInt("FLAG"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBUtil.close(ps,conn);
		}
		return user;
	}
	
}

user 类

package com.jl.entity;

public class User {
	private int TJCS; //体检次数
	private String XM;//姓名
	private String XB;//性别
	private int NL;//年龄
	private String DWMC;//DW名称
	private String TJRQ;//体检日期
	private String ZS;//综述
	private String JY;//检验
	private String JCRQ;//检查日期
	private String JCYS;//检查医生
	private String DJLSH;//DJLSH
	private String PHONE;//手机号码
	private String SYKH;//实验
	private String PWD;//密码
	private int ID;//卡号
	private int FLAG;//是否已经发送 0未发送 1已发送
	public int getTJCS() {
		return TJCS;
	}
	public void setTJCS(int tJCS) {
		TJCS = tJCS;
	}
	public String getXM() {
		return XM;
	}
	public void setXM(String xM) {
		XM = xM;
	}
	public String getXB() {
		return XB;
	}
	public void setXB(String xB) {
		XB = xB;
	}
	public int getNL() {
		return NL;
	}
	public void setNL(int nL) {
		NL = nL;
	}
	public String getDWMC() {
		return DWMC;
	}
	public void setDWMC(String dWMC) {
		DWMC = dWMC;
	}
	public String getTJRQ() {
		return TJRQ;
	}
	public void setTJRQ(String tJRQ) {
		TJRQ = tJRQ;
	}
	public String getZS() {
		return ZS;
	}
	public void setZS(String zS) {
		ZS = zS;
	}
	public String getJY() {
		return JY;
	}
	public void setJY(String jY) {
		JY = jY;
	}
	public String getJCRQ() {
		return JCRQ;
	}
	public void setJCRQ(String jCRQ) {
		JCRQ = jCRQ;
	}
	public String getJCYS() {
		return JCYS;
	}
	public void setJCYS(String jCYS) {
		JCYS = jCYS;
	}
	public String getDJLSH() {
		return DJLSH;
	}
	public void setDJLSH(String dJLSH) {
		DJLSH = dJLSH;
	}
	public String getPHONE() {
		return PHONE;
	}
	public void setPHONE(String pHONE) {
		PHONE = pHONE;
	}
	public String getSYKH() {
		return SYKH;
	}
	public void setSYKH(String sYKH) {
		SYKH = sYKH;
	}
	public String getPWD() {
		return PWD;
	}
	public void setPWD(String pWD) {
		PWD = pWD;
	}
	public int getID() {
		return ID;
	}
	public void setID(int iD) {
		ID = iD;
	}
	public int getFLAG() {
		return FLAG;
	}
	public void setFLAG(int fLAG) {
		FLAG = fLAG;
	}
	
	public User(){
		
	}
	public User(int iD, int fLAG) {
		super();
		ID = iD;
		FLAG = fLAG;
	}
	public User(int tJCS, String xM, String xB, int nL, String dWMC,
			String tJRQ, String zS, String jY, String jCRQ, String jCYS,
			String dJLSH, String pHONE, String sYKH, String pWD, int iD,
			int fLAG) {
		super();
		TJCS = tJCS;
		XM = xM;
		XB = xB;
		NL = nL;
		DWMC = dWMC;
		TJRQ = tJRQ;
		ZS = zS;
		JY = jY;
		JCRQ = jCRQ;
		JCYS = jCYS;
		DJLSH = dJLSH;
		PHONE = pHONE;
		SYKH = sYKH;
		PWD = pWD;
		ID = iD;
		FLAG = fLAG;
	}
	
	
}

util 代码

package com.jl.util;

import java.io.IOException;
import java.io.InputStreamReader;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.log4j.Logger;
import org.logicalcobwebs.proxool.ProxoolException;
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;

public class DBUtil {
	private static Logger log = Logger.getLogger(DBUtil.class);
	
	static{
		try {
			JAXPConfigurator.configure(new InputStreamReader(Thread.currentThread().getContextClassLoader().getResourceAsStream("com/jl/util/proxool.xml"))  , false);
			Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
		} catch (ProxoolException e) {
			e.printStackTrace();
			log.error("ProxoolException:"+e.getMessage());
			System.exit(-1);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			System.out.println("连接池配置文件找不到");
			log.error("连接池配置文件找不到");
			System.exit(-1);
		} 
	}
	public static Connection getConnection() throws SQLException{
		return DriverManager.getConnection("proxool.DBPool");
	}
	
	public static void close(ResultSet rs,PreparedStatement ps,Connection conn){
		try {
			if (rs!=null) rs.close();
		} catch (SQLException e) {
		}
		try {
			if (ps!=null) ps.close();
		} catch (SQLException e) {
		}
		try {
			if (conn!=null) conn.close();
		} catch (Exception e) {
		}
	}
	public static void close(PreparedStatement ps,Connection conn){
		try {
			if (ps!=null) ps.close();
		} catch (SQLException e) {
		}
		try {
			if (conn!=null) conn.close();
		} catch (Exception e) {
		}
	}
	
}

生成的class 文件放置目录 和jar包 需要注意

TZBianLiChaXunService 要放到tomcat 中的Tomcat 6.0\webapps\axis2\WEB-INF\pojo文件夹  注意TZBianLiChaXunService没有包

User类和DButil的class文件要放到 Tomcat 6.0\webapps\axis2\WEB-INF\classes文件夹中

如果像我这个代码 DBUtil它的 包是package com.jl.util;

那么它的放置路径是Tomcat 6.0\webapps\axis2\WEB-INF\classes\com\jl\util\DBUtil.class 这样

而proxool.xml文件 在项目中 和 DBUtil同目录的话，

JAXPConfigurator.configure(new InputStreamReader(Thread.currentThread().getContextClassLoader().getResourceAsStream("com/jielan/util/proxool.xml"))  , false);

Thread.currentThread().getContextClassLoader()的目录是在Tomcat 6.0\webapps\axis2\WEB-INF\classes\，所以找到proxool.xml要加上com/jielan/util/proxool.xml包名。

还有要注意的是 需要的包 放到 Tomcat 6.0\webapps\axis2\WEB-INF\lib中，比如 这个代码 中的proxool连接池用到的包需要放到里面，否则会找不到jar包。