jdbc

Home Answers Viewqa JDBC jdbc

vamsi krishna

jdbc
1 Answer(s) 4 months and 14 days ago
Posted in : JDBC

if i create one table that consist of usename ,joiningdate for joining date i have used varchar datatype not date . then we store date into database table as a string by using java .then what are the drawbacks.

View Answers

January 29, 2013 at 6:38 PM

There are various drawbacks of using data type VARCHAR instead of DATE for a date.

Addition/Subtraction of days will not be easy with varchar
Retrieving/Extracting of month or year is not easy.
Sorting of date will not be an easy task.
VARCHAR takes more storage space than DATE.
Due to the taking more storage space by VARCHAR it is not recommended to use VARCHAR instead of DATE for the commercial environments because it will take more time to display the results (This difference is not shown in small amounts of data).

JDBC
JDBC why we use batch in jdbc

jdbc
jdbc display the records using index in jdbc

jdbc
jdbc Hai , Give a steps for jdbc connectivity

JDBC
JDBC How to add set of queries in a single query in JDBC

jdbc
jdbc please tell me sir.i dont know JDBC connection and how to create table in database

jdbc
jdbc how to write program to save data and retrieve data from the form in Java

jdbc
jdbc why do we need to load jdbc drivers before connecting to database

JDBC
JDBC how to set classpath for eclipse, java, where to copy jdbc connector

JDBC
JDBC in class.forname which driver name we are writing for the connection from jdbc to sqlserver 2008

jdbc
jdbc is it possible to use doget & dopost method with jdbc to call in a servlet programe

Jdbc
Jdbc A java program with jdbc connectivity with insert,delete,update options for name,regno,mark1,mark2,total

jdbc
jdbc define batch updates define batch updates?exp JDBC... links: http://www.roseindia.net/jdbc/Jdbc-batch-update.shtml http://www.roseindia.net/tutorial/java/jdbc/batchupdateresultsetexample.html

JDBC
JDBC save a data in the database I need a code to save a data... between java and mysql using JDBC and saves the data into the database. import... con = null; String url = "jdbc:mysql://localhost:3306/"; String db

JDBC
JDBC code to save a data in the database I need a code to save... the connection between java and mysql using JDBC and saves the data into the database...!"); Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String db

jdbc
how can we call stored procedure using jdbc how can we call stored procedure using jdbc Call a Stored Procedure using...(); For more information, visit the following link: JDBC call Stored Procedure

jdbc
how can we set transaction level through jdbc api how can we set transaction level through jdbc api Use Connection.setTransactionIsolation(int) to set the desired tansaction level, which takes one of the 5 arguments

jdbc
jdbc hey sir i just wanna have some ppt on jdbc coz have my exams next week and i have not attended any classes coz of job... I m studyng frm niit

jdbc
jdbc I can't run my jdbc program because it has error in this line: public static void main(String[] args) the error is:illegal static declaration in inner class would you please let me whats the problem? regards

jdbc
using jdbc connection import java.sql.*; public class CreateTable... = DriverManager.getConnection("jdbc:odbc:student"); Class.forName

jdbc
jdbc i had written jdbc connection in method and i need to get connection in another class? import java.sql.*; class... driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/test

jdbc
(); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost... information, visit the following link: JDBC Tutorials

jdbc
jdbc how to update int values of ms-access in jdbc program? In MS Access database, use Number data type for int values. import... =DriverManager.getConnection("jdbc:odbc:access","",""); Statement st=null; st

jdbc - JDBC
Why JDBC JDBC used for what

JDBC - JDBC
JDBC - limitations of jdbc What are the limitations of JDBC

JDBC
retrieve the value from database into dropdown list using JDBC SQL 2005 How to retrieve the value from database into dropdown list using JDBC &...").newInstance(); String connectionURL = "jdbc:mysql://localhost:3306/test";; Connection

JDBC
JDBC write a JDBC program to display the result of any query on a student table in a JTable component. import java.awt....").newInstance(); Connection con = DriverManager.getConnection("jdbc:mysql://localhost

jdbc
the Connection.setTransactionIsolation(int level) method isolation level can be set in JDBC. the method can

jdbc
define transactions define transactions Whenever a connection is created by using the JDBC, then by default it is in auto- commit mode. This means that SQL statement will be automatically committed immediately after

jdbc
logical group of data with a number of columns. JDBC ResultSet Example Stored

jdbc
level can be set in JDBC. the method can accept any of the arguments listed below

jdbc
{ Connection con; con=DriverManager.getConnection("jdbc:odbc:student

JDBC
= DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root

jdbc
what are different type of locks what are different type of locks Types of locks in JDBC: Row and Key Locks:: It is useful when updating the rows (update, insert or delete operations), as they increase concurrency

jdbc
("jdbc:odbc:student"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver

jdbc
= DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root

JDBC
("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql

jdbc - JDBC
Java JDBC application Database Application in Java JDBC

JDBC - JDBC
JDBC Select Count Example Need an example of count in JDBC

JDBC - JDBC
JDBC -statement types in jdbc statement types in jdbc

jdbc - JDBC
Loading JDBC driver at runtime How to load JDBC Driver at runtime

jdbc

JDBC

jdbc

JDBC

Jdbc

jdbc

JDBC

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics