Certo! Obrigado ManoJava e mmaico!
Assim quero começar com a fabrica de conexão e o dao, quero fazer inicialmente uma coisa muito simples, apenas com 2 campos e pronto, vou postar como tá agora e gostaria desse uma olhada pra ver se eu não me passei rs rs rs
fabrica de conexões:
[code]import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
String driverClassName = “oracle.jdbc.OracleDriver”;
String connectionUrl = “jdbc:oracle:thin:@192.168.1.133:1521:XE”;
String dbUser = “mari”;
String dbPwd = “mari777”;
private static ConnectionFactory connectionFactory = null;
ConnectionFactory() {
try {
Class.forName(driverClassName);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public Connection getConnection() throws SQLException {
Connection conn = null;
conn = DriverManager.getConnection(connectionUrl, dbUser, dbPwd);
return conn;
}
public static ConnectionFactory getInstance() {
if (connectionFactory == null) {
connectionFactory = new ConnectionFactory();
System.out.println("Conectado");
}
return connectionFactory;
}
}
[/code]
Usuario
[code]package model;
public class Usuario {
int id;
String nome;
public Usuario() {
}
public Usuario(int id, String nome) {
this.id = id;
this.nome = nome;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getNome() {
return nome;
}
public void setNome(String nome) {
this.nome = nome;
}
}[/code]
UsuarioDAO
[code]package dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import model.Usuario;
import banco.ConnectionFactory;
public class UsuarioDAO {
Connection connection = null;
PreparedStatement ptmt = null;
ResultSet resultSet = null;
public UsuarioDAO() {
}
private Connection getConnection() throws SQLException {
Connection conn;
conn = ConnectionFactory.getInstance().getConnection();
return conn;
}
public void add(Usuario usuario) {
try {
String queryString = "INSERT INTO USUARIO(ID, NOME) VALUES(?,?)";
connection = getConnection();
ptmt = connection.prepareStatement(queryString);
ptmt.setInt(1, usuario.getId());
ptmt.setString(2, usuario.getNome());
ptmt.executeUpdate();
System.out.println("Adicionado com sucesso");
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (ptmt != null)
ptmt.close();
if (connection != null)
connection.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}[/code]