tmobiledao.java

新东方软件开发项目

package com.mobile.dao;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.mobile.bean.TMobiles;




public class TMobileDAO {
	

		
		public TMobileDAO()
		{
		}

		public int insertTMobile(String cardType, long startNum1, long endNum1)
		{
			int ret = 0;
			Connection con=null;
			try {
				con=ConnectionMgr.getConnection();
				PreparedStatement pstmt =con.prepareStatement("insert into TMobile values(?,?,?,?)");
				for(long i=startNum1;i< endNum1;i++){
				pstmt.setString(1,i+"");
				pstmt.setString(2,cardType );
				pstmt.setString(3,i+"00" );
				pstmt.setString(4, "Y");
				ret = pstmt.executeUpdate();
			} 
			}catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			

		  
			
			return ret;
		
		}
		public int inputNumFromFile(String mypath)
		{
			PreparedStatement pstmt;
			PreparedStatement pstmt1;
			Connection con;
			ResultSet rs;
			int ret = 0;
			try {
				con = ConnectionMgr.getConnection();
			
				pstmt = con.prepareStatement("insert into TMobile values(?,?,?,?)");
				pstmt1 =con.prepareStatement("select MAX(card_number) from TMobile");
			
				
				
					rs = pstmt1.executeQuery();
					rs.next();
					long startCardNum = rs.getLong(1) + 1L;
					
					
				
					String mobile_number = null;
					List list = new ArrayList();
					String filePath =mypath;
					
						FileInputStream fis = new FileInputStream(filePath);
						BufferedReader br = new BufferedReader(new InputStreamReader(fis));
						while ((mobile_number = br.readLine()) != null) 
							list.add(mobile_number);
						for (int i = 0; i < list.size(); i++){
							System.out.println((String)list.get(i));
						}
					
					
					for (int i = 1; i < list.size(); i++)
					{
						startCardNum++;
						pstmt.setString(1, (String)list.get(i));
						pstmt.setString(2, (String)list.get(0));
						pstmt.setString(3, startCardNum+"");
						pstmt.setString(4, "Y");
						ret = pstmt.executeUpdate();
					}
				

				
				
			} catch (Exception e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			
			System.out.println(ret);
			return ret;
		}	
		
}