|
|
Connection con = DriverManager.getConnection("jdbc:odbc:employee");
please tell me that the methode of defining this "jdbc:odbc:employee" string.
As mentioned in getConnnection detail in netbeans the first part jdbc is fix and the second and the third is subProtocol and subName ... so tell me please what are these three things?
I'm accessing MySQL database employee.sql using java servlet ... but i dont know this above mentioned statment mechanism so i m still failed to complete.
I've also read some bloges/etc but cant ound detail that clear my queation.
So plz me.
Also plz tell me that in most of the examples and also in above given statment they defines database in two forms,
"jdbc:mysql:employee"
or
"jdbc:odbc://localhost/employee"
so what are these location on computer or on my local mechine so shere i keep database(employee.sql) to refer them like these two ways.
THANKS TO ALL HELPERS ...
modified on Wednesday, July 14, 2010 12:23 AM
|
|
|
|
|
|
Thanks .. But thing still creates problem to me.
In this program they uses database test which is already exist ... where i dont know ..... but in case i create my own database then where i keep it and how to give database path in statment con = DriverManager.getConnection("jdbc:mysql:///test", "root", "secret");
package com.stardeveloper.example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JdbcExample2 {
public static void main(String args[]) {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql:///test",
"root", "secret");
if(!con.isClosed())
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");
} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
}
}
|
|
|
|
|
I'm trying to set the foreground color for all treeview nodes in css but cannot get it to work. I'm using the following:
{
color:black
}
How can I get this to work?
|
|
|
|
|
I hope you are referencing the objects id, class or tag...
some examples
p{
color:#000;
}
.myclass{
color:#000;
}
#myid{
color:#000;
}
You can also apply the css to all elements like
*{
color:#000;
}
The #000 is shorthand for #000000 and is black.
BTW - You are placing the style tags around your css or referencing it in a link tag?
All the Best!
|
|
|
|
|
I have access database store on the server. One of my user perform data entry from the client machine via the mapped drive.
For the other user I plan to develop web application which access via the HTML page and retrieve data from the database. Is it possible for me to do that? I plan to do that with Visual Studio 2005.
Thank,
|
|
|
|
|
It is not important whether you are using HTML or VS 2005.
Which scripting language you are using is important.
For achieving the task you are trying to do, you need to use
server side scripting language like PHP or ASP.NET or something else
like AJAX.
In short you need to call server side transaction to fetch data from
MS Access database.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
do you know are there any article that I can read and do it?
|
|
|
|
|
|
|
I am trying to accessing SQL database from this given below code ... that i found on net. But there is problem at
Class.forName It shows error at browser ... Error is "Exception: com.mysql.jdbc.Driver". I've also tried one another example roseindia.com ... same error. 
I've also tried another simple example like this from begining to class.form but again same error.
package DatabaseExample;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class DatabaseExample extends HttpServlet {
@Override
public void doGet(HttpServletRequest hsReq, HttpServletResponse hsRes) throws ServletException, IOException {
hsRes.setContentType("text/html");
PrintWriter objPrintWriter = hsRes.getWriter();
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql:///test","root", "secret");
if(!con.isClosed())
objPrintWriter.println("Successfully connected to " + "MySQL server using TCP/IP...");
} catch(Exception e) {
objPrintWriter.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
}
}
modified on Monday, July 12, 2010 8:45 AM
|
|
|
|
|
khurram_shahzad wrote: Error is "Exception: com.mysql.jdbc.Driver".
Is there nothing more in the exception message?
Also the line
Class.forName("com.mysql.jdbc.Driver").newInstance();
makes no sense as you do not save the object created by newInstance().
It's time for a new signature.
|
|
|
|
|
No its just this little exception ("Exception: com.mysql.jdbc.Driver") message only .... i think class may not found ...but i dodnt know why .. because in other example i include class library (import java.sql.DriverManager) but here's again same excaption message.
I'vs this example also,
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class getDataServlet extends HttpServlet {
@Override
public void doGet(HttpServletRequest hsReq, HttpServletResponse hsRes) throws ServletException, IOException {
hsRes.setContentType("text/html");
PrintWriter objPrintWriter = hsRes.getWriter();
String conURL = "jdbc:H:\\employee";
Connection connection=null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception e){
objPrintWriter.println(e);
}
}
}
in this program it will show this message little change but seems.
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
|
|
|
|
|
khurram_shahzad wrote: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Well that seems quite clear, the class cannot be found in your system. You may need to add some extra jar files to your project.
It's time for a new signature.
|
|
|
|
|
I have the following HTML:
<body>
<div id="container">
<div id="top">
<h1>Header</h1>
</div>
<div id="leftnav">
<p>Left bar</p>
</div>
<div id="rightnav">
<p>Right bar</p>
</div>
<div id="content">
<p>Content</p>
</div>
<div id="footer">
<h4>Footer</h4>
</div>
</div>
</body>
and this CSS:
body
{
font-family: Verdana, Sans-Serif;
font-size:0.75em;
line-height:1.5em;
margin:1.5em;
}
#container
{
overflow:hidden;
min-width: 50em;
margin: 0.625em auto;
background-color: #fff;
color: #333;
border: 1px solid gray;
}
#top
{
padding: 0.5em;
background-color: #ddd;
border-bottom: 1px solid gray;
}
#top h1
{
padding: 0;
margin: 0;
}
#leftnav
{
float: left;
width: 10em;
margin: 0;
padding: 1em;
background-color:#ec7;
}
#rightnav
{
float: right;
width: 10em;
margin: 0;
padding: 1em;
background-color:#db6;
}
#content
{
margin-left: 10em;
margin-right: 10em;
padding-left:3em;
padding-right:3em;
padding-top:1em;
min-width:10em;
text-align:justify;
background-color:#bab;
}
#leftnav, #rightnav, #content
{
padding-bottom:1000em;
margin-bottom:-1000em;
}
#footer
{
clear: both;
margin: 0;
padding: 0.5em;
color: #333;
background-color: #ddd;
border-top: 1px solid gray;
}
The three DIVs (leftnav, content, rightnav) should be displayed as columns between top and footer DIVs. I managed this, but the 'columns' are not the same height when displayed (ie. the background color only extends as far as the text). This appears to be a common problem and I have found several workarounds. I have attempted to implement this one[^] but only the 'content' column extends properly. leftnav and rightnav background extends over the footer DIV covering its background (although the text 'Footer' is still visible). I would like all three columns to extend only as far as the footer.
Here is the picture.[^]
The bearing of a child takes nine months, no matter
how many women are assigned.
|
|
|
|
|
ha ha welcome to the weird and wonderful world of CSS.... there are entire websites devoted to this very topic, books even, and I wouldn't be surprised if there was a goddam TV series as well.
Can't be done, is the simple answer. The slightly longer one is that it can, but the hacks required will be too browser-specific to make it usable in the real world.
If you can get away with fixed-width columns you can force an answer using a background image. Otherwise, my serious advice (which will save you hours if not days of stress and frustration) is to use a table-based layout. Problem solved in two minutes. (And if anyone tries to tell you you can't use tables for web-page layout, just look pityingly at them, smile knowingly and walk away...)
|
|
|
|
|
Thank you for the answer. I realize that this is possible to achieve using tables (although I haven't tried it).
The bearing of a child takes nine months, no matter
how many women are assigned.
|
|
|
|
|
Actually, what I did wrong was putting the header and footer DIVs into the container DIV along with the three columns. When I put them out the layout works better:
<body>
<div id="top">
<h1>Header</h1>
</div>
<div id="container">
<div id="leftnav">
<p>Left bar</p>
</div>
<div id="rightnav">
<p>Right bar</p>
</div>
<div id="content">
<p>Content</p>
</div>
</div>
<div id="footer">
<h4>Footer</h4>
</div>
</body>
The bearing of a child takes nine months, no matter
how many women are assigned.
|
|
|
|
|
Nice enough in Firefox and Chrome - you might want to look at it in IE though...
|
|
|
|
|
It looks like this[^] in IE 8. Do you mean it doesn't display in earlier IE versions or I am missing something? (Or something else - I am very new at this.)
The bearing of a child takes nine months, no matter
how many women are assigned.
|
|
|
|
|
hmm.. here[^] it is my IE8... go figure...
|
|
|
|
|
Now I'm really confused. Why are we getting two different pages?
The bearing of a child takes nine months, no matter
how many women are assigned.
|
|
|
|
|
(Been distracted by World Cup final...)
Well, such are the joys of CSS. Come back tables, all is forgiven....
|
|
|
|
|
Never mind, I think I figured it out - off to learn about quirks mode.[^]. This is getting quite interesting.
The bearing of a child takes nine months, no matter
how many women are assigned.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
