1、Oracle8/8i/9i数据库
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String dbURL=" jdbc:oracle:thin:@localhost:1521:orcl";
String name = "sa";//用户名
String pwd = "sa";//密码
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//orcl为数据库名称
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------
2、Sql Server2000数据库 (Jdbc驱动)
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
String name = "sa";//用户名
String pwd = "sa";//密码
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//mydb为数据库名称
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
/*
MS SQL2000连接说明
当一切安装完毕后,安全性----登录----新建登录。设置新登录用户的的默认数据库,权限在点该用户的属性,在服务器角色中选可写可读,数据库访问---选择---要访问的数据库。并在菜单栏里,选择工具----SQL server配置属性----安全性----身份验证选择sql 和 windows。
*/
---------------------------------------------------------------------------
3、Sql Server2000数据库 (Jdbc---Odbc桥)
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String dbURL="jjdbc:odbc:test";
String name = "";//用户名
String pwd = "";//密码
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//test为数据源名称
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------
4、MySQL数据库
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String dbURL="jdbc:mysql://localhost/myDB,user=****;password=****";
//user为用户名
//password为密码
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//myDB为数据库名称
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------
5、Java不要数据源直接连接Access
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+DBpath;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
/*
注意事项:
1.其中的DBpath即是数据库的路径,可以是相对的,也可以是绝对的。
2.尤其要注意url字符串中大括号中的空格一定要有,即Microsoft Access Driver (*.mdb)这里的空格一 定要保留,否则会报错。
3.getConnection()方法中后两个参数是DB的用户名和密码,根据自己的情况设置。
*/
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------
6、用JDBC—ODBC桥连接Access
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String url="jdbc:odbc:test";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//test为数据源名称
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------
6、用JDBC—ODBC桥连接Access
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String url="jdbc:odbc:test";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//test为数据源名称
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------
6、用JDBC—ODBC桥连接VF
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String url="jdbc:odbc:test";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//test为数据原名称 (Microsoft Visual FoxPro Driver)
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------
6、用JDBC—ODBC桥连接Excel
--------------------------------------------------------------------------
private Connection con;
public DataSource_zxp()
{
con=null;
}
public Connection getConnection()
{
String url="jdbc:odbc:test";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection(dbURL,name,pwd);
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
//test为数据原名称 (Microsoft Excel Driver)
}
public void setDatas()
{
try
{
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("");
while(rs.next())
{
System.out.println(rs.getString(""));
}
rs.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
---------------------------------------------------------------------------