jdbc2 - プログラム倉庫

package jndi;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
 
 
public class checktable {
 
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
int s;
 
public String[] type=new String[500];
public String[] credit=new String[500];
int count;
public int creditnumber;        
 
public void makedata(String tab){
 
        try {
 
 
            Class.forName("com.mysql.jdbc.Driver").newInstance();
 
            con = DriverManager.getConnection("jdbc:mysql://10.1.72.31:50133/ren8", "gwjdwYJu", "ffXNEuse");
 
            st = con.createStatement();
 
            String sql = "select * from "+tab;
            rs = st.executeQuery(sql);
            ResultSetMetaData metaData = rs.getMetaData();
 
            count = metaData.getColumnCount();
 
 
            for (s = 1; s< count+1; s++) {
                credit[s]=metaData.getColumnName(s);
                type[s]=metaData.getColumnTypeName(s);
            }
 
            creditnumber=count;
 
 
        } catch (Exception e) {
            System.out.println(e);
        }
    }
}