Programacion Java Netbeans y MySql

miércoles, 4 de septiembre de 2024

Conectar a MySql con Java Netbeans mediante un Formulario

Tener agregado en libraries el conector mysql.

clase coneBD.java
package pktForm12;
import java.sql.*;
import javax.swing.JOptionPane;
public class coneBD {
public static PreparedStatement prest=null;
public static CallableStatement cllst=null;
public static Connection conec=null;
public static Statement st=null;
public static ResultSet rt=null;
public static String usu;
public static String contra;
public static String host;
public static String db;
public void Conectar(){
try{
   usu="root"; contra=""; host="localhost"; db="ventas";
   String url="jdbc:mysql://"+host+"/"+db;
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   conec=DriverManager.getConnection(url,usu,contra);
}catch(Exception e){
   JOptionPane.showMessageDialog(null, e.toString());
}
}
}

package pktForm12;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class frmListar extends javax.swing.JFrame {
   coneBD cn=new coneBD();
   DefaultTableModel modelo=new DefaultTableModel();
public frmListar() {
   initComponents();
   String titu[]={"IDCliente","Nombres","Apellidos","Direccion","Telefono","E-mail"};
   modelo.setColumnIdentifiers(titu);
   tblClientes.setModel(modelo);
}
private void llenarT() {
   String SQL="select * from clientes;";
   String datos[]=new String[6];
   try{
   cn.Conectar();
   cn.st=cn.conec.createStatement();
   cn.rt=cn.st.executeQuery(SQL);
   while (cn.rt.next()){
   datos[0]=cn.rt.getString(1);
   datos[1]=cn.rt.getString(2);
   datos[2]=cn.rt.getString(3);
   datos[3]=cn.rt.getString(4);
   datos[4]=cn.rt.getString(5);
   datos[5]=cn.rt.getString(6);
   modelo.addRow(datos);
   }
   }catch(Exception e){
       JOptionPane.showMessageDialog(null, e.toString());
   }
}
private void btnListarActionPerformed(java.awt.event.ActionEvent evt) {
   llenarT();
}

Se programa en Java, PHP, MySql, Visual Basic .Net desde 100 USD - Tec. Miguel Nunez minuvasoft10@gmail.com

miércoles, 10 de julio de 2024

Listar Productos con Imagen con PHP y MySql + Codigo Fuente

Las imagenes estan en la carpeta productos dentro de htdocs, en la tabla productos hay una columna que guarda el nombre de la imagen.

<?php

$servername = "localhost";

$username = "minuvahard10";

$password = "unodostres";

$dbname = "ventas";

echo '<head><link rel="stylesheet" type="text/css" href="style.css" /></head>';

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT * FROM productos";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

echo "<table>";

echo "<tr><th>Barcode</th><th>Nombre</th><th>Precio</th></tr>";

while($row = $result->fetch_assoc()) {

$var = $row["barcode"];

$cad = "<tr><td>". $row["barcode"]."</td><td>". $row["nombre"]."</td><td>". $row["precio"]."</td><td><img src='productos/". $row["imagen"]."'></td>";

echo $cad; ?>

<td><a href='detalle.php?codi=<?php echo $var; ?>'><p onmouseover=''>Detalle</p></a></td></tr>

<?php

}

echo "</table>";

} else {

echo "0 results";

}

$conn->close();

Download Source Code

Download Data Base

Se Desarrolla Proyectos Software con PHP y MySql - Miguel Nunez - minuvasoft10@gmail.com

domingo, 7 de julio de 2024

Mini Software de Recibo con Java Netbeans Mysql + Codigo de Barras + Impresion + Codigo Fuente

Clase de Formulario frmBuscarBC.java

package pktForm12;

import java.awt.Font;

import java.awt.Graphics;

import java.awt.Graphics2D;

import java.awt.print.PageFormat;

import java.awt.print.Printable;

import static java.awt.print.Printable.NO_SUCH_PAGE;

import static java.awt.print.Printable.PAGE_EXISTS;

import java.awt.print.PrinterException;

import java.awt.print.PrinterJob;

import java.util.HashSet;

import java.util.Set;

import javax.swing.JOptionPane;

import javax.swing.SwingConstants;

import javax.swing.table.DefaultTableCellRenderer;

import javax.swing.table.DefaultTableModel;

public class frmBuscarBC extends javax.swing.JFrame {

coneBD cn=new coneBD();

DefaultTableModel modelo=new DefaultTableModel();

public frmBuscarBC() {

initComponents();

String titu[]={"IDProducto","Nombre","Precio"};

modelo.setColumnIdentifiers(titu);

tblPro.setModel(modelo);

tblPro.getColumnModel().getColumn(1).setPreferredWidth(200);

DefaultTableCellRenderer cellRenderer = new DefaultTableCellRenderer();

cellRenderer.setHorizontalAlignment(SwingConstants.RIGHT);

tblPro.getColumnModel().getColumn(2).setCellRenderer(cellRenderer);

}

private void txtBuscarActionPerformed(java.awt.event.ActionEvent evt) {

String SQL="select * from productos where barcode like '"+txtBuscar.getText()+"%';";

String datos[]=new String[3];

int op=0;

try{

cn.Conectar();

cn.st=cn.conec.createStatement();

cn.rt=cn.st.executeQuery(SQL);

while (cn.rt.next()){

datos[0]=cn.rt.getString(1);

datos[1]=cn.rt.getString(2);

datos[2]=cn.rt.getString(3);

modelo.addRow(datos);

op=1;

}

}catch(Exception e){

JOptionPane.showMessageDialog(null, e.toString());

}

if (op==0) {

JOptionPane.showMessageDialog(null, "No tenemos el producto "+txtBuscar.getText());

} else {

calTot();

}

txtBuscar.setText(null);

}

private void btnPrintActionPerformed(java.awt.event.ActionEvent evt) {

PrinterJob job = PrinterJob.getPrinterJob();

job.setPrintable(new Printable() {

public int print(Graphics pg, PageFormat pf, int pageNum){

if (pageNum > 0){

return Printable.NO_SUCH_PAGE;

}

Font fuente = new Font("courier",Font.PLAIN,10);

Graphics2D g2 = (Graphics2D) pg;

g2.setFont(fuente);

g2.drawString("minuvaMarket", 100, 100);

int n = modelo.getRowCount(); int i=0;

for(i=0;i<n;i++) {

g2.drawString(""+modelo.getValueAt(i, 0).toString(), 100, i*20+125);

g2.drawString(""+modelo.getValueAt(i, 1).toString(), 200, i*20+125);

g2.drawString(""+modelo.getValueAt(i, 2).toString(),350, i*20+125);

}

jPanel1.paint(g2);

return Printable.PAGE_EXISTS;

}

});

try {

job.print();

} catch(PrinterException e) {

e.printStackTrace();

}

private void calTot() {

int n = modelo.getRowCount();

int i; double S=0; double tax=0; double tot=0;

for(i=0;i<n;i++) {

S = S + Double.parseDouble(modelo.getValueAt(i, 2).toString());

}

S = redo(S);

lblSub.setText(S+"");

tax = 0.1*S;

tax = redo(tax);

lblTax.setText(tax+"");

tot = S+tax;

tot = redo(tot);

lblTot.setText(tot+"");

}

private double redo(double num){

return Math.rint(num*100)/100;

}

Clase de Conexion coneBD.java

package pktForm12;

import java.sql.*;

import javax.swing.JOptionPane;

public class coneBD {

public static PreparedStatement prest=null;

public static CallableStatement cllst=null;

public static Connection conec=null;

public static Statement st=null;

public static ResultSet rt=null;

public static String usu;

public static String contra;

public static String host;

public static String db;

public void Conectar(){

try{

usu="root"; contra=""; host="localhost"; db="ventas";

String url="jdbc:mysql://"+host+"/"+db;

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

conec=DriverManager.getConnection(url,usu,contra);

}catch(Exception e){

JOptionPane.showMessageDialog(null, e.toString());

}

Tener Agregado en Libraries el conector mysql

Download Source Code

Para Un Software Optimo comunicarse a minuvasoft10@gmail.com - Miguel Nunez

Download Database

lunes, 1 de julio de 2024

Buscador con Imagen y PHP Mysql Select Like % + variable

tabla productos

buscar2.php

<html>

<body>

</form>

<?php

if (isset($_POST['nom'])) {

   $keyw = $_POST['nom'];

   $dbhost = 'localhost';

   $dbuser = 'minuvahard10';

   $dbpass = 'unodostres';

   $dbname = 'ventas';

   $mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

   if($mysqli->connect_errno ) {

      printf("Connect failed: %s<br />", $mysqli->connect_error);

      exit();

}

   $result = $mysqli->query("SELECT * FROM productos where nombre like '$keyw%'");

   if ($result->num_rows > 0) {

      echo "<table>";

      while($row = $result->fetch_assoc()) {

         $r2 = $row['imagen'];

         echo "<tr>";

         echo "<td><img src='productos/$r2' style='width: 300px;'></td><td>".$row['barcode']." ".$row['nombre']." ".$row['precio']."</td>";    

         echo "</tr>";          

}

      echo "</table>";

   } else {

      printf('No record found.<br />');

}

   mysqli_free_result($result);

   $mysqli->close();

}

?>

</body>

</html>

Se Desarrolla Proyectos Software - Miguel Nunez - minuvasoft10@gmail.com

viernes, 7 de junio de 2024

Inversa de una Matrix nxn con Java Netbeans + Codigo Fuente

Metodos Numericos, Analisis Numerico.

import javax.swing.table.DefaultTableModel;

public class frmInversa extends javax.swing.JFrame {

DefaultTableModel modelA = new DefaultTableModel();

DefaultTableModel modelI = new DefaultTableModel();

public frmInversa() {

initComponents();

tblA.setModel(modelA);

tblI.setModel(modelI);

cargarA3();

}

private void cargarA5() {

modelA.setColumnCount(5);

modelI.setColumnCount(5);

String dat[] = new String[5];

dat[0] = "6.5"; dat[1]="2.5"; dat[2]="3.5"; dat[3]="4.5"; dat[4]="5.5";

modelA.addRow(dat);

dat[0] = "6"; dat[1]="7"; dat[2]="8"; dat[3]="9"; dat[4]="10";

modelA.addRow(dat);

dat[0] = "9"; dat[1]="8"; dat[2]="1.5"; dat[3]="6"; dat[4]="5";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="3"; dat[2]="2"; dat[3]="11.5"; dat[4]="0";

modelA.addRow(dat);

dat[0] = "-1"; dat[1]="-2"; dat[2]="3"; dat[3]="-4"; dat[4]="5";

modelA.addRow(dat);

}

private void cargarA4() {

modelA.setColumnCount(4);

modelI.setColumnCount(4);

String dat[] = new String[4];

dat[0] = "1"; dat[1]="2"; dat[2]="3"; dat[3]="10";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="5"; dat[2]="6"; dat[3]="11";

modelA.addRow(dat);

dat[0] = "7"; dat[1]="2"; dat[2]="9"; dat[3]="1";

modelA.addRow(dat);

dat[0] = "5.5"; dat[1]="2.5"; dat[2]="9.5"; dat[3]="1.5";

modelA.addRow(dat);

}

private void cargarA3() {

modelA.setColumnCount(3);

modelI.setColumnCount(3);

String dat[] = new String[3];

dat[0] = "1"; dat[1]="2"; dat[2]="3";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="5"; dat[2]="6";

modelA.addRow(dat);

dat[0] = "7"; dat[1]="2"; dat[2]="9";

modelA.addRow(dat);

}

private void cargarA2() {

modelA.setColumnCount(2);

modelI.setColumnCount(2);

String dat[] = new String[2];

dat[0] = "1"; dat[1]="2";

modelA.addRow(dat);

dat[0] = "4"; dat[1]="5";

modelA.addRow(dat);

}

private void btnInvActionPerformed(java.awt.event.ActionEvent evt) { int i,j,k;

Deter D = new Deter();

int N = modelA.getRowCount();

modelI.setColumnCount(N);

modelI.setRowCount(0);

double adjA[][] = new double[N][N];

double A[][] = new double[N][N];

double T[][] = new double[N][N];

double X[][] = new double[N][N];

double detA;

String dato[] = new String[N];

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

A[i][j] = Double.parseDouble(modelA.getValueAt(i, j).toString());

}

detA = D.deterM(A, N);

lblDet.setText("det(A)= "+detA);

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

k=i+2+j;

D.obtener(A, T, i, j, N);

adjA[i][j] = Math.pow(-1, k)*D.deterM(T, N-1);

X[j][i] = adjA[i][j]/detA;

}

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

dato[j] = X[i][j]+"";

}

modelI.addRow(dato);

}

private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) { int op = jComboBox1.getSelectedIndex();

modelA.setRowCount(0);

modelI.setRowCount(0);

lblDet.setText(null);

switch (op){

case 0: cargarA2(); break;

case 1: cargarA3(); break;

case 2: cargarA4(); break;

case 3: cargarA5(); break;

}

Download Source Code

minuvasoft10@gmail.com Miguel Nunez - Se desarrolla proyectos software.

martes, 4 de junio de 2024

Sistema de Ecuaciones Lineales nxn con Java Netbeans + Codigo Fuente

Se soluciona un Sistema de Ecuaciones lineales por determinantes utilizando el lenguaje de programacion Java, Metodos Numericos, Analisis Numerico.

import javax.swing.table.DefaultTableModel;

public class frmEcua extends javax.swing.JFrame {

DefaultTableModel modelA = new DefaultTableModel();

DefaultTableModel modelB = new DefaultTableModel();

DefaultTableModel modelX = new DefaultTableModel();

Deter D = new Deter();

public frmEcua() {

initComponents();

tblA.setModel(modelA);

tblB.setModel(modelB);

tblX.setModel(modelX);

cargaIni();

}

private void cargaIni() {

modelA.setColumnCount(3);

modelB.setColumnCount(1);

modelX.setColumnCount(1);

String titu[] = {"X"};

modelX.setColumnIdentifiers(titu);

String dat[] = new String[3];

String B[] = new String[1];

dat[0] = "1"; dat[1]="2"; dat[2]="3";

modelA.addRow(dat);

dat[0] = "1"; dat[1]="4"; dat[2]="9";

modelA.addRow(dat);

dat[0] = "1"; dat[1]="8"; dat[2]="27";

modelA.addRow(dat);

B[0] = "7"; modelB.addRow(B);

B[0] = "15"; modelB.addRow(B);

B[0] = "37"; modelB.addRow(B);

}

private void cargarM2() {

modelA.setRowCount(0);

modelB.setRowCount(0);

String titu[] = {"A","B"};

String dato1[] = {"0.55","1.55"};

String dato2[] = {"-0.55","3.55"};

String B[] = {"0.3545"};

modelB.addRow(B);

B[0] = "0.3595";

modelB.addRow(B);

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

}

private void cargarM3() {

modelA.setRowCount(0);

modelB.setRowCount(0);

String titu[] = {"A","B","C"};

String dato1[] = {"0.55","1.55","2.55"};

String dato2[] = {"-3.55","4.55","-5.55"};

String dato3[] = {"5.55","-6.55","7.55"};

String B[] = {"1.1"};

modelB.addRow(B);

B[0] = "11.1";

modelB.addRow(B);

B[0] = "-15.1";

modelB.addRow(B);

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

modelA.addRow(dato3);

}

private void cargarM4() {

modelA.setRowCount(0);

modelB.setRowCount(0);

String titu[] = {"A","B","C","D"};

String dato1[] = {"0.55","1.55","2.55","6.55"};

String dato2[] = {"-3.55","4.55","-5.55","7.55"};

String dato3[] = {"5.55","-6.55","7.55","8.55"};

String dato4[] = {"5","-6","7","2"};

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

modelA.addRow(dato3);

modelA.addRow(dato4);

String B[] = {"3.5"};

modelB.addRow(B);

B[0] = "2.55"; modelB.addRow(B);

B[0] = "4"; modelB.addRow(B);

B[0] = "-2"; modelB.addRow(B);

}

private void cargarM5() {

modelA.setRowCount(0);

String titu[] = {"A","B","C","D","E"};

String dato1[] = {"0.55","1.55","2.55","6.55","2.55"};

String dato2[] = {"-3.55","4.55","-5.55","7.55","-5.55"};

String dato3[] = {"5.55","-6.55","7.55","8.55","1.55"};

String dato4[] = {"6.55","-6.55","7.55","8.55","10.55"};

String dato5[] = {"-8.55","-6.55","1.55","8.55","1.55"};

modelA.setColumnIdentifiers(titu);

modelA.addRow(dato1);

modelA.addRow(dato2);

modelA.addRow(dato3);

modelA.addRow(dato4);

modelA.addRow(dato5);

modelB.setRowCount(0);

String B[] = {"11.55"}; modelB.addRow(B);

B[0] = "12.55"; modelB.addRow(B);

B[0] = "4.55"; modelB.addRow(B);

B[0] = "-2.55"; modelB.addRow(B);

B[0] = "-5.55"; modelB.addRow(B);

}

private void btnCalActionPerformed(java.awt.event.ActionEvent evt) { int i,j;

int N = modelA.getRowCount();

double detA;

double detAx[] = new double[N];

String R[]= new String[1];

double B[] = new double[N];

double A[][] = new double[N][N];

double T[][] = new double[N][N];

modelX.setRowCount(0);

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

A[i][j] = Double.parseDouble(modelA.getValueAt(i, j).toString());

T[i][j] = A[i][j];

}

B[i] = Double.parseDouble(modelB.getValueAt(i, 0).toString());

}

detA = Math.round(D.deterM(A, N)*1000.0)/1000.0;

for(j=0;j<N;j++) {

for(i=0;i<N;i++) {

T[i][j] = B[i];

}

detAx[j] = Math.round(D.deterM(T, N)*1000.0)/1000.0;

copy(A,T,N);

}

for(i=0;i<N;i++) {

R[0]=detAx[i]/detA+"";

modelX.addRow(R);

}

private void cmbMActionPerformed(java.awt.event.ActionEvent evt) { int op = cmbM.getSelectedIndex();

switch (op){

case 0: cargarM2(); break;

case 1: cargarM3(); break;

case 2: cargarM4(); break;

case 3: cargarM5(); break;

}

private void copy(double A[][],double T[][],int N) {

int i,j;

for(i=0;i<N;i++) {

for(j=0;j<N;j++) {

T[i][j] = A[i][j];

}

Download Source Code

minuvasoft10@gmail.com - Miguel Nunez, se desarrolla proyectos software

miércoles, 22 de mayo de 2024

Metodo de Biseccion - Metodos Numericos con Java Netbeans

import javax.swing.table.DefaultTableModel;

public class frmMetodo2 extends javax.swing.JFrame {

DefaultTableModel model = new DefaultTableModel();

DefaultTableModel model2 = new DefaultTableModel();

DefaultTableModel model3 = new DefaultTableModel();

public frmMetodo2() {

initComponents();

tblI.setModel(model);

tblI2.setModel(model2);

tblX.setModel(model3);

String titu[] = {"X","f(x)"};

String titu2[] = {"X0","X1"};

String titu3[] = {"X"};

model.setColumnIdentifiers(titu);

model2.setColumnIdentifiers(titu2);

model3.setColumnIdentifiers(titu3);

}

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

double i,f,x0,f0;

i=0.0;

f=0.0;

x0=0;

f0=0;

String dat[] = new String[2];

String dat2[] = new String[2];

for(i=-50;i<50;i++){

f = Math.exp(i)-2*i-2;

dat[0] = i + "";

dat[1] = f + "";

model.addRow(dat);

if (f*f0<0) {

dat2[0] = x0+"";

dat2[1] = i + "";

model2.addRow(dat2);

}

x0=i;

f0=f;

}

private void metodoBi(double x0,double x1) {

double xm,f0,fm;

double e;

String X[] = new String[1];

xm = (x0 + x1)/2;

e = Math.abs((xm-x0)/xm);

if (e>0.01) {

f0 = Math.exp(x0)-2*x0-2;

fm = Math.exp(xm)-2*xm-2;

if (f0*fm<0) {

metodoBi(x0,xm);

} else {

metodoBi(xm,x1);

}

} else {

X[0] = xm+"";

model3.addRow(X);

}

private void btnCalcActionPerformed(java.awt.event.ActionEvent evt) {

int n = model2.getRowCount();

if (n>0) {

double x0 = Double.parseDouble(model2.getValueAt(0, 0).toString());

double x1 = Double.parseDouble(model2.getValueAt(0, 1).toString());

metodoBi(x0,x1);

x0 = Double.parseDouble(model2.getValueAt(1, 0).toString());

x1 = Double.parseDouble(model2.getValueAt(1, 1).toString());

metodoBi(x0,x1);

}

Download Source Code

minuvasoft10@gmail.com