// the Java applet
import java.applet.Applet;
import java.sql.*;
public class Query extends Applet
{ public Connection conn = null;
public void start()
{ try
{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://servername:1433;DatabaseName=dbname","username","password");
}
catch (Exception e)
{ e.getMessage(); // -> ?
}
}
public String[][] qSelect(String qry)
{ ResultSet rs;
try
{ Statement stmt = conn.createStatement();
rs = stmt.executeQuery(qry);
stmt.close();
// transform rs in String[][] for JS
int rows = 0;
while(rs.next()) rows++;
rs.first();
ResultSetMetaData metaData = rs.getMetaData();
int cols = metaData.getColumnCount();
String[][] rslt = new String[rows][cols];
int i=0;
while(rs.next())
{ for (int j=0;j<cols;j++)
rslt[i][j] = rs.getString(j+1);
i++;
}
return rslt;
}
catch (SQLException se)
{ String[][] rslt = new String[1][1];
rslt[0][0] = "Exception";
return rslt;
}
}
public int qOther(String qry)
{ try
{ Statement stmt = conn.createStatement();
stmt.executeUpdate(qry);
stmt.close();
return 1;
}
catch (SQLException se)
{ return 0;
}
}
public void stop()
{ try
{ conn.close();
}
catch (SQLException e)
{ e.printStackTrace(); // -> ?
}
}
}
