- 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();
///insert.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”);
}
}
}
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);
String sql=“insert into contato (nome) values (?)”;
java.sql.PreparedStatement pStmt = conn.prepareStatement(sql);
pStmt.setString(1,“evandro”);
////////introw = pStmt.executeQuery();
pStmt.executeUpdate();
///pStmt.commit();} return conn; } catch (ClassNotFoundException e) { throw new SQLException(e.getMessage()); }}
}
Nao consigo inclui na minha tabela, alguem me ajuda??
Evandro