jdbc3 - プログラム倉庫

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
public class pro extends HttpServlet {
  public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws IOException, ServletException{
 
    response.setContentType("text/html; charset=UTF-8");
    PrintWriter out = response.getWriter();
 
String message;  
int s,count,creditnumber;
String[] credit=new String[500];
int[] z=new int[100];
 
String url;   
String usr;   
String pwd ; 
String host,port;   
 
host="10.1.72.52";
port="50140";
 
 url="jdbc:mysql://10.1.72.28:50132/";
 usr="qLKCpwDe";
 pwd="iMAztgQZ";
 
 
 
 table sub7=new table();
 sub7.host=host;
 sub7.port=port;
 sub7.pwd=pwd;
 sub7.usr=usr;
 sub7.makedata("renjdbc","z","(x INTEGER)");
 
 
 checktable sub=new checktable();
 sub.pwd=pwd;
 sub.usr=usr;
 sub.port=port;
 sub.host=host;
 sub.makedata("renjdbc","z");
 creditnumber=sub.creditnumber;
 
 for(s=1;s<100;s++){
 insert sub3=new insert();
 sub3.pwd=pwd;
 sub3.usr=usr;
 sub3.port=port;
 sub3.host=host;
 sub3.makedata("renjdbc","z","(1300)");
 }
 
 out.println(creditnumber);
 
 select sub4=new select();
 sub4.host=host;
 sub4.pwd=pwd;
 sub4.usr=usr;
 sub4.port=port;
 sub4.makedata("renjdbc","z");
 count=sub4.count;
 z=sub4.z;
 
 out.println(count);
 
 
 for(s=1;s<count+1;s++){
 out.println(z[s]);
 out.println("<br>");
 }
 
 
 
 
  }
}