各种数据库使用JDBC 连接数据库

//sqlserver2000
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbname";

//oracle
driver = "oracle.jdbc.driver.OracleDriver";
url = "jdbc:oracle:thin:@localhost:1158:dbname";

//mysql
driver = "com.mysql.jdbc.Driver";
url = "jdbc:mysql://localhost:3306/dbname";

//sqlserver2005
driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
url = "jdbc:sqlserver://10.0.0.152:1433;DatabaseName=gaowei";

String username = "test";
String password = "123456";
Class.forName(driver);
Connection con = DriverManager.getConnection(url, username, password);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from t_account where FNumber = '"+ code +"'");
while (rs.next()) {
fName = rs.getString("FName");
}