jtcyzlinsert.java

来自「此社区管理系统是我们实习期间做的一个项目」· Java 代码 · 共 56 行

package community.zhgl;

import java.sql.*;



import community.DBConnectionManager;
import community.dbutil;

public class jtcyzlinsert {
	public int select(String hzno){
		String sql="select jtcyno from jtcyb where hzno='"+hzno+"'";
		Statement stmt;
		ResultSet rs;
		int count=0;
		Connection con=DBConnectionManager.getConnection();
		try {
			stmt=con.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next()) count=count+1;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		dbutil.close(con);
		return count;
	}
	public boolean insert(zhglbean bean) {
		Connection con = DBConnectionManager.getConnection();
		String sql = "insert into jtcyb(cyname,cysex,cycompany,cyworkphone,cyworkaddr,cymobile,jtcyno,hzno,jtgx) values(?,?,?,?,?,?,?,?,?)";
		PreparedStatement pstmt = null;
		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1, bean.getCyname());
			pstmt.setString(2, bean.getCysex());
			pstmt.setString(3, bean.getCycompany());
			pstmt.setString(4, bean.getCyworkphone());
			pstmt.setString(5, bean.getCyworkaddr());
			pstmt.setString(6, bean.getCymobile());
			pstmt.setString(7, bean.getJtcyno());
			pstmt.setString(8, bean.getHzno());
			pstmt.setString(9, bean.getJtgx());
			count = pstmt.executeUpdate();
			dbutil.close(pstmt);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			dbutil.close(con);
		}
		if (count < 1)return false;
		return true;
	}

}