src/com/tjzhic/dao/impl/ReginfoDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.tjzhic.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

import com.tjzhic.dao.ReginfoDao;
import com.tjzhic.db.ConnectionFactory;
import com.tjzhic.entity.Major;
import com.tjzhic.entity.Reginfo;

public class ReginfoDaoImpl implements ReginfoDao {

	/*
	 * private Connection con; private PreparedStatement pre; private String
	 * sql;
	 * 
	 * public ReginfoDaoImpl(){ con = ConnectionFactory.getConnection(); pre =
	 * null; sql = null; }
	 */

	public int add(Reginfo reginfo) {
		// TODO Auto-generated method stub
		int rows = 0;
		Connection con = ConnectionFactory.getConnection();
		PreparedStatement pre = null;
		try {
			String sql = "insert into reginfo(sname,idcode,ssex,nation,political,homeaddr,source,school,gradutetime,isnew,aos,major,cet,mname,mobile,telphone,zipcode,conaddr,receiver,isconfirm,username) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
			pre = con.prepareStatement(sql);
			pre.setString(21, reginfo.getUsername());
			pre.setString(1, reginfo.getSname());
			pre.setString(2, reginfo.getIdcode());
			pre.setString(3, reginfo.getSsex());
			pre.setString(4, reginfo.getNation());
			pre.setString(5, reginfo.getPolitical());
			pre.setString(6, reginfo.getHomeaddr());
			pre.setString(7, reginfo.getSource());
			pre.setString(8, reginfo.getSchool());
			pre.setString(9, reginfo.getGradutetime());
			pre.setString(10, reginfo.getIsnew());
			pre.setString(11, reginfo.getAos());
			pre.setString(12, reginfo.getMajor());
			pre.setString(13, reginfo.getCet());
			pre.setString(14, reginfo.getMname());
			pre.setString(15, reginfo.getMobile());
			pre.setString(16, reginfo.getTelphone());
			pre.setString(17, reginfo.getZipcode());
			pre.setString(18, reginfo.getConaddr());
			pre.setString(19, reginfo.getReceiver());
			pre.setInt(20, 0);
			rows = pre.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if (pre != null)
					pre.close();