作者H45 (!H45)
看板java
标题Re: JDBC
时间Thu Dec 21 01:13:07 2006
※ 引述《kaets (哇哈哈)》之铭言：
: 我已经安装好MYSQL
: 我下载了这个JDBC的DRIVER: mysql-connector-java-3.0.17-ga.zip
: 接下来要怎麽安装它才能够跟MYSQL做连接?
: 我的作业系统是WINDOWS
: 请大大指导一下或者给一下教学网站
: 谢谢^^
JDBC Introduction:
http://java.sun.com/docs/books/tutorial/jdbc/overview/index.html
JDBC Basics:
http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html
以下是我去年写的小范例
这是用Microsoft Access
如果要改成MySQL，可能要改一下DriverManager那一行参数
import java.io.*;
import java.sql.*;
import java.util.*;
public class Main
{
public static void main( String[] args ) throws SQLException
{
Connection conn = null;
Statement stmt = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(
"jdbc:odbc:DRIVER=Microsoft Access Driver (*.mdb);" +
"DBQ=C:\\Documents and Settings\\!H45\\桌面\\db1.mdb" );
stmt = conn.createStatement();
String SQL = "insert into data" + " " +
"values ('必胜客','3939889')" + " ";
stmt.executeUpdate(SQL);
conn.close();
System.out.println("Successful");
}
catch(Exception e){e.printStackTrace();}
}
}
Note that JDBC 4.0 had changed something:
http://java.sun.com/javase/6/jcp/beta/apidiffs/index-diffs.html
也许没能帮上忙...待其他板友补强了...
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.115.205.85