certreqinfo.java

来自「用纯java语言实现的数字证书制作工具。」· Java 代码 · 共 56 行

package data;

import java.io.*;
import java.sql.*;
import data.Connect;
import data.*;


public class CertReqInfo 
{
	public String UN,N,C,U,O,ID;
	
	public CertReqInfo(String MyID) 
	{
		String query;
		
	try{
		Connect conn=new Connect();
		Statement stmt=conn.con.createStatement();
		query="select * from UserData where IDCard='" + MyID+"'";
		ResultSet rs=stmt.executeQuery(query);
		int result=0;
		while(rs.next())
		{
			result++;
			UN=rs.getString(1);
			N=rs.getString(2);
			C=rs.getString(3);
			U=rs.getString(4);
			O=rs.getString(5);
			ID=rs.getString(6);
			System.out.println(UN+" "+N+" "+C+" "+U+" "+O+" "+ID);
				
		}
		if(result==0)
		{
			System.out.println("您输入的ID错误，请重新输入");
			
		}
		stmt.close();
		conn.con.close();
		return;
				}
			catch(SQLException ie)
			{
				String mm;
	       		mm="数据库执行错误："+ie.getMessage();
	       		System.out.println("SQLException:"+ie.toString());
			}
		
	}
/*	public static void main(String args[]) 
	{
		CertReqInfo CRI=new CertReqInfo("31060516");
	}*/
}