Java连接数据库实例【转载】
1、Oracle8/8i/9i数据库（thin模式）
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//orcl为数据库的SID
String user="test";
String password="test";
Connection conn= DriverManager.getConnection(url,user,password);
2、DB2数据库
Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
String url="jdbc:db2://localhost:5000/sample";
//sample为你的数据库名
String user="admin";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
3、Sql Server7.0/2000数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
4、Sybase数据库
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
String url =" jdbc:sybase:Tds:localhost:5007/myDB";
//myDB为你的数据库名
Properties sysProps = System.getProperties();
SysProps.put("user","userid");
SysProps.put("password","user_password");
Connection conn= DriverManager.getConnection(url, SysProps);
5、Informix数据库
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
String url =
"jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;
user=testuser;password=testpassword";
//myDB为数据库名
Connection conn= DriverManager.getConnection(url);
6、MySQL数据库
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
//myDB为数据库名
Connection conn= DriverManager.getConnection(url);
7、PostgreSQL数据库
Class.forName("org.postgresql.Driver").newInstance();
String url ="jdbc:postgresql://localhost/myDB"
//myDB为数据库名
String user="myuser";
String password="mypassword";
Connection conn= DriverManager.getConnection(url,user,password);
实例如下：
1.与access <%@page contentType = "text/html;charset=GB2312" import = "java.sql
.*"%>
<%@page import = "java.util.*,java.text.*"%>
<html>
<title>取出并显示表中的信息</title>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:webdata");
Statement smt = con.createStatement();
String sql;
sql = "select bh,shrxx,shrdh,shrdz,hwjs,bzxs,yf,bjd from hy";
ResultSet rs = smt.executeQuery(sql);
out.println("取出表中的的所有信息");
%>
请点击这里</font><a href="javascript:history.back(1)"><b><font color="#FF0000"
>返回</font></b></a><hr>
<%
out.println("<table border = '1'>");
out.println("<tr bgcolor = 'yellow'><th>货单号</th><th>收货人姓名</th><th>收货
人电话</th><th>收货人住址</th><th>货件数量</th><th>包装形式</th><th>运费</th><
th>报价单</th></tr>");
while(rs.next())
out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</
td><td>" + rs.getString(3) + "</td><td>" + rs.getString(4) + "</td><td>" + rs.
getString(5) + "</td><td>" + rs.getString(6) + "</td><td>" + rs.getString(7) +
"</td><td>" + rs.getString(8) + "</td></tr>" );
con.close();
%>
<html>
<body>
</table>
</body>
</html>
2.与mysql
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://192.168.0.1:3306/test?user=root&password=123";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.
CONCUR_UPDATABLE);
String sql="select * from huahe_article";
ResultSet rs=stmt.executeQuery(sql); %>
<table><tr><td>您的第一个字段内容为：</td>
<td>您的第二个字段内容为：</td></tr>
<%
while(rs.next()) {%>
<tr><td>
<%=rs.getString(1)%> </td><td>
<%=rs.getString(2)%> </td></tr>
<%}%>
</table>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
3.与mssql
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%!
public static String getGBString(String src) {
try {
return new String(src.getBytes("ISO-8859-1"), "gb2312");
} catch (java.io.UnsupportedEncodingException e) {
return null;
}
}
%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=test";
//test你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.
CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=getGBString(rs.getString(1))%> <br>
您的第二个字段内容为：<%=getGBString(rs.getString(2))%> <br>
<%}%>
<%out.print("数据库操作成功，恭喜你");%> <br>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
