在sybase中获得建索引的语句（Get indexed in the Sybase statement）.doc

在sybase中获得建索引的语句（Get indexed in the Sybase statement） import java.sql.connection; import java.sql.drivermanager; import java.sql.preparedstatement; import java.sql.resultset; import java.util.arraylist; import java.util.list; public class test { private string name = ; private string indname = ; private string id = ; private string keys = ; private string keys2 = ; private int keycnt = 0; private int status = 0; / * * * 获取数据库连结 * * @ return * @ throws exception * / public static connection getconnection () { connection con = null; try { class.forname (com.sybase.jdbc2.jdbc.sybdriver).newinstance (); string url = sybase数据库连接; string drivers = com.sybase.jdbc2.jdbc.sybdriver; if (drivers! = 0) { system.setproperty (jdbc.drivers, drivers); } string username = 用户名; string password = 密码; con = drivermanager.getconnection (url, username, password); return con. } catch (exception e) { e.printstacktrace (); } return con. } public static void main (string [] args) throws exception { connection conn = getconnection (); try { string query = select o.name name, i.name indname, o.id id, i.keys1 keys1, i.keys2 keys2, i.keycnt keycnt, i.status status from sysindexes i, sysobjects o where keycnt 0 and i.id = o.id and o.type = u; preparedstatement stmt = conn.preparestatement (sql); resultset rs = stmt.executequery (); list list = new arraylist test (test); while (rs.next ()) { test t = new test (); t.setname (rs.getstring (name); t.setindname (rs.getstring (indname)); t.setid (rs.getstring (id)); t.setkeys (rs.getstring (keys1)); t.setkeys2 (rs.getstring (keys2)); t.setkeycnt (rs.getint (keycnt)); t.setstatus (rs.getint (status)); list.add (t). } for (int i = 0; i list.size (); i + +) { test t = list.get (i); / / system.out.println (表 + t.getid () + 表名 + t.getname () + / / 索引名 / / + t. GetIndName () + column number + t.getKeycnt () + column value T.getKeys (+ +) / column value / / t.getKeys2 (+)); String key = t.getKeys (); String key2 = t.getKeys2 (); Int count = t.getKeycnt