mysql创建存储过程并通过java程序调用该存储过程(三)
for (int i = 1; i <= size; i++) {
stmt.setObject(i, args[i - 1]);// 数组下标从0开始
}
if (size < num) {
for (int k = size + 1; k <= num; k++) {
stmt.setObject(k, null);// 数组下标从0开始
}
}
boolean b = stmt.execute();
return b;
}
public static void getMetaDate() throws Exception {// 获取数据库元素数据
conn = DBUtils.getConnORCALE();
DatabaseMetaData dmd = conn.getMetaData();
System.out.println(dmd.getDatabaseMajorVersion());
System.out.println(dmd.getDatabaseProductName());
System.out.println(dmd.getDatabaseProductVersion());
System.out.println(dmd.getDatabaseMinorVersion());
}
public static String[] getColumnNamesFromMySQL(String sql) throws Exception {
conn = DBUtils.getConnMySQL();
return getColumnName(sql);
}
public static String[] getColumnNamesFromOrcale(String sql)
throws Exception {
conn = DBUtils.getConnORCALE();
return getColumnName(sql);
}
private static String[] getColumnName(String sql) throws Exception {// 返回表中所有的列名
conn = DBUtils.getConnORCALE();
st = conn.createStatement();
rs = st.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int num = rsmd.getColumnCount();
System.out.println("ColumnCount=" + num);
String[] strs = new String[num];
// 显示列名
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
String str = rsmd.getColumnName(i);
strs[i - 1] = str;
System.out.print(str + "\t");
}
return strs;
}
public static void getColumnDataFromMySQL(String sql) throws Exception {// 输出表中的数据
conn = DBUtils.getConnMySQL();
getColumnData(sql);
}
public static void getColumnDataFromORCALEL(String sql) throws Exception {// 输出表中的数据
conn = DBUtils.getConnORCALE();
getColumnData(sql);
}
public static void getColumnData(String sql) throws Exception {// 输出表中的数据
st = conn.createStatement();
rs = st.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
System.out
.println("\n------------------------------------------------------------------------------------------------------------------------");
while (rs.next()) {
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
System.out.print(rs.getString(i) + "\t");
}
System.out.println();
}
System.out
.println("------------------------------------------------------------------------------------------------------------------------");
}
public static void getTableDataFromOrcale(String sql) throws Exception {// 输出表的列名
// 和表中的全部数据
conn = DBUtils.getConnORCALE();
getTableData(sql);
}
public static void getTableDataFromMysql(String sql) throws Exception {// 输出表的列名
// 和表中的全部数据
conn = DBUtils.getConnMySQL();
getTableData(sql);
}
private static void getTableData(String sql) throws SQLException {
// getTableDataFromMysql
// getTableDataFromOrcale
st = conn.createStatement();
rs = st.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int num = rsmd.getColumnCount();
System.out.println("ColumnCount=" + num);
String[] strs = new String[num];
// 显示列名
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
String str = rsmd.getColumnName(i);
strs[i - 1] = str;
System.out.print(str + "\t");
}
System.out