lenguaje java ejercicios

tarea 6

HUATARONGO HUAMAN BRAND

2015

TAREA 06

PROBLEMA 70:

CLASE MANEJADOR:

package PROGRAMA70;

import java.sql.*;import java.util.logging.Level;import java.util.logging.Logger;public class CLASEMANEJADOR { private static Connection cn=null; private Statement st=null; beanAlumnos alum =new beanAlumnos(); public void conectar (String data,String user,String clave){ try { data="jdbc:mysql://localhost:3306/"+data; DriverManager.registerDriver(new com.mysql.jdbc.Driver()); cn=DriverManager.getConnection(data,user,clave); alum.enlasarConeccion(cn); } catch (SQLException ex) { Logger.getLogger(CLASEMANEJADOR.class.getName()).log(Level.SEVERE, null, ex); } }}

CLASE BEANALUMNO

package PROGRAMA70;

ing. sistemas - 2015

UNTELS – LENGUAJE DE PROGRAMACION II

import com.sun.org.apache.xerces.internal.impl.xpath.regex.Match;import java.sql.*;import java.util.logging.Level;import java.util.logging.Logger;import javax.swing.table.DefaultTableModel;

public class beanAlumnos {

private static Connection xcn = null; private Statement xst = null; private ResultSet xrs = null;

public class modificarTabla extends DefaultTableModel {

public boolean isCellEditable(int row, int column) { if (column == 3 | column == 4) { return true; } return false; } }

modificarTabla datos = new modificarTabla();

public void enlasarConeccion(Connection cn) { try { xcn = cn; xst = xcn.createStatement();

} catch (SQLException ex) { Logger.getLogger(beanAlumnos.class .getName()).log(Level.SEVERE, null, ex); } }

public DefaultTableModel llenarDatos() { double n1 = 0, n2 = 0, pro = 0; try { datos.addColumn("CODIGO"); datos.addColumn("NOMBRE"); datos.addColumn("APELLIDO"); datos.addColumn("NOTA 1"); datos.addColumn("NOTA 2"); datos.addColumn("PROMEDIO");

xrs = xst.executeQuery("select * from alumnos"); while (xrs.next()) { String fila[] = {



xrs.getString(1), xrs.getString(2), xrs.getString(3), String.valueOf(n1), String.valueOf(n2), String.valueOf(pro) }; datos.addRow(fila);

} } catch (SQLException ex) { Logger.getLogger(beanAlumnos.class .getName()).log(Level.SEVERE, null, ex); } return datos; }

public void modificarTabla(int fila_selec) { double n1 = 0, n2 = 0, pro = 0; if (fila_selec >= 0) { n1 = Double.parseDouble(datos.getValueAt(fila_selec, 3).toString()); n2 = Double.parseDouble(datos.getValueAt(fila_selec, 4).toString()); if (n1>=0 && n2>=0 && n1<=20 && n2<=20) { pro = (n1 + n2) / 2; pro = Math.round(pro * Math.pow(10, 2)) / Math.pow(10, 2); datos.setValueAt(String.valueOf(pro), fila_selec, 5); } }

}}

JFRAME55:

CLASEMANEJADOR db=new CLASEMANEJADOR(); private void formWindowOpened(java.awt.event.WindowEvent evt) { db.conectar("colegio", "root", "root"); jTable1.setModel(db.alum.llenarDatos()); jTable1.getColumn("CODIGO").setPreferredWidth(180); jTable1.getColumn("NOMBRE").setPreferredWidth(200); jTable1.getColumn("APELLIDO").setPreferredWidth(400); jTable1.getColumn("NOTA 1").setPreferredWidth(120); jTable1.getColumn("NOTA 2").setPreferredWidth(120); jTable1.getColumn("PROMEDIO").setPreferredWidth(160); }

private void jTable1PropertyChange(java.beans.PropertyChangeEvent evt) { db.alum.modificarTabla(jTable1.getSelectedRow()); }



PROBLEMA 71:

CLASE MANEJADOR:

package pPROGRAMA71;

import java.sql.*;import java.util.logging.Level;import java.util.logging.Logger;public class CLASEmANEJADOR { private static Connection cn=null; private Statement st=null; BEANpRODUCTOS farm =new BEANpRODUCTOS(); public void conectar (String data,String user,String clave){ try { data="jdbc:mysql://localhost:3306/"+data; DriverManager.registerDriver(new com.mysql.jdbc.Driver()); cn=DriverManager.getConnection(data,user,clave); farm.enlasarConeccion(cn); } catch (SQLException ex) { Logger.getLogger(CLASEmANEJADOR.class.getName()).log(Level.SEVERE, null, ex); } }}

CLASE71:

package pPROGRAMA71;

import java.sql.*;import java.util.logging.Level;import java.util.logging.Logger;



import javax.swing.table.DefaultTableModel;

public class BEANpRODUCTOS {

private static Connection xcn = null; private Statement xst = null; private ResultSet xrs = null; modificarTabla datos = new modificarTabla();

public class modificarTabla extends DefaultTableModel {

public boolean isCellEditable(int row, int column) { if (column == 3) { return true; } return false; } }

public void enlasarConeccion(Connection cn) { try { xcn = cn; xst = xcn.createStatement(); } catch (SQLException ex) { Logger.getLogger(BEANpRODUCTOS.class .getName()).log(Level.SEVERE, null, ex); } }

public DefaultTableModel llenarDatos() { try { datos.addColumn("CODIGO"); datos.addColumn("NOMBRE"); datos.addColumn("PRECIO LISTA"); datos.addColumn("DESCUENTO"); datos.addColumn("PRECIO VENTA");

xst = xcn.createStatement(); xrs = xst.executeQuery("select * from medicamentos"); while (xrs.next()) { String fila[] = { xrs.getString(1), xrs.getString(2), xrs.getString(3), xrs.getString(4),xrs.getString(5) }; datos.addRow(fila); }

return datos; } catch (SQLException ex) {



Logger.getLogger(BEANpRODUCTOS.class.getName()).log(Level.SEVERE, null, ex); } return datos; } public void ModificarTabla(int filaMod){ double des=0,prec_venta=0,prec_lista=0; int n; if (filaMod>=0) { des=Double.parseDouble(datos.getValueAt(filaMod, 3).toString()); prec_lista=Double.parseDouble(datos.getValueAt(filaMod, 2).toString()); prec_venta=prec_lista*(1-des); prec_venta=Math.round(prec_venta*Math.pow(10, 2))/Math.pow(10, 2); datos.setValueAt(String.valueOf(prec_venta), filaMod, 4); try { xst=xcn.createStatement(); xst.executeUpdate("update medicamentos set descuento='"+des+"',precio_venta='"+prec_venta+"' where codmed='"+datos.getValueAt(filaMod, 0)+"'"); } catch (SQLException ex) { Logger.getLogger(BEANpRODUCTOS.class.getName()).log(Level.SEVERE, null, ex); } } } }JFRAME56:

CLASEmANEJADOR db=new CLASEmANEJADOR(); private void jTable1PropertyChange(java.beans.PropertyChangeEvent evt) { db.farm.ModificarTabla(jTable1.getSelectedRow()); }

private void formWindowOpened(java.awt.event.WindowEvent evt) { db.conectar("farmacia", "root", "root"); jTable1.setModel(db.farm.llenarDatos());

}



PROBLEMA 72:

CLASE MANEJADOR:

package programa72;import java.sql.*;import java.util.logging.Level;import java.util.logging.Logger;import javax.swing.table.DefaultTableModel;public class claseManejador { private static Connection cn=null; private Statement st=null; private ResultSet rs=null; beanPacientes pac =new beanPacientes(); beanSintomas sint=new beanSintomas(); DefaultTableModel datos=new DefaultTableModel(); public void conectar (String data,String user,String clave){ try { data="jdbc:mysql://localhost:3306/"+data; DriverManager.registerDriver(new com.mysql.jdbc.Driver()); cn=DriverManager.getConnection(data,user,clave); pac.enlasarConeccion(cn); sint.enlasarConeccion(cn); } catch (SQLException ex) { Logger.getLogger(claseManejador.class.getName()).log(Level.SEVERE, null, ex); }



} public DefaultTableModel tablaInicio(){ datos.addColumn("CODIGO PACIENTE"); datos.addColumn("CODIGO SINTOMA"); return datos; } public DefaultTableModel llenarDatos(String xnompac,String xnomsin){ try { st=cn.createStatement(); rs=st.executeQuery("select codpac,codsin from pacientes,sintomas where nompac='"+xnompac+"' and nomsin='"+xnomsin+"'"); if (rs.next()) { String fila[]={ rs.getString(1),rs.getString(2) }; datos.addRow(fila); } } catch (SQLException ex) { Logger.getLogger(claseManejador.class.getName()).log(Level.SEVERE, null, ex); } return datos; } public void registrarDatos(int nroFilas){ try { st=cn.createStatement(); for (int i = 0; i < nroFilas; i++) { String xcodpac=datos.getValueAt(i, 0).toString(); String xcodsin=datos.getValueAt(i, 1).toString(); st.executeUpdate("insert into pacientessintomas values ('"+xcodpac+"','"+xcodsin+"')"); } } catch (SQLException ex) { Logger.getLogger(claseManejador.class.getName()).log(Level.SEVERE, null, ex); } }}

CLASE beansintomas:

package programa72;

import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;



import java.util.logging.Level;import java.util.logging.Logger;import javax.swing.DefaultComboBoxModel;

public class beanSintomas { private static Connection xcn = null; private Statement xst = null; private ResultSet xrs = null;

public void enlasarConeccion(Connection cn) { try { xcn = cn; xst = xcn.createStatement(); } catch (SQLException ex) { Logger.getLogger(beanSintomas.class .getName()).log(Level.SEVERE, null, ex); } } public DefaultComboBoxModel llenarComboSintomas(){ DefaultComboBoxModel sin=new DefaultComboBoxModel(); try { xst=xcn.createStatement(); xrs=xst.executeQuery("select * from sintomas"); while (xrs.next()) { sin.addElement(xrs.getString(2)); } } catch (SQLException ex) { Logger.getLogger(beanSintomas.class.getName()).log(Level.SEVERE, null, ex); } return sin; } public void generarCodigoSintomaNuevo(){ try { String xnro=""; xst=xcn.createStatement(); xrs=xst.executeQuery("select count(*) from sintomas"); xnro=xrs.getString(1); xnro="000000"+String.valueOf(Integer.parseInt(xnro)+1); xnro="SIN"+xnro.substring(xnro.length()-3); } catch (SQLException ex) { Logger.getLogger(beanSintomas.class.getName()).log(Level.SEVERE, null, ex); } }}



CLASE beanpacientes:

package programa72;

import java.sql.*;import java.util.logging.Level;import java.util.logging.Logger;import pPROGRAMA71.BEANpRODUCTOS;

public class beanPacientes {

private static Connection xcn = null; private Statement xst = null; private ResultSet xrs = null; String xnro="";

public void enlasarConeccion(Connection cn) { try { xcn = cn; xst = xcn.createStatement(); } catch (SQLException ex) { Logger.getLogger(beanPacientes.class .getName()).log(Level.SEVERE, null, ex); } }

public void generarCodigoPaciente() { try { xst = xcn.createStatement(); xrs = xst.executeQuery("select count(*) from pacientes"); xrs.next(); xnro = xrs.getString(1); xnro = "00" + String.valueOf(Integer.parseInt(xnro) + 1); xnro = "PAC" + xnro.substring(xnro.length() - 3); } catch (SQLException ex) { Logger.getLogger(beanPacientes.class.getName()).log(Level.SEVERE, null, ex); } } public void agregarPaciente(String xnom,String xape) { try { xst = xcn.createStatement(); xst.executeUpdate("insert into pacientes values('"+xnro+"','"+xnom+"','"+xape+"')"); } catch (SQLException ex) { Logger.getLogger(beanPacientes.class.getName()).log(Level.SEVERE, null, ex); }



}

}

JFRAME72:

claseManejador db=new claseManejador(); private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) { jTable1.setModel(db.llenarDatos(jTextField1.getText(), jComboBox1.getSelectedItem().toString())); }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { db.registrarDatos(jTable1.getRowCount()); }

private void formWindowOpened(java.awt.event.WindowEvent evt) { db.conectar("consultorio", "root", "root"); jComboBox1.setModel(db.sint.llenarComboSintomas()); jTable1.setModel(db.tablaInicio()); }

private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: }

private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) { db.pac.generarCodigoPaciente(); db.pac.agregarPaciente(jTextField1.getText(), jTextField3.getText()); }



lenguaje java ejercicios

Documents