import java.io.PrintStream;
import java.sql.*;public class DBOperation
{ private String strDbDriver;
private String strConn;
private Connection conn;
private ResultSet result;
private String strUser;
private String strPassword; public DBOperation()
{
strDbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
conn = null;
result = null;
try
{
Class.forName(strDbDriver);
}
catch(ClassNotFoundException ex)
{
System.err.println(ex.getMessage());
}
} public DBOperation(String strConn, String strUser, String strPassword)
{
this();
this.strConn = strConn;
this.strUser = strUser;
this.strPassword = strPassword;
} public ResultSet executeQuery(String strSql)
throws SQLException
{
result = null;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
return st.executeQuery(strSql);
} public int executeUpdate(String strSql)
throws SQLException
{
/*int nRetValue = -1;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
nRetValue = st.executeUpdate(strSql);
st.close();
conn.close();
return nRetValue;
}
}
import java.sql.*;public class DBOperation
{ private String strDbDriver;
private String strConn;
private Connection conn;
private ResultSet result;
private String strUser;
private String strPassword; public DBOperation()
{
strDbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
conn = null;
result = null;
try
{
Class.forName(strDbDriver);
}
catch(ClassNotFoundException ex)
{
System.err.println(ex.getMessage());
}
} public DBOperation(String strConn, String strUser, String strPassword)
{
this();
this.strConn = strConn;
this.strUser = strUser;
this.strPassword = strPassword;
} public ResultSet executeQuery(String strSql)
throws SQLException
{
result = null;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
return st.executeQuery(strSql);
} public int executeUpdate(String strSql)
throws SQLException
{
/*int nRetValue = -1;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
nRetValue = st.executeUpdate(strSql);
st.close();
conn.close();
return nRetValue;
}
}
try{result = db.executeQuery(SQLString);
while (result.next()) rowCount++;
content = new Object[rowCount][18];
result = db.executeQuery(SQLString);
for (int i = 0; i < rowCount; i ++){
result.next();
for (int j = 0; j < 18; j ++){
content[i][j] = (Object)result.getString(j + 1);}}
这样,content数组中的值就是你所有查询SQLString中得到的结果
,*********, , ,@@,
.****+++****,*: ,WW.
,***:.,,,.+****+ ,WW.
***., ,:***+ ,WW.
.**: ****+ ,WW.
+*+, ,.+++. :@@*, +@@:,WW.*@*.#@:
**: ,,,,,WWWWWW: ,WWWWWWWW.#WWWWWWW,+++,
,**: @WW@*WW. WWW**WWWW.#WWW#*WW* ::
,**: WWW*,.., #WW:,,.@WW.#WW+.,+WW,. .
+*+, .WWWW+, WW+, .WW.#W@. .WW,+#
.**, ,:WWWWW:,WW: ,WW.#W@, .WW,@@,
,***, ., ,.:#WWW.WW*, .WW.#W#, .WW.#+,
.***, +**, +,,,WWW:+WW. WWW.#W#, .WW. ,
,.*****+*****. WWWWWWW.,WWWWWWWWW.#W#, .WW,**,
,.********+., :WWWWWW+, .@WWWW@WW.#W#, .WW,**
,.+++++:, ,.:++:., ,:++:.++..++, ,++,,,
,,,,, ,,,, ,,, ,,,,,, ,,
用http://bbs.soulsky.net/pub/ascii/做的。