siempre doy las gracias :S no soy ingrato
Esta sección te permite ver todos los mensajes escritos por este usuario. Ten en cuenta que sólo puedes ver los mensajes escritos en zonas a las que tienes acceso en este momento.
Mostrar Mensajes Menú
import java.sql.*;
import javax.swing.JOptionPane;
public class BDManagent {
private final static String drv = "com.mysql.jdbc.Driver";
private final static String db = "jdbc:mysql://127.0.0.1:3306/mapers";
private final static String usar = "root";
private final static String Pass = "mapers";
private Connection ct;
private Statement st;
public BDManagent() {
try {
Class.forName(drv);
ct = DriverManager.getConnection(db, usar, Pass);
st = ct.createStatement();
JOptionPane.showMessageDialog(null, "Me conecte !!!!");
} catch (Exception e) {
System.out.println("No se pudo conectar con la base de datos");
}
}
public void showAll() {
try {
ResultSet rs = st.executeQuery("SELECT * FROM mapers");
while (rs.next()) {
System.out.println(rs.getString(1) + " | " + rs.getString(2)+ " | " + rs.getString(3));
}
} catch (Exception e) {
System.out.println("Error al realizar la consulta");
}
}
public Statement getSt() {
return st;
}
}
public class Usuario_pass extends javax.swing.JFrame {
/** Creates new form Usuario_pass */
public String cadena ;
public String cadena1 ;
public String getCadena() {
return cadena;
}
public void setCadena(String cadena) {
this.cadena = cadena;
}
public String getCadena1() {
return cadena1;
}
public void setCadena1(String cadena1) {
this.cadena1 = cadena1;
}
public Usuario_pass() {
initComponents();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jTextField2 = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
jButton1 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("Usuario");
jTextField1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField1ActionPerformed(evt);
}
});
jTextField1.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
jTextField1KeyPressed(evt);
}
});
jLabel2.setText("clave");
jButton1.setText("conectar");
jButton1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jButton1MouseClicked(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(26, 26, 26)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 46, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(56, 56, 56)
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 46, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(56, 56, 56)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(layout.createSequentialGroup()
.addGap(103, 103, 103)
.addComponent(jButton1)))
.addContainerGap(78, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(77, 77, 77)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(40, 40, 40)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(51, 51, 51)
.addComponent(jButton1)
.addContainerGap(69, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
cadena =jTextField1.getText();
cadena1 =jTextField2.getText();
}
private void jTextField1KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField2;
// End of variables declaration
}
public class jdbc_ {
public static void main(String[] args) {
Usuario_pass up =new Usuario_pass();
up.setVisible(true);
System.out.println(up.getCadena());
System.out.println(up.getCadena1());
}
}
ILE *fi;
stIndice ind;
long inf, sup, n, nRegs;
fi = fopen("indices.ind", "rb");
fseek(fi, 0, SEEK_END);
nRegs = ftell(fi)/sizeof(stIndice);
// Búsqueda binaria:
inf = 0;
sup = nRegs-1;
do {
n = inf+(sup-inf)/2;
fseek(fi, n*sizeof(stIndice), SEEK_SET);
fread(&ind, sizeof(stIndice), 1, fi);
if(strcmp(ind.telefono, telefono) < 0) inf = n+1;
else sup = n-1;
} while(inf <= sup && strcmp(ind.telefono, telefono));
#include <cstdlib>
#include <iostream>
#include <IO.h>
#include <string.h>
#include <sys\STAT.h>
#include <FCNTL.h>
using namespace std;
long int pos=0;
int fd = 0,lr,le,x;
struct encabezado{
int NRS;
int PR;
}e;
struct registro{
int NR;
char NOM[20];
int PTJE;
int SR;
}n,a,s;
void escribir()
{
char rpta;
char band;
if((fd = creat("a3.txt",S_IWRITE | S_IREAD)) < 0)//devuelve un entero si es q lo logra crear
{
cout<<"No se pudo crear"<<endl;
system("PAUSE");
exit(0);
}
le = sizeof(struct encabezado);
lr = sizeof(struct registro);
lseek(fd,le,0);
e.PR = -1;
e.NRS = 0;
do{
band='F';
fflush(stdin);
n.NR = ++e.NRS;
cout<<"Nombre: ";gets(n.NOM);
fflush(stdin);
cout<<"Puntaje: ";cin>>n.PTJE;
if(e.PR==-1)
{ n.SR=e.PR;
e.PR=n.NR;
}
else
{
x=e.PR;
while(x!=-1)
{
pos=(x-1)*lr + le;
lseek(fd,pos,0);
read(fd,&s,lr);
if(strcmp(n.NOM,s.NOM)>0)
{band='V'; a=s; x=s.SR; continue;}
if(strcmp(n.NOM,s.NOM)<0) x=-1;
};
if(band=='F')
{n.SR=e.PR;
e.PR=n.NR;
lseek(fd,0,2);
}
else
{ n.SR=a.SR;
a.SR=n.NR;
pos=(a.NR-1)*lr+le;
lseek(fd,pos,0);
write(fd,&a,lr);
lseek(fd,0,2);
}
}
write(fd,&n,lr);
cout<<"INGRESAR MAS REGISTROS (s/n): "<<endl;
cin>>rpta;
}while(rpta == 's');
lseek(fd,0,0);
write(fd,&e,le);
close(fd);
}
void leer()
{
if((fd = open("a3.txt",O_TEXT)) < 0)//devuelve un entero si es q lo logra crear
{
cout<<"No se pudo abrir"<<endl;
system("PAUSE");
exit(0);
}
le = sizeof(struct encabezado);
lr = sizeof(struct registro);
read(fd,&e,le);
cout<<"PR : "<<e.PR<<" NRS : "<<e.NRS<<endl;
cout<<"NR\t " << "Nombre\t" << "Ptje\t"<<"SR"<<endl;
x=e.PR;
while(x!=-1)
{
pos=(x-1)*lr + le;
lseek(fd,pos,0);
read(fd,&a,lr);
cout<<a.NR<<"\t"<<a.NOM<<"\t"<<a.PTJE<<"\t"<<a.SR<<endl;
x=a.SR;
}
close(fd);
}
int main(int argc, char *argv[])
{
int op;
do{ cout<<"LISTA ENLAZADA ORDENADA"<<endl;
cout<<"1.escribir 2.leer 3.Salir"<<endl;
cin>>op;
switch(op){
case 1: escribir();break;
case 2: leer();break;
case 3: break;
};
}while(op!=3);
system("PAUSE");
return EXIT_SUCCESS;
}