java读取数据库字段和值（国外英文资料）.doc

java读取数据库字段和值（国外英文资料） Java reads database fields and values, output to regedit, XML, text, excel, PDF The main function is to extract fields and values from the database by reading the configuration file, to regedit, XML, text, excel, PDF. The program is a DOS interface, and because of the haste without the Windows interface, if youre interested, you can change it to Windows. Because of the configuration file, all operations do not need to rewrite the code, just rewriting it in the configuration file. The main program: Import the Java. IO. *; Import java.util.prefs. Import the Java. SQL. *; The import JXL. *; The import JXL. Write. *; Import the Java. Util. *; Import the Java. Util. Properties; A. lowage.text. A. lowage.text. Import the Java. The awt. Color; / * * the author: kenshin Effect: from database reading values, output regedit or text or XML or excel or PDF. * the create time: 2004/6/8 * the modify time: 2004/6/9 * copyright: 2004 * / Public class PrefsDemo { The static Preferences prefsdemo; Static String [] field = new String [1000]; The static String [] values = new String [1000]; Static int account = 0, maxCount = 0; Static String path = null, driver = null, user = null, password = null, odbcname = null; Static String txtname = null, xmlname = null, excelname = null, pdfname = null, SQL = null; Static String author = null, createtime = null, effect = null, version = null; Public static void main (String args []) String rnumber = null; Int number = 0; BufferedReader buf. / / initialize the config file Initconfig (); / / the connection to the database DBconnection (); / / goto enterLoop EnterLoop: While (number = 6) { Try { / / choice output formatting ( please choice input!! ) (1: input regedit 2: input XML 3: input text) Println ( 4: excel 5: all 7: exit ); A. out.print ( input a number, not a character ); / / keyword input The new InputStreamReader (System. In)); Rnumber = buf. ReadLine (); / / change number type Number = Integer. ParseInt (rnumber);