虽然这些随便在网上suo一下,就有,但是我还是把它收集起来,别人不看,自己总可以看看吧!?
- 【java--MySQL】
-
void goMYSQL() ... {
java.sql.Connection conn = null;
String drv1, url1, user1, psw1;
drv1 = "com.mysql.jdbc.Driver";
url1 = "jdbc:mysql://localhost:3306/FWN?useUnicode=true&characterEncoding=utf8";
user1 = "root";
psw1 = "root";
try ...{
Class.forName(drv1);
conn = DriverManager.getConnection(url1, user1, psw1);
System.out.println("conn="+conn);
} catch (Exception ex) ...{
ex.printStackTrace();
} finally ...{
try ...{
if (conn != null) ...{
conn.close();
}
} catch (Exception ex) ...{
ex.printStackTrace();
}
}
}
- 【java --- SQLServer】
- 【java oracle】
< bean id ="tp_sms_dataSource" class ="org.apache.commons.dbcp.BasicDataSource" destroy-method ="close" >
< property name ="driverClassName" >
< value > oracle.jdbc.driver.OracleDriver </ value >
</ property >
< property name ="url" >
< value > jdbc:oracle:thin:@localhost:1521:LINUX10 </ value >
</ property >
< property name ="username" >
< value > thridparty </ value >
</ property >
< property name ="password" >
< value > thridparty </ value >
</ property >
</ bean >
void goSqlServer() ... {
java.sql.Connection conn = null;
String drv1, url1, user1, psw1;
String drv2, url2, user2, psw2;
drv1 = "com.inet.tds.TdsDriver";
url1 = "jdbc:inetdae7:localhost:1433?database=jsp";
user1 = "jsp1";
psw1 = "1234567890";
try ...{
Class.forName(drv1);
conn = DriverManager.getConnection(url1, user1, psw1);
System.out.println("conn="+conn);
} catch (Exception ex) ...{
ex.printStackTrace();
} finally ...{
try ...{
if (conn != null) ...{
conn.close();
}
} catch (Exception ex) ...{
ex.printStackTrace();
}
}
}
相关mysql jar包:http://download1.csdn.net/down3/20070521/21151228821.jar
相关oracle jar包:http://download1.csdn.net/down3/20070521/21151531564.jar
相关sqlserver jar包:TdsSqlServerJdbc2.jar