The code is as follows:
PackageCom.itnba.maya.mysql;ImportJava.sql.*;ImportJava.text.SimpleDateFormat; Public classTest { Public Static voidMain (string[] args)throwsexception{Class.forName ("Com.mysql.jdbc.Driver"); Connection Conn= Drivermanager.getconnection ("Jdbc:mysql://localhost:3306/mydb?character=gbk", "Root", "" "); Statement State=conn.createstatement (); String SQL= "SELECT * from Info";//EnquiryResultSet rs =state.executequery (SQL); while(Rs.next ()) {System.out.println (rs.getstring (1) + "\ T" +rs.getstring (2) + "\ T" + (Rs.getboolean (3)? " Male ":" female ") +" \ T "+minzu (rs.getstring (4)) +" \ T "+riqi (Rs.getdate (5)) +" \ n "); } conn.close (); } Public StaticString Riqi (Date data) {SimpleDateFormat sim=NewSimpleDateFormat ("yyyy mm month DD Day"); returnSim.format (data); } Public StaticString Minzu (String mz)throwsexception{Class.forName ("Com.mysql.jdbc.Driver"); Connection Conn= Drivermanager.getconnection ("Jdbc:mysql://localhost:3306/mydb", "Root", "" "); Statement State=conn.createstatement (); String SQL= "Select Info.code,nation. Name from Nation join info on nation. Code= ' "+mz+" ' "; ResultSet RS=state.executequery (SQL); while(Rs.next ()) {MZ= Rs.getstring (2); } conn.close (); returnmz; } }
JAVA-JDBC reading data from a database and date conversion of ethnic men and women