Web
Gatorz.com is a premium source for High quality Low
cost HTML website template customization service.
We have an extensive collection of web templates
(8000+).
Thank
you very much for the work that
you have done on our website. We
are very pleased that we now have
a very professional looking website
at a very reasonable cost. I also
liked the way you worked as you
were very responsive and friendly
in all your dealings with us.
Mike
Higgins
Partner
Fusion
Corporate Finance
Independent
Corporate Finance Advice For Acquisitions,
Company Sales, Management Buyouts,
Management Buyins and Fundraising.
Specialism In Venture Capital and
Private Equity and Business Valuation
Many
thanks to 2Brothershosting / Webgatorz
for a job well done! By sheer luck we
were recomended by a friend, & on
that note put our trust in them. we were
amaized by the quality, & value for
money. I only gave Chris@2Brothershostings
a few surgestions of what our requirements
were, and he did so much more which has
made our website what it is today. Do
bare in mind we are a new company on a
budget, just imagine what they could do
for you, & your buisness! Take a few
minutes of your time to look threw our
website, & judge it for yourself.
We
were quoted by one company £11,000 for the website we wanted, I know it's
a big website, but I just about fell over.
But then WebGatorz gave me a quote of
just £1,040.
I don't have to tell you, who we went
with.
Many
thanks again for your cooperation and input,
keep up the good work. I feel you will do
well at this web site stuff. Because your
prices and quality are far better than anybody
else.
Where
should I put my JSP pages?
JSP pages can be put under public_html folder or under any
sub directory in public_html folder.
Where
should I put my JavaBeans and Classes?
Your JavaBeans and Classes should be packaged and put under public_html -> WEB-INF -> classes ->
YourPackageName. If you don't package your Java codes, it
may not work.
Before
you connect to your database, you need to create a database
from your control panel's MySQL. On this server, your database
name looks like YourUserName_DBName. So, if your control
panel username is "itsme" and you give the DB
name "MyDB" from control panel, it will be referred
to as "itsme_MyDB". When you refer to your database
from JSP or Servlet, you should refer your database as "itsme_MyDB"
instead of "MyDB".
Driver
and connection strings should be like follows:
String
driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/<Your DB Name
Here>";
You
should also specify your user name and password. The default
username and password are the ones you use for your control
panel.
You
can use the following JSP code to test your DB connection.
You just need to replace the database name, username and
password with your own. Put this page under public_html.
Again, before you test it, you have to make sure you have
the driver .jar file in the above mentioned lib folder.
<%!
// mysql driver
String driver = "com.mysql.jdbc.Driver";
// the
"url" to our DB, the last part is the name of
the DB
String url = "jdbc:mysql://localhost/YourDBName";
// the
default DB username and password may be the same as your
control panel login
String
name = "username";
String pass = "password";
%>
<html>
<head>
<title>testServlet</title>
</head>
<body>
<p>Attempting to open JDBC connection to:... </p>
<%=url%>
<%
try
{
// Test the DB connection by making an empty table
String tableStr = "CREATE TABLE test (testid mediumint(8),
name varchar(100))";
Class.forName( driver );
// initialize
the Connection, with our DB info ...
Connection con = DriverManager.getConnection( url, name,
pass );
