Codigo java. package nominaempleados;

package nominaempleados;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.JOptionPane;

import java.sql.*;

import java.util.*;

public class AccesoDatosNominabd {

private String bd;

private String user;

private String password;

private String host;

private String server;

public AccesoDatosNominabd (String bd,

String user,

String password,

String host){

this.bd=bd;

this.user =user;

this.password= password;

this.host= host;

this.server= "jdbc:mysql://"+host+"/"+bd;

}

public Connection getConexion(){

Connection cn = null;

try{

//cragar del driver

//Class.forName("sun.jdbc.obdc.JobdcOdbcDriverj");

Class.forName("com.mysql.jbdc.Driver").newInstance();

//creaconecxion

//cn=DriverManager.getConnection("jbdc:obdc"+dsn);

cn=DriverManager.getConnection(server,user,password);

}

catch (SQLException e){

JOptionPane.showMessageDialog(null,"estado"+e.getSQLState());

JOptionPane.showMessageDialog(null,"codigo de error:"+e.getErrorCode());

e.printStackTrace();

}

finally{

return cn;

}

}

public boolean existe (String idEmp){

Connection cn =getConexion();

Statement st = null;

ResultSet rs = null;

boolean estado = false ;

try{

st= cn.createStatement();

String sql ="SELECT IdEmp from empleado where idEmp 0 '"+idEmp+"'";

rs = st.executeQuery(sql);

if (rs.next()){

estado = true ;

}

rs .close();

st.close();

cn.close();

}//cierra try

catch (SQLException e ){

JOptionPane.showMessageDialog(null,"estado"+e.getSQLState());

JOptionPane.showMessageDialog(null,"codigo de error:"+e.getErrorCode());

e.printStackTrace();

}

finally {

return estado;

}

}// fin del metodo existe

public int nuevo(Empledo emp){

int lineaAfectada=0;

Connection cn=getConexion();

//ejecucion de consultas sql

PreparedStatement ps =null;

try{

String sql="INSERT INTO empleado values"

+ "(?,?,?,?,?,?,?,?)";

ps=cn.prepareStatement(sql);

ps.setString(1,emp.getIdEmp());

ps.setString(2,emp.getNombEmp());

ps.setInt(3,emp.getHorasTrab());

ps.setDouble(4,emp.getPagoHora());

ps.setDouble(5,emp.getSueldo());

...