1.eclipse 连接mysql jdbc怎么写
常用JDBC连接数据库方法总结如下:
一、JDBC连接DB2
Class.forName("Com.ibm.db2.jdbc.net.DB2Driver");
String url="jdbc:db2://dburl:port/DBname"
cn = DriverManager.getConnection( url, sUsr, sPwd );
二、JDBC连接Microsoft SQLServer(microsoft)
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://DBServerIP:1433;databaseName=master", sUsr, sPwd );
三、JDBC连接Sybase(jconn2.jar)
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
cn = DriverManager.getConnection( "jdbc:sybase:Tds:DBServerIP:2638", sUsr, sPwd );
四、JDBC连接MySQL(mm.mysql-3.0.2-bin.jar)
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://DBServerIP:3306/myDatabaseName", sUsr, sPwd );
五、JDBC连接PostgreSQL(pgjdbc2.jar)
Class.forName( "org.postgresql.Driver" );
cn = DriverManager.getConnection( "jdbc:postgresql://DBServerIP/myDatabaseName", sUsr, sPwd );
六、JDBC连接Oracle(classes12.jar)
Class.forName( "oracle.jdbc.driver.OracleDriver" );
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
七、JDBC连接ODBC
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + sDsn, sUsr, sPwd );
转载,仅供参考。
2.JDBC连接类的代码怎么写`
/*
* Created on 2004-6-3
*
* 连接数据库的相关操作
*
*/
package connect;
/**
* @author Ambrosini
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
import java.sql.*;
import java.util.*;
public class DataConnect {
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String databaseURL = "jdbc:odbc:Test";
String usr = "Test";
String psword = "Test";
Vector vector;
Connection connection=null;
Statement statement=null;
ResultSet resultSet=null;
ResultSetMetaData rsMetaData=null;
//连接数据库
public DataConnect(){
vector =new Vector();
try{
Class.forName(driverName);
}catch(ClassNotFoundException e){System.err.println(e.getMessage());}
}
//返回结果集
public ResultSet getResulet(String sql){
String sql2000 = sql ;
try{
connection = DriverManager.getConnection(databaseURL,usr,psword);
statement = connection.createStatement();
resultSet = statement.executeQuery(sql2000);
rsMetaData = resultSet.getMetaData();
}catch(SQLException ee){System.err.println(ee.getMessage());}
return resultSet;
}
//关闭连接
public void shutDown() {
try{
connection.close();
}catch(SQLException ex){System.err.println(ex.getMessage());}
}
//更改数据库操作
public void executeUpdate(String sql) {
try {
connection = DriverManager.getConnection(databaseURL,usr,psword);
statement = connection.createStatement();
statement.executeUpdate(sql);
}
catch(SQLException ee) {
System.err.println(ee.getMessage());
}
}
}
3.jdbc oracle加载驱动类语句怎么写
Oracle(thin)数据库连接:
1.Class.forName("oracle.jdbc.driver.OracleDriver");
2.DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:[DataBase Name]","scott","tiger");
本机专用:
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
Oracle(OCI driver)数据库连接:
1.Class.forName("oracle.jdbc.driver.OracleDriver");
2.DriverManager.getConnection("jdbc:oracle:oci8:@localhost:1521:[DataBase Name]","scott","tiger");
4.在MyEclipse里面怎么写MySQL的加载类
前提是:你加载了MySQL的数据库驱动。
private static final String DBDRIVER="org.gjt.mm.mysql.Driver"; //驱动
com.mysql.jdbc.Driver
private static final String DBURL="jdbc:mysql://localhost:3306/数据库名"; //URL
private static final String DBUSER="root"; //用户名
private static final String DBPASS="root"; //密码
附:定义常量,常量名应该全部大写。
5.jdbc 如何编写
加载JDBC驱动,连接数据库:
String url="jdbc:mysql://localhost:3306/jdbc";
String mingzi="root";
String word="123";
String driver="com.mysql.jdbc.Driver";
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
PreparedStatement ps=null;
在main方法中注册驱动程序:
Class.forName(driver);
con=DriverManager.getConnection(url,mingzi,word);
stmt=con.createStatement();
6.java JDBC连接不同的数据库写法sql,oracle,mysql
JDBC连接不同数据库的写法如下:1、Oracle8/8i/9i数据库(thin模式) Class.forName("oracle.jdbc.driver.OracleDriver"); String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID String user="test"; String password="test"; Connection conn= DriverManager.getConnection(url,user,password); 2、SQL Server2005及以上版本数据库 Class.forName("com.microsoft.sqlserver.SQLServerDriver"); String url="jdbc:sqlserver://localhost:1433;DatabaseName=mydb"; //mydb为数据库 String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password);3、MySQL数据库 Class.forName("com.mysql.jdbc.Driver"); String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1" //myDB为数据库名 Connection conn= DriverManager.getConnection(url);4、DB2数据库 Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance(); String url="jdbc:db2://localhost:5000/sample"; //sample为你的数据库名 String user="admin"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); 5、Sybase数据库 Class.forName("com.sybase.jdbc.SybDriver").newInstance(); String url =" jdbc:sybase:Tds:localhost:5007/myDB";//myDB为你的数据库名 Properties sysProps = System.getProperties(); SysProps.put("user","userid"); SysProps.put("password","user_password"); Connection conn= DriverManager.getConnection(url, SysProps); 6、Informix数据库 Class.forName("com.informix.jdbc.IfxDriver").newInstance(); String url = "jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver; user=testuser;password=testpassword"; //myDB为数据库名 Connection conn= DriverManager.getConnection(url);7、PostgreSQL数据库 Class.forName("org.postgresql.Driver").newInstance(); String url ="jdbc:postgresql://localhost/myDB" //myDB为数据库名 String user="myuser"; String password="mypassword"; Connection conn= DriverManager.getConnection(url,user,password); 8、access数据库直连用ODBC的 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("/Data/ReportDemo.mdb");Connection conn = DriverManager.getConnection(url,"","");Statement stmtNew=conn.createStatement() ;。
转载请注明出处育才学习网 » jdbc的driver怎么写