testpda.java

来自「文件的上传和下载的实现,用JAva编写,非常简单」· Java 代码 · 共 45 行

/** 
* Copyright 2007 Wuhan University of Technology. 
* All right reserved. 
* Create on 2007-3-28
*/ 

package edu.whut.cwts.maintain.util;

import java.sql.ResultSet;
import java.sql.SQLException;

import edu.whut.cwts.datasource.DBConnect;

/**
 * @author dwr
 *
 */
public class TestPDA {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		String yhdm1="120000003";
		String zddm=yhdm1.substring(0,6);
		String sqlselect2="select cast(max(yhdm)as int)+1 from yhxxb where yhdm like '"+zddm+"%'";
		 DBConnect dbconn2=new DBConnect();
		 String id="";
		 try{
				ResultSet rs2=dbconn2.executeQuery(sqlselect2);
			rs2.next();
			id=rs2.getString(1);
			}
		 catch (SQLException e) {
			    e.printStackTrace();
					}
		 dbconn2.close();
		 String PDAID=zddm+"P"+id.substring(7);
		 System.out.println(PDAID);

	}

}