一个bean的源文件,前面还看得懂,后面完全看不懂啊……求高手帮忙注释一下吧
package database.operation;
import java.sql.*;
import java.util.*;
public class RandomQueryBean
{ String databaseName="";
String tableName="";
int count;
int randomNumber;
StringBuffer randomQueryResult;
Connection con;
Statement sql;
ResultSet rs;
public RandomQueryBean()
{ randomQueryResult=new StringBuffer();
try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(Exception e){ }
}
public void setDatabaseName(String s)
{ databaseName=s.trim();
randomQueryResult=new StringBuffer();
}
public String getDatabaseName()
{ return databaseName;
}
public void setTableName(String s)
{ tableName=s.trim();
randomQueryResult=new StringBuffer();
}
public String getTableName()
{ return tableName;
}
public void setRandomNumber(int n)
{ randomNumber=n;
randomQueryResult=new StringBuffer();
}
public int getRandomNumber()
{ return randomNumber;
}
public int getCount()
{ try{ String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName="+databaseName;
con=DriverManager.getConnection(uri,"sa","sa");
sql= con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM "+tableName);
rs.last();
count=rs.getRow();
con.close();
}
catch(SQLException exp)
{ count=-1;
}
return count;
}
public StringBuffer getRandomQueryResult()
{ randomQueryResult=new StringBuffer();
try { randomQueryResult.append("<table border=1>");
String uri= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName="+databaseName;
con=DriverManager.getConnection(uri,"sa","sa");
DatabaseMetaData metadata=con.getMetaData();
ResultSet rs1=metadata.getColumns(null,null,tableName,null);
int 字段个数=0;
randomQueryResult.append("<tr>");
while(rs1.next())
{ 字段个数++;
String clumnName=rs1.getString(4);
randomQueryResult.append("<td>"+clumnName+"</td>");
}
randomQueryResult.append("</tr>");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM "+tableName);
rs.last();
count=rs.getRow();
Vector<Integer> vector=new Vector<Integer>();
for(int i=1;i<=count;i++)
{ vector.add(new Integer(i));
}
int 抽取数目=Math.min(randomNumber,count);
while(抽取数目>0)
{ int i=(int)(Math.random()*vector.size());
int index=(vector.elementAt(i)).intValue();
rs.absolute(index);
randomQueryResult.append("<tr>");
for(int k=1;k<=字段个数;k++)
{ randomQueryResult.append("<td>"+rs.getString(k)+"</td>");
}
randomQueryResult.append("</tr>");
抽取数目--;
vector.removeElementAt(i);
}
randomQueryResult.append("</table>");
con.close();
}
catch(SQLException e){ }
randomNumber=0;
return randomQueryResult;
}
}
package database.operation;
import java.sql.*;
import java.util.*;
public class RandomQueryBean
{ String databaseName="";
String tableName="";
int count;
int randomNumber;
StringBuffer randomQueryResult;
Connection con;
Statement sql;
ResultSet rs;
public RandomQueryBean()
{ randomQueryResult=new StringBuffer();
try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(Exception e){ }
}
public void setDatabaseName(String s)
{ databaseName=s.trim();
randomQueryResult=new StringBuffer();
}
public String getDatabaseName()
{ return databaseName;
}
public void setTableName(String s)
{ tableName=s.trim();
randomQueryResult=new StringBuffer();
}
public String getTableName()
{ return tableName;
}
public void setRandomNumber(int n)
{ randomNumber=n;
randomQueryResult=new StringBuffer();
}
public int getRandomNumber()
{ return randomNumber;
}
public int getCount()
{ try{ String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName="+databaseName;
con=DriverManager.getConnection(uri,"sa","sa");
sql= con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM "+tableName);
rs.last();
count=rs.getRow();
con.close();
}
catch(SQLException exp)
{ count=-1;
}
return count;
}
public StringBuffer getRandomQueryResult()
{ randomQueryResult=new StringBuffer();
try { randomQueryResult.append("<table border=1>");
String uri= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName="+databaseName;
con=DriverManager.getConnection(uri,"sa","sa");
DatabaseMetaData metadata=con.getMetaData();
ResultSet rs1=metadata.getColumns(null,null,tableName,null);
int 字段个数=0;
randomQueryResult.append("<tr>");
while(rs1.next())
{ 字段个数++;
String clumnName=rs1.getString(4);
randomQueryResult.append("<td>"+clumnName+"</td>");
}
randomQueryResult.append("</tr>");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM "+tableName);
rs.last();
count=rs.getRow();
Vector<Integer> vector=new Vector<Integer>();
for(int i=1;i<=count;i++)
{ vector.add(new Integer(i));
}
int 抽取数目=Math.min(randomNumber,count);
while(抽取数目>0)
{ int i=(int)(Math.random()*vector.size());
int index=(vector.elementAt(i)).intValue();
rs.absolute(index);
randomQueryResult.append("<tr>");
for(int k=1;k<=字段个数;k++)
{ randomQueryResult.append("<td>"+rs.getString(k)+"</td>");
}
randomQueryResult.append("</tr>");
抽取数目--;
vector.removeElementAt(i);
}
randomQueryResult.append("</table>");
con.close();
}
catch(SQLException e){ }
randomNumber=0;
return randomQueryResult;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货