ai me ajudem estou com um probleminha
seguinte: eu criei uma classe de conecxão com o banco de dados, mysql, funcionava beleza no meu pc, so que quando eu coloquei no servidor nao funciona mais.
apareçe a seguinte mensagem Erro: java.sql.SQLException: General error: No Database Selected, diz que nenhum banco foi selecionado.
o codigo da classe e da pagina sao esses:
Pagina:
<%<a class="mention" href="/u/page">@page</a> import=“fer.*”%>
<% Db ban = new Db(""); %>
<%
if(ban.status)
{
ban.exec(“create database blogger”);
ban.exec(“use blogger”);
ban.exec(“create table if not exists blogger(cod int(10) unsigned auto_increment primary key,nome char(50),fone char(16),endereco char(50))”);
}
%>
<link href=“default.css” rel=“stylesheet” type=“text/css”>
<body bgcolor="#000000">
<%
out.println("<p><font size="-1" color=“blue”><b>"+ban.mens+"</b></font></p>");
%>
e aqui e o codigo da classe Db.java
package fer;
import java.sql.*;
public class Db{
Connection con;
Statement st;
public boolean status;
public String mens;
public String tabela="";
public Db(String url)
{
status=true;
mens="";
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con=DriverManager.getConnection("jdbc:mysql://eatj.com/", "mjfritsch", "Maicon");
st=con.createStatement();
status=true;
mens="";
}
catch(Exception ex)
{
status=false;
mens="Erro: 1 "+ex.toString();
}
}
public boolean exec(String clausula, String tipo)
{
ResultSet rs=null;
String d_t="";
if (clausula.indexOf("select")==-1)
{
while(clausula.indexOf("/")!=-1)
{
if(clausula.substring(clausula.indexOf("/")+3,clausula.indexOf("/")+4).equals("/"))
{
d_t = clausula.substring(clausula.indexOf("/")-2,clausula.indexOf("/")+8);
d_t = d_t.substring(d_t.indexOf("/")+4,d_t.length())+d_t.substring(d_t.indexOf("/")+1,d_t.indexOf("/")+3)+d_t.substring(d_t.indexOf("/")-2,d_t.indexOf("/"));
clausula=clausula.substring(0,clausula.indexOf("/")-2)+d_t+clausula.substring(clausula.indexOf("/")+8,clausula.length());
}
else
{
clausula=clausula.substring(0,clausula.indexOf("/"))+"|"+clausula.substring(clausula.indexOf("/")+1,clausula.length());
}
}
while(clausula.indexOf("|")!=-1)
{
clausula=clausula.substring(0,clausula.indexOf("|"))+"/"+clausula.substring(clausula.indexOf("|")+1,clausula.length());
}
try
{
mens=String.valueOf(st.execute(clausula));
status=true;
}
catch(Exception ex)
{
status=false;
mens="Erro: "+ex.toString();
}
}
else
{
try
{
tabela=clausula;
tabela=tabela.substring(tabela.indexOf("from")+5,tabela.length());
if(tabela.indexOf(" ")!=-1) tabela=tabela.substring(0,tabela.indexOf(" "));
else tabela=tabela.substring(0,tabela.length());
rs=st.executeQuery(clausula);
status=true;
if(rs!=null) mens=formata(rs,tipo);
}
catch(Exception ex)
{
status=false;
mens="Erro: "+ex.toString();
}
}
return status;
}
public boolean exec(String c)
{
boolean b=exec(c,"texto");
return b;
}
public String campo(int r,int c)
{
String str=mens;
if((str.indexOf("<reg>")!=-1) && (str.indexOf("<cam"+c+">")!=-1))
{
str = str.substring(str.indexOf("<reg>")+("<reg>").length(),str.indexOf("</reg>"));
str = str.substring(str.indexOf("<cam"+c+">")+("<cam"+c+">").length(),str.indexOf("</cam"+c+">"));
}
else
{
str="";
}
return str;
}
public String formata(ResultSet r,String tip)
{
int i=0,ir=0;
String ireg="", freg="", icam="", fcam="", resp="",cam="";
String retorno="",codigo="";
ResultSetMetaData meta=null;
try{
meta = r.getMetaData();
}catch(Exception exx){
}
boolean process=true,inicio=true;
if(tip.equals("texto"))
{
ireg="";
freg="
“;
icam=”";
fcam=" “;
}
else if (tip.equals(“campo”))
{
ireg=”<reg>";
freg="</reg>";
icam="<cam";
fcam="/cam";
}
else if (tip.equals(“tabela”))
{
ireg=“tr>”;
freg="</tr>
“;
icam=”<td>";
fcam="</td>";
}
else if (tip.equals(“tabclick”))
{
ireg="<tr><td><a href="#local" onClick=“captura(Z1)”>*</a></td>";
freg="</tr>
“;
icam=”<td><a href="#local" onClick=“formul(C1)”>";
fcam="</a></td>";
}
else if(tip.equals(“escolha”))
{
ireg="<option value="";
freg="";
icam="";
fcam="   ";
}
else if (tip.equals(“reg”))
{
ireg="";
freg="";
icam="";
fcam="";
}
else
{
process=false;
}
if(process)
{
try
{
while (r.next())
{
i=0;
inicio=true;
resp=resp+ireg;
while(true)
{
try
{
i=i+1;
cam=r.getString(i);
if(cam==null) cam="";
if(cam.length()==10)
{
if((cam.substring(4,5).equals("-")))
{
cam=cam.substring(8,10)+"/"+cam.substring(5,7)+"/"+cam.substring(0,4);
}
}
if((tip.equals("tabclick"))&&(inicio==true))
{
inicio=false;
codigo=cam;
retorno="<cod>"+codigo+"</cod>";
}
if((tip.equals("escolha"))&&(inicio==true))
{
inicio=false;
resp=resp+cam+"">";
i++;
}
if(tip.equals("campo"))
{
resp=resp+icam+i+">"+cam+fcam+i+">";
}
else
{
if(tip.equals("reg"))
{
resp = resp + "<" + meta.getColumnLabel(i) + ">" + cam.trim() + "</" + meta.getColumnLabel(i) + ">";
}
else
{
resp=resp+icam+cam+fcam;
}
if(tip.equals("tabclick"))
{
while(resp.indexOf("(C1)")!=-1) resp=resp.substring(0,resp.indexOf("(C1)"))+"("+codigo+")"+resp.substring(resp.indexOf("(C1)")+4,resp.length());
}
}
}
catch(Exception ex)
{
break;
}
}
resp=resp+freg;
if(tip.equals("tabclick"))
{
resp=resp.substring(0,resp.indexOf("(Z1)"))+"('<tab>"+tabela+"</tab>"+retorno+"')"+resp.substring(resp.indexOf("(Z1)")+4,resp.length());
retorno="";
}
if(tip.equals("reg"))
{
resp="<tab>"+tabela+"</tab>"+resp;
}
}
}
catch(Exception ex)
{
status=false;
resp="Erro: "+ex.toString();
}
}
return resp;
}
}
