Examples of DBHandler

niso.DBHandler
org.openqreg.db.DbHandler
DbHandler is an utilityclass intended to handle the communication between beans and the database. @author Henrik Heijkenskj�ld, Roger Svensson @version 1.03 Skapat: Uppdaterad: 2004-01-22 Uppdaterad av: Olov Felton�ndring: Har laggt till nullning av connection, resultset och statement. Detta f�rhindrar att man f�r tillbaka st�ngda connections fr�n poolen. Uppdaterad: 2004-07-01 Uppdaterad av: Roger Svensson �ndring: Lagt till st�d f�r att anv�nda Routines(Stored Procedures) samt korrigerat en hel del varningar Updated: 2004-11-22 Change: Added two functions getConnection, returns a new connection from the db, addNewPreparedStatementTransaction adds a new prepared statement to the running transaction. @responsible Henrik

Examples of niso.DBHandler

    else SaveModificationsBt.setEnabled(true);
  }


  @Override
  public void actionPerformed(ActionEvent AE) {
    DBHandler DBH=Parent.getDBHandler();
    if(AE.getSource()==AddBt){
      String newUser=AdduserBox.getText();
      DBH.MySQLinsert("INSERT into UserAccount values('"+newUser+"','"+AddPass.getText()+"','"+AddUserType.getSelectedItem()+"');",ErrorAdd);
      setComboBoxItems(UserBox);
      setComboBoxItems(DelUserBox);
      UserBox.setSelectedItem(newUser);
      
      
      AdduserBox.setText("");
      AddPass.setText("");
      AddPass.setEditable(false);
      AddBt.setEnabled(false);
      
      if(ErrorAdd.getText().length()==0){
        CheckLbl.setIcon(Parent.getCheckImage());
        CheckLbl.setText("Insertion Complete");
      }
      SaveModificationsBt.setEnabled(false);
      
    }
    else if(AE.getSource()==DelBt){
      try {
        DBH.MySQLUpdate("DELETE FROM UserAccount where Username='"+DelUserBox.getSelectedItem()+"';");
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        ErrorDel.setForeground(Color.RED);
        ErrorDel.setText("Error in deleting");
      }
      setComboBoxItems(UserBox);
      setComboBoxItems(DelUserBox);
    }
    else if(AE.getSource()==SaveModificationsBt&&NameBox.getText().length()>0){
      User Selected=Users.get(UserBox.getSelectedIndex());
      String name=Selected.getUserName(),Pass=Selected.getUserPassword();
      try {
        DBH.MySQLUpdate("UPDATE UserAccount SET Username='"+NameBox.getText()+"',Password='"+PassBox.getText()
            +"',UserType='"+UserTypeBox.getSelectedItem()+"' WHERE Username='"+UserBox.getSelectedItem()+"';");
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        NameBox.setText(name);
        PassBox.setText(Pass);

View Full Code Here

Examples of niso.DBHandler

    this.parent=parent;
    this.setLayout(null);
    corPass=false;
    corUsrName=false;
    tempUser= new User("","","");
    db = new DBHandler(3306, "nisodb", "root", "p@ssword");
    back =  new Button("images/back.png", "images/back2.png", "images/back2a.png");
    login = new Button("images/l"+n+".png", "images/l"+n+"a.png", "images/l"+n+".png");
    
    try {
      this.bg=ImageIO.read(new File(filename));

View Full Code Here

Examples of niso.DBHandler

    //corUsrName=checkPassword(tempUser.getUserPassword(), users);
    started=true;
    
    if(validateUser(tempUser,users)){
    //if(corPass&&corUsrName){
      DBHandler DBH=new DBHandler(3306, "NisoDB", "root", "p@ssword");
      userFrame UFrame=new userFrame(tempUser, DBH);
      
      System.out.println("type: "+tempUser.getusertype());
      //new UserMain(curFrame, tempUser.getUserName(), users);
      frame.dispose();

View Full Code Here

Examples of org.openqreg.db.DbHandler

   * Creates a DbHandler
   * 
   * @return A new DbHandler
   */
  protected DbHandler createDbHandler() {
    return new DbHandler();
  }

View Full Code Here

Examples of org.openqreg.db.DbHandler

   * Creates a new DbHandler. This method can be overrridden in subclasses.
   * 
   * @return A DbHandler
   */
  protected DbHandler createDbHandler() {
    return new DbHandler();
  }

View Full Code Here

Examples of org.openqreg.db.DbHandler




public class DbHandlerTest {
    public static void main(String[] args) {
    try {
      DbHandler db = new DbHandler();
  
      ResultSet rs = db.executeQuery("select * from language");
      while (rs.next()) {        
        System.out.print(rs.getString(1));
                System.out.println(rs.getString(2));
      }
        }

View Full Code Here

Examples of org.openqreg.db.DbHandler

    JNDIUnitTestHelper.shutdown();
  }


  @Test
  public void testClose() throws Exception {
    DbHandler db = new DbHandler();
    db.close();
    assertFalse(db.isConnected());
  }

View Full Code Here

Examples of org.openqreg.db.DbHandler

    assertFalse(db.isConnected());
  }


  @Test
  public void testGetConnectInfo() {
    DbHandler db = new DbHandler();
    assertEquals("Wrong connectinfo returned", connectInfo, db
        .getConnectInfo());
  }

View Full Code Here

Examples of org.openqreg.db.DbHandler

  }


  @Test
  public void testConnect() {
    try {
      DbHandler db = new DbHandler();
      db.connect(connectInfo);
    } catch (DbHandlerException e) {
      fail(e.getMessage());
    }
  }

View Full Code Here

Examples of org.openqreg.db.DbHandler

  public DiagnoseHolder() {
    populate();
  }
  
  protected DbHandler createDbHandler() {
    return new DbHandler();
  }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.