关于Java通过JDBC访问数据库的完全解决方案,不会的进来学习!
----------------------------------------------------------------------
ORACLE
----------------------------------------------------------------------
package lmy;//该包名无所谓,不过在jb下必须有包名
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;
import oracle.jdbc.driver.OracleDriver;
/*
本程序为操作oracle数据库的jdbc程序
在jb9下成功输出,需要配置project properties为oracle安装路径下jdbc/lib/class12.zip
*/
public class orac {
public static void main(String args[]) throws SQLException,ClassNotFoundException
{
String SYSUSR_ID,SYSUSR_NAME,SYSUSR_PWD,
SYSUSR_PRIVID,NWEST_IP,NWEST_TIME;
/*
O817DB为服务名,192.168.2.25为你要连接的机器之IP,
要是本机,可用localhost代替
*/
String strConnectionURL="jdbc:oracle:thin:@192.168.2.25:1521:O817DB",
strUserName="LMY",strPassWord="LMY";
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn =DriverManager.getConnection(strConnectionURL,strUserName, strPassWord);
Statement stmt = conn.createStatement();
ResultSet rstr = stmt.executeQuery("select * from SYSUSERS");
System.out.println("");
while(rstr.next())
{
SYSUSR_ID = rstr.getString(1);
SYSUSR_NAME = rstr.getString(2);
SYSUSR_PWD = rstr.getString(3);
SYSUSR_PRIVID = rstr.getString(4);
NWEST_IP = rstr.getString(5);
NWEST_TIME = rstr.getString(6);
System.out.println(SYSUSR_ID+SYSUSR_NAME+SYSUSR_PWD+SYSUSR_PRIVID+NWEST_IP+NWEST_TIME);
}
}
}
------------------------------------------------------------------------
sqlserver2000
------------------------------------------------------------------------
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;
/*
本程序为操作sqlserver2000数据库的jdbc程序
jdk1.4下成功
*/
public class sqlserv
{
public static void main(String args[]) throws SQLException,ClassNotFoundException
{
/*
djb为在管理工具-数据源odbc-系统dsn中的数据源名称
*/
String strConnectionURL="jdbc:odbc:djb",
strUserName="djb", strPassWord="djb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn =DriverManager.getConnection (strConnectionURL,strUserName, strPassWord);
Statement stmt = conn.createStatement();
ResultSet rstr = stmt.executeQuery("select * from SYSUSERS");
System.out.println("");
while(rstr.next())
{
SYSUSR_ID = rstr.getString(1);
SYSUSR_NAME = rstr.getString(2);
SYSUSR_PWD = rstr.getString(3);
SYSUSR_PRIVID = rstr.getString(4);
NWEST_IP = rstr.getString(5);
NWEST_TIME = rstr.getString(6);
}
}
}