DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone >

Inserting Data Into SQLite Table

Jonnie Spratley user avatar by
Jonnie Spratley
·
Sep. 21, 08 · · Code Snippet
Like (0)
Save
Tweet
3.52K Views

Join the DZone community and get the full member experience.

Join For Free
For inserting into a SQLite table, use the code as follows:



//DB Connection
private var dbconn:SQLConnection;
//Query Statement
private var sqlQuery:SQLStatement;		
//Create Table Statement
private var sqlCreateTable:SQLStatement;
//Insert Statement
private var sqlInsert:SQLStatement;
//Import Statement
private var sqlImport:SQLStatement;

/**
 * Saves a post to the database by user and post
 * @param post The post to save
 * @param user The current user
 */			 
public function savePost( post:Post, user:User ):void
{		
	var query:String = "INSERT INTO posts (" + 
									"post_url," + 
									"post_hash," + 
									"post_desc," + 
									"post_tags," + 
									"post_time," + 
									"post_extended," + 
									"post_shared," + 
									"post_replace," + 
									"post_user)" + 
							"VALUES ( " + 
									":post_url," + 
									":post_hash," + 
									":post_desc," + 
									":post_tags," + 
									":post_time," + 
									":post_extended," + 
									":post_shared," + 
									":post_replace," +												
									":post_user)";

	sqlInsert = new SQLStatement();
	sqlInsert.sqlConnection = dbconn;
	sqlInsert.addEventListener( SQLEvent.RESULT, onSQLSave );
	sqlInsert.addEventListener( SQLErrorEvent.ERROR, onSQLError );				
	
	sqlInsert.text = query;
	sqlInsert.parameters[":post_url"] = post.post_url;
	sqlInsert.parameters[":post_hash"] = post.post_hash;
	sqlInsert.parameters[":post_desc"] = post.post_description;
	sqlInsert.parameters[":post_tags"] = post.post_tag;
	sqlInsert.parameters[":post_time"] = post.post_time;
	sqlInsert.parameters[":post_extended"] = post.post_extended;
	sqlInsert.parameters[":post_shared"] = post.post_shared;
	sqlInsert.parameters[":post_replace"] = post.post_replace;
	sqlInsert.parameters[":post_user"] = user.user_name;

	sqlInsert.execute();	
	
	trace( "Save post query: " + query );						
}

Data (computing) SQLite Database

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • How To Deploy Apache Kafka With Kubernetes
  • Migrating From Heroku To Render
  • Building a Login Screen With React and Bootstrap
  • Upsert in SQL: What Is an Upsert, and When Should You Use One?

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo