Buenas fijense que pues intento insertar mas datos a mi base de datos y pues solo me dice que estoy violando la llave primaria y que la estoy duplicando alguien me puede decir que hacer este es el codigo que utilizo
String conexion = "jdbc:mysql://localhost/cierre?" +
"User= root & Password =";
Connection conecta;
try{
conecta =
(Connection)DriverManager.getConnection(conexion,"root","Francisco");
String in ="CREATE TABLE IF NOT EXISTS cliente(id int, " +
"Nombre varchar(30), Apellido varchar(30), PRIMARY KEY (id));";
Statement st= null;
st = (Statement)conecta.createStatement();
JOptionPane.showMessageDialog(null,"rs creado \n");
int n = st.executeUpdate(in);
String con = "SELECT * FROM cliente";
Statement st2 = (Statement)conecta.createStatement();
ResultSet rs2= st2.executeQuery(con);
ResultSetMetaData metadat = rs2.getMetaData();
int numerocol=metadat.getColumnCount();
for (int i=1; i<numerocol; i++)
{
JOptionPane.showMessageDialog(null, metadat.getCatalogName(i)+"\t");
}
while (rs2.next())
{
for (int i =1; i<numerocol; i++)
{
JOptionPane.showMessageDialog(null, rs2.getObject(i));
}
}
}catch(SQLException e)
{
JOptionPane.showMessageDialog(null, "Exception en BD:"+e.toString());
}
}
}
Look how good they try to insert more data into my database and it just tells me that I am violating the primary key and that I'm duplicating someone can tell me to do this is the code I use:
String conexion = "jdbc:mysql://localhost/cierre?" + "User= root & Password ="; Connection conecta; try{ conecta = (Connection)DriverManager.getConnection(conexion,"root","Francisco"); String in ="CREATE TABLE IF NOT EXISTS cliente(id int, " + "Nombre varchar(30), Apellido varchar(30), PRIMARY KEY (id));"; Statement st= null; st = (Statement)conecta.createStatement(); JOptionPane.showMessageDialog(null,"rs creado \n"); int n = st.executeUpdate(in); String con = "SELECT * FROM cliente"; Statement st2 = (Statement)conecta.createStatement(); ResultSet rs2= st2.executeQuery(con); ResultSetMetaData metadat = rs2.getMetaData(); int numerocol=metadat.getColumnCount(); for (int i=1; i<numerocol; i++) { JOptionPane.showMessageDialog(null, metadat.getCatalogName(i)+"\t"); } while (rs2.next()) { for (int i =1; i<numerocol; i++) { JOptionPane.showMessageDialog(null, rs2.getObject(i)); } } }catch(SQLException e) { JOptionPane.showMessageDialog(null, "Exception en BD:"+e.toString()); } } }
INSERCION DE DATOSjavier May 30, 2011 at 12:10 AM
Buenas fijense que pues intento insertar mas datos a mi base de datos y pues solo me dice que estoy violando la llave primaria y que la estoy duplicando alguien me puede decir que hacer este es el codigo que utilizo String conexion = "jdbc:mysql://localhost/cierre?" + "User= root & Password ="; Connection conecta; try{ conecta = (Connection)DriverManager.getConnection(conexion,"root","Francisco"); String in ="CREATE TABLE IF NOT EXISTS cliente(id int, " + "Nombre varchar(30), Apellido varchar(30), PRIMARY KEY (id));"; Statement st= null; st = (Statement)conecta.createStatement(); JOptionPane.showMessageDialog(null,"rs creado \n"); int n = st.executeUpdate(in); String con = "SELECT * FROM cliente"; Statement st2 = (Statement)conecta.createStatement(); ResultSet rs2= st2.executeQuery(con); ResultSetMetaData metadat = rs2.getMetaData(); int numerocol=metadat.getColumnCount(); for (int i=1; i<numerocol; i++) { JOptionPane.showMessageDialog(null, metadat.getCatalogName(i)+"\t"); } while (rs2.next()) { for (int i =1; i<numerocol; i++) { JOptionPane.showMessageDialog(null, rs2.getObject(i)); } } }catch(SQLException e) { JOptionPane.showMessageDialog(null, "Exception en BD:"+e.toString()); } } }
thanksBarbara September 18, 2011 at 6:26 PM
Thanks, helped a lot!)
ResultSetMetaData INSERCION DE DATOS May 30, 2011 at 7:39 AM
Look how good they try to insert more data into my database and it just tells me that I am violating the primary key and that I'm duplicating someone can tell me to do this is the code I use: String conexion = "jdbc:mysql://localhost/cierre?" + "User= root & Password ="; Connection conecta; try{ conecta = (Connection)DriverManager.getConnection(conexion,"root","Francisco"); String in ="CREATE TABLE IF NOT EXISTS cliente(id int, " + "Nombre varchar(30), Apellido varchar(30), PRIMARY KEY (id));"; Statement st= null; st = (Statement)conecta.createStatement(); JOptionPane.showMessageDialog(null,"rs creado \n"); int n = st.executeUpdate(in); String con = "SELECT * FROM cliente"; Statement st2 = (Statement)conecta.createStatement(); ResultSet rs2= st2.executeQuery(con); ResultSetMetaData metadat = rs2.getMetaData(); int numerocol=metadat.getColumnCount(); for (int i=1; i<numerocol; i++) { JOptionPane.showMessageDialog(null, metadat.getCatalogName(i)+"\t"); } while (rs2.next()) { for (int i =1; i<numerocol; i++) { JOptionPane.showMessageDialog(null, rs2.getObject(i)); } } }catch(SQLException e) { JOptionPane.showMessageDialog(null, "Exception en BD:"+e.toString()); } } }
Post your Comment