public EquiposDB() {
c = null;
stmt = null;
try {
Class.forName("com.mysql.jdbc.Driver");
c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/Equipos", "root", "camilo");
System.out.println("Conectado a Equipo.db");
stmt = c.createStatement();
String sql =
"CREATE TABLE IF NOT EXISTS Equipos"
+ "(ID INT NOT NULL AUTO_INCREMENT,"
+ " Nombre TEXT NOT NULL, "
+ " Formacion TEXT,"
+ " Arquero INT, "
+ " Defensor INT, "
+ " Mediocampo INT, "
+ " Ataque INT, "
+ " PRIMARY KEY(ID))";
stmt.executeUpdate(sql);
stmt.close();
c.close();
} catch (ClassNotFoundException | SQLException e) {
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
System.out.println("Tabla " + nteam + " creada");
}
private Connection createConnection() {
try {
closeConnection();
Class.forName("com.mysql.jdbc.Driver");
Properties properties = new Properties();
properties.setProperty("user", USER_NAME);
properties.setProperty("password", PASSWORD);
return DriverManager.getConnection(URL, USER_NAME, PASSWORD);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
return null;
}
@SuppressWarnings({"rawtypes", "unchecked"})
public VentanaRegistrarLibros() throws IOException {
setIconImage(
Toolkit.getDefaultToolkit()
.getImage(VentanaRegistrarLibros.class.getResource("/imagenes/Book.png")));
setForeground(new Color(173, 216, 230));
setTitle("Registro de Libros");
setAlwaysOnTop(true);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(100, 100, 680, 425);
setResizable(false);
setLocationRelativeTo(null);
contentPane = new CambiarImagenDelFondo("imagenes/Fondo.png");
contentPane.setAutoscrolls(true);
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblCdigo = new JLabel("Codigo:");
lblCdigo.setBounds(23, 46, 46, 14);
contentPane.add(lblCdigo);
textCodigo = new JTextField();
textCodigo.setEditable(false);
textCodigo.setBounds(79, 46, 93, 20);
contentPane.add(textCodigo);
textCodigo.setColumns(10);
JLabel lblAutor = new JLabel("Autor:");
lblAutor.setBounds(23, 102, 46, 14);
contentPane.add(lblAutor);
textAutor = new JTextField();
textAutor.setBounds(79, 102, 289, 20);
contentPane.add(textAutor);
textAutor.setColumns(10);
JLabel lblEdicin = new JLabel("Edicion:");
lblEdicin.setBounds(23, 130, 46, 14);
contentPane.add(lblEdicin);
textEdicion = new JTextField();
textEdicion.setBounds(79, 130, 93, 20);
contentPane.add(textEdicion);
textEdicion.setColumns(10);
JLabel lblEditora = new JLabel("Editora:");
lblEditora.setBounds(23, 158, 46, 14);
contentPane.add(lblEditora);
textEditora = new JTextField();
textEditora.setBounds(79, 158, 289, 20);
contentPane.add(textEditora);
textEditora.setColumns(10);
JLabel lblGnero = new JLabel("Genero: ");
lblGnero.setBounds(295, 220, 60, 14);
contentPane.add(lblGnero);
JComboBox comboBoxGenero = new JComboBox();
comboBoxGenero.setModel(
new DefaultComboBoxModel(
new String[] {"", "Romantica", "Comedia", "Drama", "Crimen", "Educativa", ""}));
getContentPane().add(comboBoxGenero, BorderLayout.SOUTH);
comboBoxGenero.addItemListener(
new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
genero = ((JComboBox) (e.getSource())).getSelectedItem().toString();
}
});
comboBoxGenero.setBounds(344, 214, 112, 20);
contentPane.add(comboBoxGenero);
JLabel lblNmeroDePginas = new JLabel("Numero de Paginas:");
lblNmeroDePginas.setBounds(295, 250, 124, 14);
contentPane.add(lblNmeroDePginas);
textNumeroPagina = new JTextField();
textNumeroPagina.setBounds(415, 245, 41, 20);
contentPane.add(textNumeroPagina);
textNumeroPagina.setColumns(10);
JLabel lblTipoDeMaterial = new JLabel("Tipo de Material:");
lblTipoDeMaterial.setBounds(23, 285, 100, 14);
contentPane.add(lblTipoDeMaterial);
final JComboBox comboBoxTipoMaterial = new JComboBox();
comboBoxTipoMaterial.setModel(
new DefaultComboBoxModel(new String[] {"", "Libros", "Audio Visuales"}));
getContentPane().add(comboBoxTipoMaterial, BorderLayout.SOUTH);
comboBoxTipoMaterial.addItemListener(
new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
tipoMaterial = ((JComboBox) (e.getSource())).getSelectedItem().toString();
}
});
comboBoxTipoMaterial.setBounds(141, 279, 124, 20);
contentPane.add(comboBoxTipoMaterial);
JButton btnGuardar = new JButton("Guardar");
btnGuardar.addMouseListener(
new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0) {
try {
// int codigo = Integer.parseInt(textCodigo.getText());
String isbn = textIsbn.getText();
String titulo = textTitulo.getText();
String autor = textAutor.getText();
String edicion = textEdicion.getText();
String editora = textEditora.getText();
// String tematica = textTematica.getText();
int numeroPagina = Integer.parseInt(textNumeroPagina.getText());
RegistrarLibros nuevoLibro = new RegistrarLibros();
// nuevoLibro.setIdlibro(codigo);
nuevoLibro.setIsbn(isbn);
nuevoLibro.setTitulo(titulo);
nuevoLibro.setAutor(autor);
nuevoLibro.setEdicion(edicion);
nuevoLibro.setCasaeditora(editora);
nuevoLibro.setGenero(genero);
nuevoLibro.setAniopublicacion(publicacion);
// nuevoLibro.setClasificaciontematica(tematica);
nuevoLibro.setTipomaterial(tipoMaterial);
nuevoLibro.setNumeropaginas(numeroPagina);
// nuevoLibro.pruebaConexx();
nuevoLibro.CargarRegistroMateriales(/*comboBoxTematica.getSelectedIndex()*/ );
nuevoLibro.CargarRegistroLibroNuevo();
nuevoLibro.CargarRegistroAutor();
Limpiar.limpiarCampos(VentanaRegistrarLibros.this.getContentPane());
JOptionPane.showMessageDialog(
VentanaRegistrarLibros.this, "Operacion Realiazada exitosamente!");
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
});
btnGuardar.setIcon(
new ImageIcon(VentanaRegistrarLibros.class.getResource("/imagenes/saveHS.png")));
btnGuardar.setBounds(535, 87, 107, 23);
contentPane.add(btnGuardar);
JButton btnCancelar = new JButton("Cancelar");
btnCancelar.addMouseListener(
new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0) {
Limpiar.limpiarCampos(VentanaRegistrarLibros.this.getContentPane());
}
});
btnCancelar.setIcon(
new ImageIcon(VentanaRegistrarLibros.class.getResource("/imagenes/DeleteHS.png")));
btnCancelar.setBounds(535, 121, 106, 23);
contentPane.add(btnCancelar);
JLabel lblTtulo = new JLabel("Titulo:");
lblTtulo.setBounds(23, 74, 46, 14);
contentPane.add(lblTtulo);
textTitulo = new JTextField();
textTitulo.setBounds(79, 74, 289, 20);
contentPane.add(textTitulo);
textTitulo.setColumns(10);
JLabel lblFechaDePublicacin = new JLabel("Anio de Publicacion:");
lblFechaDePublicacin.setBounds(23, 220, 124, 14);
contentPane.add(lblFechaDePublicacin);
JComboBox comboBoxFechaPublicacion = new JComboBox(Utilidades.obtenerFechas());
getContentPane().add(comboBoxFechaPublicacion, BorderLayout.SOUTH);
comboBoxFechaPublicacion.addItemListener(
new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
publicacion = ((JComboBox) (e.getSource())).getSelectedItem().toString();
}
});
comboBoxFechaPublicacion.setBounds(141, 217, 124, 20);
contentPane.add(comboBoxFechaPublicacion);
comboBoxTematica = new JComboBox();
try {
RegistrarLibros.CargarComboBoxTematica(comboBoxTematica);
} catch (ClassNotFoundException | SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
comboBoxTematica.addItemListener(
new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
tematica = ((JComboBox) (e.getSource())).getSelectedItem().toString();
try {
RegistrarLibros.CargarIdTematica(tematica);
} catch (ClassNotFoundException | SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
comboBoxTematica.setBounds(141, 247, 124, 20);
contentPane.add(comboBoxTematica);
JLabel lblTemtica = new JLabel("Tematica:");
lblTemtica.setBounds(23, 251, 60, 14);
contentPane.add(lblTemtica);
File archivo = new File("fondos/predeterminado.png");
String rutaAbsoluta = archivo.getAbsolutePath();
imagenMaterial = new ImagenDeFondo(rutaAbsoluta);
imagenMaterial.setBorder(
new TitledBorder(
new LineBorder(new Color(0, 0, 0)),
"Imagen",
TitledBorder.CENTER,
TitledBorder.TOP,
null,
null));
imagenMaterial.establecerImagen(rutaAbsoluta);
obtenerImagenMaterial().setBounds(499, 189, 143, 141);
contentPane.add(obtenerImagenMaterial());
JLabel lblIsnb = new JLabel("ISBN:");
lblIsnb.setBounds(241, 49, 35, 14);
contentPane.add(lblIsnb);
textIsbn = new JTextField();
textIsbn.setColumns(10);
textIsbn.setBounds(275, 46, 93, 20);
contentPane.add(textIsbn);
JButton btnActualizar = new JButton("Actualizar");
btnActualizar.setIcon(
new ImageIcon(VentanaRegistrarLibros.class.getResource("/imagenes/NewDocumentHS.png")));
btnActualizar.setBounds(535, 53, 107, 23);
contentPane.add(btnActualizar);
JButton button = new JButton("");
button.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent arg0) {}
});
button.setIcon(new ImageIcon(VentanaRegistrarLibros.class.getResource("/imagenes/Find.png")));
button.setBounds(182, 43, 41, 23);
contentPane.add(button);
JButton btnExaminar = new JButton("Examinar");
btnExaminar.setBounds(499, 332, 143, 23);
btnExaminar.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent arg0) {
imagenMaterial.seleccionarImagen();
}
});
contentPane.add(btnExaminar);
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
HttpSession session = request.getSession();
int userid = (Integer) session.getAttribute("id");
int zipcode = 0;
String street = null;
String addressline1 = null;
String addressline2 = null;
String city = null;
String country = null;
String state = null;
String cardname = null;
String cardnum = null;
Class.forName(ConnectionConstants.driver);
Connection conn =
DriverManager.getConnection(
ConnectionConstants.url,
ConnectionConstants.userName,
ConnectionConstants.dbpassword);
String query = "select mobile from accountdetails where userid=?";
String query1 = "select * from creditcarddetails where userid=?";
String query2 =
"select a.* from address a, addressmaster b where b.userid = ? and a.addressnumber = b.addressnumber";
PreparedStatement ps = conn.prepareStatement(query);
ps.setInt(1, userid);
PreparedStatement ps1 = conn.prepareStatement(query1);
ps1.setInt(1, userid);
PreparedStatement ps2 = conn.prepareStatement(query2);
ps2.setInt(1, userid);
ResultSet rs = ps.executeQuery();
ResultSet rs1 = ps1.executeQuery();
ResultSet rs2 = ps2.executeQuery();
if (rs.next()) {
String amobile = rs.getString(1);
response.setContentType("TEXT/HTML");
request.setAttribute("mobile", amobile);
}
if (rs1.next()) {
cardname = rs1.getString(2);
cardnum = rs1.getString(3);
response.setContentType("TEXT/HTML");
request.setAttribute("cardname", cardname);
request.setAttribute("cardnum", cardnum);
}
if (rs2.next()) {
street = rs2.getString(2);
addressline1 = rs2.getString(3);
addressline2 = rs2.getString(4);
city = rs2.getString(5);
state = rs2.getString(6);
zipcode = rs2.getInt(7);
country = rs2.getString(8);
response.setContentType("TEXT/HTML");
request.setAttribute("street", street);
request.setAttribute("addressline1", addressline1);
request.setAttribute("addressline2", addressline2);
request.setAttribute("city", city);
request.setAttribute("zipcode", zipcode);
request.setAttribute("country", country);
request.setAttribute("state", state);
}
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}