JAVA连接数据库大全

Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
String url="jdbc:db2://localhost:5000/sample";
//sample为你的数据库名
String user="admin";
六、MySQL数据库
Class.forName("com.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
try {
Class.forName(driver);
con = DriverManager.getConnection(url,user,pwd);
} catch (Exception e) {
// TODO Auto-generated catch block
import java.util.Properties;
public class DbConnection {
public static Connection getConnection() {
Connection con = null;
// 驅動程序主入口程序名
String driver = "com.mysql.jdbc.Driver";
System.out.println("数据库连接成功");
close(getDbConnection());
}else{
System.out.println("数据库连接失败");
}
}
}
CREATE TABLE `employee_prj` (
e.printStackTrace();
}
return con;
}
public static Connection getDbConnection(){
Connection con = null;
Properties pro = getDbPropertes();
String user="myuser";
String password="mypassword";
Connection conn= DriverManager.getConnection(url,user,password);
package mon;
注意：8 和 9 的驱动不同！
二、Sql Server7.0/2000数据库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
try{
// 读取文件中的属性信息并保存在properties对象中
FileInputStream fin = new FileInputStream(new File("db.properties"));
pro.load(fin);
}catch(IOException e){
System.out.println("读取文件信息异常:= " + e.getMessage());
}lic static void main(String[] args){
if(getDbConnection()!= null){
String driver = pro.getProperty("driver");
String url = pro.getProperty("url");
String user = pro.getProperty("user");
String pwd = pro.getProperty("password");
// TODO Auto-generated catch block
e.printStackTrace();
}
con=null;
}
}
private static Properties getDbPropertes(){
Properties pro = new Properties();
`hireDate` date default NULL,
`salary` numeric(8,2) default NULL,
`email` varchar(20) default NULL,
`tel` varchar(20) default NULL,
PRIMARY KEY (`empId`)
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
e.printStackTrace();
}
return con;
}
public static void close(Connection con){
if(con!=null){
try {
con.close();
} catch (SQLException e) {
//tsdata为你的数据库名
Properties sysProps = System.getProperties();
SysProps.put("user","userid");
SysProps.put("password","user_password");
//orcl为你的数据库的SID
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
`empId` varchar(10) NOT NULL,
`empName` varchar(20) default NULL,
`empSex` varchar(2) default NULL,
`deptName` varchar(20) default NULL,
`job` varchar(20) default NULL,
//testDB为你的数据库名
Connection conn= DriverManager.getConnection(url);
// org.git.mm.mysql.Driver 是2.X 的驱动
// com.mysql.jdbc.Driver 是3.x以上的
// jdbc url
String url = "jdbc:mysql://localhost/personal_management";
try {
Class.forName(driver);// 加载驱动程序
con = DriverManager.getConnection(url,"root","root");
连接数据库大全
一、Oracle8/8i/9i数据库（用thin模式）
testoracle.jsp如下：
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl";
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
三、DB2数据库
Connection conn= DriverManager.getConnection(url);
五、连接Sybase数据库
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
String url =" jdbc:sybase:Tds:localhost:5007/tsdata";
七、连接PostgreSQL数据库
Class.forName("org.postgresql.Driver").newInstance();
String url ="jdbc:postgresql://localhost/soft"
//soft为你的数据库名
String url =
"jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;
user=testuser;password=testpassword";
//testDB为你的数据库名
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
四、Informix数据库
Class.forName("rmix.jdbc.IfxDriver").newInstance();