[justin000]

hi guys.

papatulong sana ako kung pano iconnect ung database ko na ginawa sa program ko eto ung code

import java.sql.*;

public class DatabaseLesson1 {
public DatabaseLesson1(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1 = DriverManager.getConnection("jdbcdbc:employee1") ;
Statement stmt = con1.createStatement ();

String sql = "Insert into table1 (name, age,add) values ( 'Eliza', '12', 'Espana')";

System.out.println("No of inserted :" + stmt.executeUpdate(sql));
con1.close();

}catch (ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e){
e.printStackTrace();
}
}
public static void main(String[] args) {
new DatabaseLesson1();
}
}

kung pwede step by step? eto kasi ung output nya

java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DatabaseLesson1.<init>(DatabaseLesson1.java:7)
at DatabaseLesson1.main(DatabaseLesson1.java:22)

[knowmeifyou]

try mo check signature ko bossing

[Yhash]

You need to setup the ODBC Datasource in the Control Panel.

BTW I recommend that you do not use MS Access instead use a free fully transactional RDBMS like Java DB.

[justin000]

thanks! and pwede paturo kung pano sya iconnect sa Javadb.

[Yhash]

@justin000

Basahin mo ung "Getting Started with Java DB". Here's the link:

*Only fully-registered users can see this link.*

[justin000]

import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;

public class MLPEfinalsDBsub extends JFrame{

private JLabel MLPElb1,MLPElb2,MLPElb3,MLPElb4;
private JButton MLPEbt1,MLPEbt2,MLPEbt3,MLPEbt4,MLPEbt5;
private JTextField MLPEtf1,MLPEtf2,MLPEtf3;
private MLPEadd MLPEad;
private MLPEdel MLPEdl;
private MLPEupdate MLPEud;
private MLPEcl MLPEcl1;
private MLPEexit MLPEe;
private String MLPEtfs1, MLPEtfs2, MLPEtfs3;
private String MLPEstring1;
private String MLPEstring2;
private String MLPEstring3;
private String MLPEjo1,MLPEjo2,MLPEjo3,MLPEjo4,MLPEjo5;

public MLPEfinalsDBsub(){
super("Database");
setLayout(new BorderLayout());

Panel Panel1=new Panel();
Panel1.setLayout(new GridLayout(0,1));
Panel1.add(MLPElb1=new JLabel("Name: "));
Panel1.add(MLPEtf1=new JTextField(15));
Panel1.add(MLPElb2=new JLabel("Age: (Numbers Only)"));
Panel1.add(MLPEtf2=new JTextField(15));
Panel1.add(MLPElb3=new JLabel("Year Level : (1st,2nd,3rd and 4th only)"));
Panel1.add(MLPEtf3=new JTextField(15));
add(Panel1,BorderLayout.NORTH);

Panel Panel2= new Panel();
Panel2.add(MLPEbt1=new JButton("Add"));
MLPEad=new MLPEadd();
MLPEbt1.addActionListener(MLPEad);

Panel2.add(MLPEbt2=new JButton("Delete"));
MLPEdl=new MLPEdel();
MLPEbt2.addActionListener(MLPEdl);

Panel2.add(MLPEbt3 = new JButton("Update"));
MLPEud= new MLPEupdate();
MLPEbt3.addActionListener(MLPEud);

Panel2.add(MLPEbt4 = new JButton("Clear"));
MLPEcl1 = new MLPEcl();
MLPEbt4.addActionListener(MLPEcl1);

Panel2.add(MLPEbt5 = new JButton("Exit"));
MLPEe = new MLPEexit();
MLPEbt5.addActionListener(MLPEe);
add(Panel2,BorderLayout.CENTER);

Panel Panel3 = new Panel();
Panel3.add(MLPElb4 = new JLabel(""));
add(Panel3,BorderLayout.SOUTH);
}
private class MLPEadd implements ActionListener{
public void actionPerformed(ActionEvent ae){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
MLPEtfs1 = MLPEtf1.getText();
MLPEtfs2 = MLPEtf2.getText();
MLPEtfs3 = MLPEtf3.getText();

insertDb(MLPEtfs1, MLPEtfs2, MLPEtfs3);
}
}
private class MLPEdel implements ActionListener{
public void actionPerformed(ActionEvent ae){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1;

con1 = DriverManager.getConnection("jdbcdbcB3");
if(MLPEtf1.getText().isEmpty()){
MLPEtfs1 = "";
}else{

MLPEtfs1 = "name = "+""+MLPEtf1.getText()+"";
}
if(MLPEtf2.getText().isEmpty()){
MLPEtfs2 = "";
}else{
MLPEtfs2 = "age = "+""+MLPEtf2.getText()+"";
}
if(MLPEtf2.getText().isEmpty()){
MLPEtfs2 = "";
}else{
MLPEtfs2 = "age = "+""+MLPEtf2.getText()+"";
}
if(MLPEtf2.getText().isEmpty()){
MLPEtfs3 = "";
}else{
MLPEtfs3 = "yearlevel = "+""+MLPEtf3.getText()+"";
}
Statement stat = con1.createStatement();
String sql = "delete from T1 where "+MLPEtfs1+MLPEtfs2+MLPEtfs3;
MLPElb4.setText("number of delete: "+stat.executeUpdate(sql));
con1.close();
}catch(SQLException e){
e.printStackTrace();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
}
}
private class MLPEupdate implements ActionListener{
public void actionPerformed(ActionEvent ae){
MLPEjo1 = JOptionPane.showInputDialog(null,"Update...(name,a ge or yearlevel.choose one only)","Update",JOptionPane.QUESTION_MESSAGE);
if(MLPEjo1.isEmpty()){
MLPElb4.setText("Nothing is Updated");
}else{
if(MLPEjo1.equalsIgnoreCase("name")){
MLPEjo2 = JOptionPane.showInputDialog(null,"Name?","Update", JOptionPane.QUESTION_MESSAGE);
MLPEstring1 = "name ="+""+MLPEjo2+"";
}else if (MLPEjo1.equalsIgnoreCase("age")){

MLPEjo2= JOptionPane.showInputDialog(null, "Age?", "Update", JOptionPane.QUESTION_MESSAGE);
MLPEstring1 = "age = "+MLPEjo2+"";
}else if(MLPEjo1.equalsIgnoreCase("year level")){
MLPEjo2 = JOptionPane.showInputDialog(null,"Year Level?(1st,2nd,3rd,4th.choose one only)", "Update",JOptionPane.QUESTION_MESSAGE);
MLPEstring1="yearlevel = "+""+MLPEjo2+"";
}else{
JOptionPane.showMessageDialog(null,"Error", "Wrong Input",JOptionPane.ERROR_MESSAGE);
}
MLPEjo3=JOptionPane.showInputDialog(null,"Where... (name, age or year level. choose one only)","where",JOptionPane.QUESTION_MESSAGE);

if(MLPEjo3.isEmpty()){
MLPElb4.setText("Nothing is Updated");
}else{
if(MLPEjo3.equalsIgnoreCase("name")){
MLPEjo4=MLPEjo2= JOptionPane.showInputDialog(null, "Name?", "Update", JOptionPane.QUESTION_MESSAGE);
MLPEstring2="name= "+""+MLPEjo4+"";
}else if(MLPEjo3.equalsIgnoreCase("age")){
MLPEjo4=JOptionPane.showInputDialog(null, "Age?", "Update", JOptionPane.QUESTION_MESSAGE);
MLPEstring2="age= "+""+MLPEjo4+"";
}else if(MLPEjo3.equalsIgnoreCase("year level")){
MLPEjo4=JOptionPane.showInputDialog(null, "Year Level?(1st,2nd,3rd,4th.choose one only)", "Update", JOptionPane.QUESTION_MESSAGE);
MLPEstring2="yearlevel= "+""+MLPEjo4+"";
}else{
JOptionPane.showMessageDialog(null,"Error", "Wrong Input",JOptionPane.ERROR_MESSAGE);
}
}
}
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1;

con1 = DriverManager.getConnection("jdbcdbcB3");
Statement stat=con1.createStatement();

String sql= "Update T1 set" + MLPEstring1+"where"+MLPEstring2;
MLPElb4.setText("number of records updated: "+stat.executeUpdate(sql));
con1.close();
}catch (SQLException e){
e.printStackTrace();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}

}
}
private class MLPEcl implements ActionListener{
public void actionPerformed(ActionEvent ae){
MLPEtf1.setText(null);
MLPEtf2.setText(null);
MLPEtf3.setText(null);
MLPEtf1.requestFocus();
}
}
private class MLPEexit implements ActionListener{
public void actionPerformed(ActionEvent ae){
System.exit(0);
}
}
public void insertDb(String name,String age,String yearlevel){
try{
Connection con1=DriverManager.getConnection("jdbcdbcB3");

Statement stat= con1.createStatement();

String sql="INSERT INTO T1(name,age,yearlevel)VALUES("+name+","+age+","+ye arlevel+")";

MLPElb4.setText("number of records inserted: "+stat.executeUpdate(sql));

con1.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}



again, new program, may error parn.

DB3 ung name ng Database at connectin (.mdb)
T1 ang name ng table ko

name = text
age = number
yearlevel = text

eto ung error pag Press ko ng "Add"

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '1st'.

help please.

[Yhash]

Try ko e debug ung program mo.

[justin000]

thanks! pls let me know pag naayos po.

[Yhash]

Nagawa ko na ung add ung delete tsaka update na lang may problema. Medyo matagal kasi may ginagawa pa ako ngayon eh.

[justin000]

no problem sir. matanong ko lang, sa codes ang problema, right?

bigay ng prof. namin yan actually. wala pa kaming formal subject ng database, i think intro lng yan kasi next sem pa kami magkakaron

and i barely understood the codes that she gave @.@

thanks in advance!