import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.DriverManager;public class TestMysql { public static void main(String[] args) {
Connection con= null;   
Statement stmt = null;
ResultSet rs = null;
String url ="jdbc:mysql://localhost/query?useUnicode=true&characterEncoding=gb2312";
String user=""; 
String password=""; 
String queryString = "select code,name from cbm where code <='00000199'";
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();   
con= DriverManager.getConnection(url,user,password);   
stmt = con.createStatement();
rs = stmt.executeQuery(queryString);
while(rs.next()){
System.out.println("code:"+rs.getString("code")+" name:"+rs.getString("name"));
}
}catch(SQLException e){
System.out.println(" "+e);
}catch(Exception e){
System.out.println(" "+e);
}finally{
try{
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (con != null) con.close();
}catch(SQLException e){
System.out.println(" error in finally"+e);
}
}
}
}