下面的是幾種常見數據庫系統的數據庫連接方式
系統環境:win2003 + j2se5.0 + tomcat5.5.7
前提是你已經從網上已經下載了各個數據庫的JDBC支持！
把那些主要的工具包都放到Tomcat 5.5\common\lib就行！
刨除那些入門的東西吧，現在開始步入正題！
為了減少篇幅，更為了把問題說的直觀，我已經把異常捕捉代碼給去除了！
1.Microsoft SQL Server 2000
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn= DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=數據庫名字","sa","pwd");
Statement stmt=conn.createStatement();
//增加和查詢語句
stmt.executeUpdate("insert into boya values('mssql','2000')");
ResultSet rs=statement.executeQuery("select * from boya");
//顯示記錄
while(rs.next()){
out.print(rs.getString(1)+" "+rs.getString(2));
out.println("<br>");
}
2.MySQL 5.0
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection
("jdbc:mysql://localhost/數據庫名字?user=root&password=pwd");
Statement stmt=conn.createStatement();
//增加和查詢語句
stmt.executeUpdate("insert into boya values('mysql','5.0')");
ResultSet rs=stmt.executeQuery("select * from boya");
//顯示記錄
while(rs.next()){
out.print(rs.getString(1)+" "+rs.getString(2));
out.println("<br>");
}
3.PostgreSQL 8.0
//這個服務器的默認端口5432，如果更改了，代碼也需要更改
Class.forName("org.postgresql.Driver");
Connection conn=DriverManager.getConnection
("jdbc:postgresql://localhost:5432/數據庫名字?user=admin&&password=pwd");
Statement stmt=conn.createStatement();
//增加和查詢語句
stmt.executeUpdate("insert into boya values('mysql','5.0')");
ResultSet rs=stmt.executeQuery("select * from boya");
//顯示記錄
while(rs.next()){
out.print(rs.getString(1)+" "+rs.getString(2));
out.println("<br>");
}
4.ODBC
//in my opinion 會寫ODBC就夠了，現在PostgreSQL、MYSQL里也都有ODBC支持,但速度慢啊!
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:test","","");
Statement stmt=conn.createStatement();
//增加和查詢語句
stmt.executeUpdate("insert into boya values('mysql','5.0')");
ResultSet rs=stmt.executeQuery("select * from boya");
//顯示記錄
while(rs.next()){
out.print(rs.getString(1)+" "+rs.getString(2));
out.println("<br>");
}