regarding jdbc

regarding jdbc

View Answers

October 11, 2008 at 4:45 PM

Hi friend,


Please give the full source code and details having the error to solve the Problem.

Thanks



October 11, 2008 at 5:07 PM

use this code for connection in ur program

Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdatabase";, "your username", "your password");
}
catch (Exception e) {
e.printStackTrace();
}


this code for getting connection only.
After getting connection we use "con" for ur next processing.

like
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(your query);

while(rs.next){
// do ur stuff like
rs.getString("name");
}

these thing happens insdie try block


Rajanikant









Related Tutorials/Questions & Answers:
regarding jdbc - JDBC
regarding jdbc  is there any way in jdbc to retieve data from a table and show it by using swing concept i mean to say data from the table can be shown in swing interface with tabular form
Query regarding JSP, JDBC
Query regarding JSP, JDBC  can I get the code for the question asked by me regarding JSP,JDBC
Advertisements
regarding jdbc - JDBC
regarding jdbc  i am using this program /* import java.sql....").newInstance(); con = DriverManager.getConnection("jdbc:mysql:///test... friend, We check the your code it works properly but check the JDBC Connection
regarding jdbc - JDBC
regarding jdbc  how i can configure java with ms access
regarding jdbc - JDBC
regarding jdbc  how to connect mysql with java example you have provided is having some error and i am not able to remove that error please... = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdatabase", "your username", "your
regarding java - JDBC
regarding java  i am making a project on supply chain system i have... will be directly saved in the database i have seen many examples regarding... give some give some examples regarding this please help me regarding
regarding JTable - JDBC
regarding JTable  how to populate a JTable with mysql data after clicking JButton please explain with the example
regarding mini project - JDBC
regarding mini project  i need to make a mini project using servlet and jdbc.pls help me with a real time application
Query regarding JSP, JDBC
Query regarding JSP, JDBC  I have a table in SQL Server database storing some ids and names. In my jsp code a while loop is displaying the list of names from the database as links. I want that on click of a link of name furthur
regarding connectivity program only - JDBC
regarding connectivity program only  can u give me code regarding... = "jdbc:mysql://192.168.10.211:3306/"; String db = "amar"; String driver... for more information. http://www.roseindia.net/jdbc
jdbc warning regarding to ms access
jdbc warning regarding to ms access  shows warning msg while...=DriverManager.getConnection("jdbc:odbc:accdsn","",""); try{ Statement stmt..."); But since this is proprietary API you go for the Type 4 JDBC driver. You
regarding connectivity program only - JDBC
regarding connectivity program only  can u give me code regarding .. that i had created student data base with his name and subject marks resp ... i use html in front end ...that there r options like 1.name---------- 2.sub1
regarding ms acces database and servlet - JDBC
regarding ms acces database and servlet  hello there, i am trying to do a web application that makes use of a data base. I opted for ms access...("sun.jdbc.odbc.JdbcOdbcDriver"); connection = DriverManager.getConnection("jdbc:odbc
Regarding Hibernate
Regarding Hibernate  Both JDBC and Hibernate are used to connect to database then whats the need of going to hibernate? What are the main differences? And could you let me know please
regarding rev
regarding rev  write a prog. in java that display all the arguments passed at the command line in reverse order
Regarding repository
Regarding repository  How to check in and check out using SVN repository using eclipse
Regarding Project
Regarding Project  sir, i am doing a project in java. my project is CITY GUIDE it is an web application. please give me documentation of my project
Regarding Project
Regarding Project  sir, i am doing a project in java. my project is CITY GUIDE it is an web application. please give me documentation of my project
Regarding javascript
Regarding javascript  Hi, I want 4 upload buttons in HTML CODE and Among 4 browse buttons user is not selected any one then provide a prompt message like plz select any 1 file among 4 buttons.If user is selected either 1st
Regarding Datasource
Regarding Datasource  Hi friend, Good morning,how r u,i want to share 1 information to u,I got a job in VERIZON DATA SERVICES INDIA PVT.LTD,u help a lot when i am in academic project,with that project only i got a job
regarding jtable...
regarding jtable...  sir, im working with jtables. i wanted to populate a jtable from the database and when i click any row it should add a container below that row itself and show the required details of the row
regarding project
regarding project  OBJECTIVES OF THIS PROJECT: -Ability to test the programmer for basic interaction skills to understand the client requirement. -Ability of the programmer to ask the right questions and get the relevant
regarding project
regarding project  OBJECTIVES OF THIS PROJECT: -Ability to test the programmer for basic interaction skills to understand the client requirement. -Ability of the programmer to ask the right questions and get
regarding project
regarding project   sir we need help about project. we have idea about his project please guide me sir. OBJECTIVES OF THIS PROJECT: -Ability to test the programmer for basic interaction skills to understand the client
regarding java package - Java Beginners
regarding java package  can you provide tutorial for java.sql package please help  Hi friend, I am sending you a link. This link.../jdbc/ Thanks
Regarding project - Applet
Regarding project  hi friend , iam doing project in Visual cryptography in Java so i need the Help regarding how to make a share of a original imahe into shares anu
Regarding weblogic portal
Regarding weblogic portal  Hi, My name is Ramanuja.i am working on weblogic portal.if u know any info regarding plz provide the materials or information to me.plz help me. Thanks in advance
regarding tags - Struts
regarding tags  What is the difference between html:submit and nested:submit and usage of tags based on the situation
regarding struts 2
regarding struts 2   is it not possible to get values from applicationresources.properties into our application in struts 2
Regarding GUI Applications
Regarding GUI Applications  How to create a save and open jmenu item in java desktop application
Regarding core java
Regarding core java  how do we find reverse of string with out using String functions
regarding j2me - Java Beginners
regarding j2me  sir but i have to use the drawString u tell me how can i display two too long strings
Regarding Scroll Bar - CVS
Regarding Scroll Bar  HI all, i have a Text Message box which i have incorporated in my code which goes something like
Regarding Documentation of Packages
Regarding Documentation of Packages  Hello How to get java packages ie documentation of classes ,Interfaces and methods from windows command prompt.In the sense Java.lang,java.awt,java.math etc
Query regarding hashmap
Query regarding hashmap  I want to store some names and ids in hashmap in session, then retrieve it on next page and iterate through ids to run a query using ids one at a time
Regarding junit testcases
Regarding junit testcases  Can Any one help me ..How to write junit testcase for Email (plz dont give links ...i want code
doubt regarding JSF
doubt regarding JSF  Hi, pls explain what is difference between struts &JSF? pls explain what is difference between SPRING &JSF
regarding webservice - WebSevices
regarding webservice  hi, I want to implement Webservices, How i have to use? pls reply me.   Hi Mention your requirement properly.Exactly what you wanna do
Regarding frames in HTML
Regarding frames in HTML  I have created a html page including two frames in it,one frame consists "search bar" and the other frame consists login... regarding this...thanks
Regarding tiles - Struts
Regarding tiles  I am taken image from Database.So, i am already... the session, its also shown. And I am also created one tiles for calling that image in the JSP, and insert the tiles in the respective papes, In which I want
regarding web.xml - JSP-Servlet
regarding web.xml  I am the java beginner, please send the web.xml code and how to run a servlet for apache5.0.... my problem is in tomcat manager am getting the message 'fail' in web.xml  Hello,Please check the tomcat
Doubt Regarding Charts
Doubt Regarding Charts  Hi, Can you please help me out by answering "hoe to include charts in core java code and struts code" thanks in advance, Swaroop Eswara   Please visit the following link: Jfreechart
Regarding Regular Expressions
Regarding Regular Expressions  Hi I would like to supply my regular expression with a 'default' value, so if the thing I was looking for is not found, it will return the default value as i have mentioned in the Regular
want help regarding a project
want help regarding a project  hiii this is hemangi and I want guidance that I am working on a project of hospital management system so I want guidance that how can i implement that in swings or with other frame work? and any
query regarding multiple select
query regarding multiple select  i have a select in jsp with multiple options.When i select multiple values i am not able to insert it into database and how do i retrieve them..please help me with an example code
JDBC
JDBC  why we use batch in jdbc
jdbc
jdbc  Hai , Give a steps for jdbc connectivity
jdbc
jdbc  display the records using index in jdbc
regarding J2ME - Java3D
regarding J2ME  I have a problem. I have to write a 200line text in J2ME,for that i am using drawString(),but de problem... use textarea control ,in j2me has various controls textfield,combobox..etc so   hi use
regarding JSP - JSP-Servlet
regarding JSP  Hi, This is Malleswari from Satyam. I'm facing a problem while running the JSP tags...like if i want to write or any other, the tag is not supported in my page. In prefix i mentioned "c". still i didnt get

Ads