请哪位高手能告诉在Java中怎么与数据库进行操作编程啊.....利用数据库
JAVA中使用数据库 进行编程 对数据库进行操作????
JAVA中使用数据库 进行编程 对数据库进行操作????
解决方案 »
- 参数是 JButton ...jb?高手可以解答一下吗?
- A.java要用到B.java里的变量,应该怎么做?
- SQLOLEDB无法启动分式
- 如何获取屏幕句柄
- java编程,是不是处处都离不开浏览器呀?与人的交互都是通过浏览器
- 关于类的卸载
- 如何根据字符串得到这个名字的类的instance?
- 关于log4j配置文件的问题?请大家多多指教!!!
- 求高手点拨一个Java写好的5W行级代码量的IM系统的工程性能测试工具...
- ??????在线等待
- MM7 报出的 java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 错误怎么解决?
- 为什么用double,float,BigDecimal分别来实现2.0-1.9,结果却不同?
import java.sql.DriverManager;
import java.sql.ResultSet;public class SqlDBSample { protected Connection getConnection() throws Exception {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
String dbURL = "jdbc:jtds:sqlserver://127.0.0.1:1433/dbname;charset=gbk";
String dbUser = "sa";
String dbPasswd = "sa";
Connection jdbcConnection = DriverManager.getConnection(dbURL, dbUser,
dbPasswd); return jdbcConnection;
} public static void main(String[] args) {
try {
SqlDBSample db = new SqlDBSample();
Connection conn = db.getConnection();
ResultSet result = conn.prepareStatement(
"select * from your_table_name").executeQuery();
while (result.next()) {
System.out.println(result.getString("ID"));
}
} catch (Exception e) {
e.printStackTrace();
}
}}
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar/
Class.forName( "org.postgresql.Driver" );
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
Class.forName( "oracle.jdbc.driver.OracleDriver" );
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );4. Sybase(http://jtds.sourceforge.net)jconn2.jar/
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
//(Default-Username/Password: "dba"/"sql")5. Microsoft SQLServer(http://jtds.sourceforge.net/)
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );6. Microsoft SQLServer(http://www.microsoft.com/)
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );7. ODBC
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + sDsn, sUsr, sPwd );