ÓÃJavaдµÄMy SQL²Ù×÷·â×°Àà

Kagula
2009-11-17
 
¹Ø¼ü´Ê
    Java My SQL
 
¸ÅÒª£º
    ¶ÔMy SQL²Ù×÷·â×°µÄJavaÔ´ÂëʾÀý¡£
 
ÒªÇó»·¾³£º
    J2SE1.5 + Eclipse3.4.2
 
ÕýÎÄ£º
Ïȵ½ÍøÉÏÏÂÔØmysql-connector-java-5.0.8-bin.jar£¬²¢°ÑËü·Åµ½ÄãµÄJava ProjectµÄUser Library·¾¶ÖС£
ÏÂÃæÊÇCMySQLµÄÔ´ÂëÇåµ¥£¬¾ßÌåÈçºÎʹÓ㬲ο¼CMySQLµÄmain·½·¨¡£
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
public class CMySQL {
private Connection conn;

public CMySQL(String sWhere,String sAccount,String sPWD)
{
connect(sWhere,sAccount,sPWD);
}

public void finalize()
{
shutdown();
}
private void connect(String sWhere,String sAccount,String sPWD)
{
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();

conn = DriverManager.getConnection(sWhere,sAccount,sPWD);
}catch(Exception ex)
{
ex.printStackTrace();
}
}

public boolean executeUpdate(String strSQL)
{
boolean bR=true;

try{
Statement stmt = conn.createStatement();
stmt.executeUpdate(strSQL);
}catch(SQLException ex)
{
ex.printStackTrace();
bR=false;
}

return bR;

}

public List<Map<String,String>> executeQuery(String strSQL)
{
List<Map<String,String>> list=new ArrayList<Map<String,String>>();
ResultSet rs;

try{
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(strSQL);
if(rs.next())
{
ResultSetMetaData rsm = rs.getMetaData();
List<String> colNames = new ArrayList<String>();
for(int i=1;i<=rsm.getColumnCount();i++)
colNames.add(rsm.getColumnName(i));
do{