connectmysql.html
来自「java类库详细讲解」· HTML 代码 · 共 218 行
HTML
218 行
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Connecting to a MySQL Database
(Java Developers Almanac Example)
</TITLE>
<META CONTENT="Patrick Chan" NAME="AUTHOR">
<META CONTENT="Code Examples from The Java Developers Almanac 1.4" NAME="DESCRIPTION">
<META CONTENT="Addison-Wesley/Patrick Chan" NAME="OWNER">
<META CONTENT="3/20/02" NAME="revision">
<STYLE TYPE="text/css">
<!-- BODY CODE {font-family: Courier, Monospace; font-size: 11pt} TABLE, BODY {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt} PRE {font-family: Courier, Monospace; font-size: 10pt} H3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11pt} A.eglink {text-decoration: none} A:hover.eglink {text-decoration: underline} -->
</STYLE>
</HEAD>
<BODY>
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0">
<TR>
<TD rowspan="3"><A HREF="/?l=ex"><IMG BORDER="0" ALIGN="BOTTOM" HSPACE="10" SRC="/egs/almanac14a.jpg"></A></TD><TD VALIGN="top"><font face="Times" size="6"><b>The Java Developers Almanac 1.4</b></font>
<br>
Order this book from <a href="/cgi-bin/scripts/redirect.pl?l=ex&url=http://www.amazon.com/exec/obidos/ASIN/0201752808/xeo">Amazon</a>.
</TD>
</TR>
<TR>
<TD align="right" valign="bottom">
<FORM method="get" action="/cgi-bin/search/find.pl">
<INPUT size="25" name="words" type="text"><INPUT value="Search" type="submit">
</FORM>
</TD>
</TR>
</TABLE>
<HR color="#6666cc">
<DIV ALIGN="LEFT">
<A HREF="/">Home</A>
>
<A HREF="../index.html">List of Packages</A>
>
<B><A HREF="../java.sql/pkg.html">java.sql</A></B><font color="#666666" SIZE="-2">
[73 examples]
</font>
>
<B><A HREF="../java.sql/pkg.html#Connections">Connections</A></B><font color="#666666" SIZE="-2">
[10 examples]
</font>
</DIV><P>
<h3>
e236.
Connecting to a MySQL Database</h3>
This example connects to a MySQL database using the MM JDBC driver for
MySQL. You need to have an account in MySQL database to run this
example. To create an account, you can connect to MySQL database on
your platform as root, and run the following command:
<pre>
mysql> GRANT ALL PRIVILEGES ON *.* TO <font color="#0066ff"><i>username@localhost</i></font>
IDENTIFIED BY <font color="#0066ff"><i>'password'</i></font> WITH GRANT OPTION;
</pre>
<pre>
Connection connection = null;
try {
// Load the JDBC driver
String driverName = "org.gjt.mm.mysql.Driver"; // MySQL MM JDBC driver
Class.forName(driverName);
// Create a connection to the database
String serverName = <font color="#0066ff"><i>"localhost"</i></font>;
String mydatabase = <font color="#0066ff"><i>"mydatabase"</i></font>;
String url = "jdbc:mysql://" + serverName + "/" + mydatabase; // a JDBC url
String username = <font color="#0066ff"><i>"username"</i></font>;
String password = <font color="#0066ff"><i>"password"</i></font>;
connection = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
// Could not find the database driver
} catch (SQLException e) {
// Could not connect to the database
}
</pre>
<P><table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td bgcolor="#6666cc" align="center"><font color="#ffffff">
Related Examples
</font></td>
</tr>
</table>
e235. <a class="eglink" href="ConnectOracle.html?l=rel">
Connecting to an Oracle Database
</a>
<br>
e237. <a class="eglink" href="ConnectSqlServer.html?l=rel">
Connecting to a SQLServer Database
</a>
<br>
e238. <a class="eglink" href="GetPropInfo.html?l=rel">
Listing All Available Parameters for Creating a JDBC Connection
</a>
<br>
e239. <a class="eglink" href="CanTrans.html?l=rel">
Determining If a Database Supports Transactions
</a>
<br>
e240. <a class="eglink" href="Commit.html?l=rel">
Committing and Rolling Back Updates to a Database
</a>
<br>
e241. <a class="eglink" href="GetSqlException.html?l=rel">
Handling a SQL Exception
</a>
<br>
e242. <a class="eglink" href="GetSqlWarnings.html?l=rel">
Determining If a SQL Warning Occurred
</a>
<br>
e243. <a class="eglink" href="Conn2Driver.html?l=rel">
Getting the Driver of a Connection
</a>
<br>
e244. <a class="eglink" href="GetFetchSize.html?l=rel">
Setting the Number of Rows to Prefetch When Executing a SQL Query
</a>
<br>
<table width="600" CELLSPACING="0" CELLPADDING="2" BORDER="0">
<tr>
<td align="left">
<br>
See also:
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Batching">
Batching
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Database%20Meta%20Data">
Database Meta Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Deleting%20Data">
Deleting Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Drivers">
Drivers
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Importing%20and%20Exporting">
Importing and Exporting
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Inserting%20and%20Updating%20Data">
Inserting and Updating Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20OBJECTs">
Oracle OBJECTs
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Oracle%20VARRAYs">
Oracle VARRAYs
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Procedures%20and%20Functions">
Procedures and Functions
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Retrieving%20Data">
Retrieving Data
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Scrollable%20Result%20Sets">
Scrollable Result Sets
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Tables">
Tables
</a>
<a class="eglink" href="/egs/java.sql/pkg.html?l=rel#Updatable%20Result%20Sets">
Updatable Result Sets
</a>
</td>
</tr>
</table>
<br>
<br>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="0">
© 2002 Addison-Wesley.
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?