Tenho três classes:
main.java
- Main.java
- Created on 28 de Outubro de 2006, 14:16
- To change this template, choose Tools | Template Manager
- and open the template in the editor.
*/
package conexaobanco;
import java.sql.Connection;
import java.sql.SQLException;
/**
*
-
@author Evandro
*/
public class Main {/** Creates a new instance of Main */ public Main() { }
/**
-
@param args the command line arguments */ public static void main(String[] args) { try{ Connection conn = ControladorDeConexoes.abreConexao(); insert pegadados = new insert();
if(conn == null){ System.out.println("não conseguiu conectar");
}else{ System.out.println(“Ok”); conn.close(); }
-
} catch (SQLException e) {
///throw new Exception(“Erro.”);
System.out.println(“Deu exceção”);
}
}
}
ControladordeConexao.java
package conexaobanco;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
*
-
@author Evandro
*/
public class ControladorDeConexoes {private static Connection conn; private static final String URL = “jdbc:mysql://localhost:3306/universidade”; private static final String DRIVER = “com.mysql.jdbc.Driver”; private static final String USUARIO = “root”; private static final String PASSWORD = “”;
public static Connection abreConexao() throws SQLException { try { if (conn == null) { Class.forName(DRIVER); conn = DriverManager.getConnection(URL, USUARIO, PASSWORD); } return conn; } catch (ClassNotFoundException e) { throw new SQLException(e.getMessage()); } }
}
insert.java
/*
- insert.java
- Created on 28 de Outubro de 2006, 15:43
- To change this template, choose Tools | Template Manager
- and open the template in the editor.
*/
package conexaobanco;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.*;
/**
*
-
@author Evandro
*/
public class insert {/** Creates a new instance of insert */
public insert() {Connection con =
ControladorDeConexoes.abreConexao();Statement stmt =
con.createStatement();
ResultSet rs =stmt.executeQuery(“SELECT a, b, c FROM contatos”);
// while (rs.next()) {
// int x = getInt(“a”);
// String s = getString(“b”);
// float f = getFloat(“c”);
// }
System.out.println("inserir dados");
}
}
Esta dando a seguinte mensagem de erro:
nit:
deps-jar:
Compiling 1 source file to C:\Documents and Settings\Evandro\conexaobanco\build\classes
C:\Documents and Settings\Evandro\conexaobanco\src\conexaobanco\insert.java:25: unreported exception java.sql.SQLException; must be caught or declared to be thrown
Connection con = ControladorDeConexoes.abreConexao();
C:\Documents and Settings\Evandro\conexaobanco\src\conexaobanco\insert.java:27: unreported exception java.sql.SQLException; must be caught or declared to be thrown
Statement stmt = con.createStatement();
C:\Documents and Settings\Evandro\conexaobanco\src\conexaobanco\insert.java:28: unreported exception java.sql.SQLException; must be caught or declared to be thrown
ResultSet rs = stmt.executeQuery(“SELECT a, b, c FROM contatos”);
3 errors
BUILD FAILED (total time: 5 seconds)
O que significa isso??
Obs. estou utilizan do o netbeans 5.0
no aguardo
Evandro
