- 论坛徽章:
- 0
|
大侠帮忙:在线等待:我的java和mysql的问题。
不是啊,就是连接数据库的代码。忘了:
public OTADB(String dbClass,String dbWhere,String userName,String userPass) {
/*
Oracle: dbClass = "oracle.jdbc.driver.OracleDriver"
dbWhere = "jdbc racle:thin ip:port:sid"
SQLServer: dbClass = "com.inet.tds.TdsDriver"
dbWhere = "jdbc:inetdae:ip:port?database=xxx&sql7=true..."
注意:要新建用户并授权
MySQL: dbClass = "org.gjt.mm.mysql.Driver"
dbWhere = "jdbc:mysql://ip:port/dbname?param1=value1¶m2=value2..."
注意:在MySQL装好之后,需要建立database和表,然后授权,用下句:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON customer.*
TO custom@'%'
IDENTIFIED BY 'stupid'
DB2: dbClass = "COM.ibm.db2.jdbc.app.DB2Driver"
dbWhere = "jdbc:db2 ta"
userName = "xxx"
userPass = "xxx"
// add by zhf
*/
try {
Class.forName(dbClass).newInstance();
connString = dbWhere;
conn = DriverManager.getConnection(connString,userName,userPass);
if (conn!=null) {
DBConnected = true;
stmt = conn.createStatement();
}
}catch(SQLException e){
e.printStackTrace();
DBConnected = false;
System.out.println(ErrMsg);
}catch(Exception e){
e.printStackTrace();
}
} |
|