Welcome, Guest: Join Nairaland / LOGIN! / Trending / Recent / New
Stats: 2,800,118 members, 6,692,450 topics. Date: Wednesday, 26 January 2022 at 05:26 AM

Java JDBC Database Object Mysql Connection And Manipulation Library By Antware - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Java JDBC Database Object Mysql Connection And Manipulation Library By Antware (1305 Views)

Mail Ant V1.0 - The Email Marketing And Management Tool By Antware Ltd / Help To Link Java Jdbc, Server, Jsp, Servlet / PHP Mysql Connection Using PDO (2) (3) (4)

(1) (Reply)

Java JDBC Database Object Mysql Connection And Manipulation Library By Antware by guruinfinite(m): 11:42pm On Sep 21, 2021
# ant-dbo
Antware Database Connection Object (Ant DBO) build on top of JDBC and MySQL

SPECIFICATION:
Ant DBO is a repo utility project with classes that extends and implement JDBC; java.sql, meant to manipulate MySQL Database.

Can do:
1. It can connect to MySQL Server
2. Creates and manipulates database records
3. Select from database table(s)
4. Deletes database records from database table
5. Easy to use

USAGE:
import system.model.*;

Make use you include the ant-dbo.jar in your classpath or reference libraries if your using eclipses as your Editor.

SAMPLE CODES:

import system.model.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

public class SampleCode {
public static void main(String[] args){
Map<String, String> clause = new HashMap<String, String>();
Map<String, String> clause2 = new HashMap<String, String>();
HashMap<String, String> clause3 = new HashMap<String, String>();
clause.put("column", "zip"wink;
clause.put("operator", "="wink;
clause.put("value", "234"wink;

clause2.put("column", "email"wink;
clause2.put("operator", "="wink;
clause2.put("value", "gettrafficworld@yahoo.com"wink;

clause3.put("col", "name"wink;
clause3.put("sort", "DESC"wink;

Model mod = new Model("users"wink;
mod.where(clause);
mod.inRandomOrder(null);
System.out.println(mod.table);
ResultSet rs = mod.get(null);
// Here we display
try {
rs.next();
System.out.println("Email: "+rs.getString("email"wink);
mod.close(rs);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

DEPENDENCIES:
import java.sql.*;

Download Project from Github @ https://github.com/omasy/ant-dbo

(1) (Reply)

Helo House,how Can I Bundle A Database File Into My Desktop Applicatn / NASA 2015 Space Apps Competition / Help Solve My Android Sdk Manager Challenges

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2022 Oluwaseun Osewa. All rights reserved. See How To Advertise. 28
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.