//Microsoft Access (ODBC)
packagecom.jdm.Access;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importcom.jdm.dmdatabase.DMsource;
publicclassAccess {
privateConnection con;
privateString driverclass;
privateStatement statement;
privateString url;
privateResultSet result;
privateString username;
privateString password;
publicAccess() {
init();
try{
Class.forName(driverclass);
con = DriverManager.getConnection(url, username, password);
if(con !=null) {
statement = con.createStatement();
inta=statement.executeUpdate("insert into user(username,password) values('mike','tome')");
result = statement.executeQuery("select * from user");
while(result.next())
System.out.println("user: "+ result.getString(1)
+"password: "+ result.getString(2));
System.out.print("/n");
}
result.close();
statement.close();
con.close();
}catch(ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}
}
publicvoidinit() {
driverclass ="sun.jdbc.odbc.JdbcOdbcDriver";
url ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E://java//test.mdb";
username ="";
password ="";
}
publicstaticvoidmain(String args[]) {
newAccess();
}
}
///
/Microsoft SqlServer2000(需要装sp3补丁,并开放端口)
//
packagecom.jdm.sqlserver;
importjava.sql.CallableStatement;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassSqlLink {
privateConnection con;
privateStatement stm;
privateResultSet resultset;
privateString driverclass =null;
privateString url =null;
privateString username =null;
privateString password =null;
publicSqlLink() {
driverclass ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=cjgl";
username ="sa";
password ="123456";
init();
if(con !=null) {
try{
con.close();
if(con.isClosed())
System.out.println("连接成功"+"数据源已释放");
else
System.out.println("连接成功"+"数据源未释放");
}catch(SQLException e1) {
e1.printStackTrace();
}
}else{
System.out.println("连接失败");
}
}
publicvoidinit() {
try{
Class.forName(driverclass);
con = DriverManager.getConnection(url, username, password);
stm = con.createStatement();
/*CallableStatement call=con.prepareCall("{ call ADDXS (?,?,?,?,?,?,?) }");
call.setString(1,"001118");
call.setString(2,"王珊珊");
call.setString(3,"女");
call.setString(4,"通信工程");
call.setString(5,"1988-03-21");
call.setInt(6,40);
call.setString(7, "良");
call.execute();*/
resultset = stm.executeQuery("select * from XS where xb='女'");
while(resultset.next()) {
System.out
.println(resultset.getString(1) +" "
+ resultset.getString(2) +" "
+ resultset.getString(3) +" "
+ resultset.getString(4) +" "
+ resultset.getString(5) +" "
+ resultset.getString(6));
}
}catch(ClassNotFoundException e) {
e.printStackTrace();
System.out.println("驱动类没有找到");
}catch(SQLException e) {
e.printStackTrace();
}
}
publicstaticvoidmain(String[] args) {
newSqlLink();
}
}
///
//sun MySql
packagecom.jdm.mysql;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassMySql {
privateString driverclass;
privateString url;
privateString username;
privateString password;
privateConnection con;
privateStatement stm;
privateResultSet result;
publicMySql() {
init();
try{
Class.forName(driverclass);
con = DriverManager.getConnection(url, username, password);
stm = con.createStatement();
result = stm.executeQuery("SELECT * FROM userinfo");
while(result.next()) {
System.out.println("用户名: "+result.getString(1) +"密码: "
+ result.getString(2) +"角色: "+ result.getString(3) +"日期: "
+ result.getString(4)+"性别: "+result.getString(4));
}
con.close();
}catch(ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}
}
publicvoidinit() {
driverclass ="com.mysql.jdbc.Driver";
url ="jdbc:mysql://localhost:3306/test";
username ="root";
password ="123456";
}
publicstaticvoidmain(String[] args) {
newMySql();
}
}
///
//华工达梦数据库DM
packagecom.jdm.dmdatabase;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassDMsource {
privateConnection con;
privateString driverclass;
privateStatement statement;
privateString url;
privateResultSet result;
privateString username;
privateString password;
publicDMsource() {
init();
try{
Class.forName(driverclass);
con = DriverManager.getConnection(url, username, password);
if(con !=null) {
System.out.println("连接成功"+ con.toString());
con.close();
}
}catch(ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}
}
publicvoidinit() {
driverclass ="dm.jdbc.driver.DmDriver";
url ="jdbc:dm://localhost:12345/mdj";
username ="mdj";
password ="123456";
}
publicstaticvoidmain(String args[]) {
newDMsource();
}
}
///
//ORACLE DATABASE
//
packagecom.jdm.Oracle;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importcom.jdm.mysql.MySql;
publicclassOracle {
privateString driverclass;
privateString url;
privateString username;
privateString password;
privateConnection con;
privateStatement stm;
privateResultSet result;
publicOracle() {
init();
try{
Class.forName(driverclass);
con = DriverManager.getConnection(url, username, password);
stm = con.createStatement();
result = stm.executeQuery("SELECT * FROM HELP");
while(result.next()) {
System.out.println(result.getString(1)+" "+result.getString(2)+" "+result.getString(3));
}
if(con!=null)System.out.println("连接成功");
con.close();
}catch(ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}
}
publicvoidinit() {
driverclass ="oracle.jdbc.driver.OracleDriver";
url ="jdbc:oracle:thin:@localhost:1521:XE";
//url="jdbc:oracle:thin:@computername:host(1521):databasename"
username ="SYSTEM";
password ="123456";
}
publicstaticvoidmain(String[] args) {
newOracle();
}
}