zjzhinsert.java

此社区管理系统是我们实习期间做的一个项目

package community.zhgl;

import java.sql.*;
import community.DBConnectionManager;
import community.dbutil;

public class zjzhinsert {
	public boolean insert(zhglbean bean) {
		Connection con = DBConnectionManager.getConnection();
		String sql = "insert into yhzlb(hzname,sex,homephone,mobile,company,workphone,workaddr,rztime,hzno) values(?,?,?,?,?,?,?,?,?)";
		PreparedStatement pstmt = null;
		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1, bean.getHzname());
			pstmt.setString(2, bean.getSex());
			pstmt.setString(3, bean.getHomephone());
			pstmt.setString(4, bean.getMobile());
			pstmt.setString(5, bean.getCompany());
			pstmt.setString(6, bean.getWorkphone());
			pstmt.setString(7, bean.getWorkaddr());
			pstmt.setString(8, bean.getRztime());
			pstmt.setString(9, bean.getHzno());

			count = pstmt.executeUpdate();
			
			sql = "insert into zhwz(lyno,dyno,fjno,hzno) values(?,?,?,?)";
			pstmt = null;

			pstmt = con.prepareStatement(sql);
			pstmt.setString(1, bean.getLyno());
			pstmt.setString(2, bean.getDyno());
			pstmt.setString(3, bean.getFjno());
			pstmt.setString(4, bean.getHzno());
			count = pstmt.executeUpdate();
			dbutil.close(pstmt);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			dbutil.close(con);
		}
		if (count < 1)
			return false;
		return true;
	}

}