package com.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
private static String url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL";//1521为默认端口号,ORCL为数据库名
private static String user="system";//用户名
private static String password="xie";//密码
public static void main(String[] args) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn= DriverManager.getConnection(url, user, password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select id,name from jdbc1");jdbc1为表名,id,name为表中的字段
while(rs.next()){
System.out.println(rs.getString("name")+" "+rs.getInt("id"));(注意:数据库中新建的表和添加的数据要commit,否则会查不出来)
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//首先要引包,方法:略。
private static String url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL";//1521为默认端口号,ORCL为数据库名
private static String user="system";//用户名
private static String password="xie";//密码
public static void main(String[] args) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn= DriverManager.getConnection(url, user, password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select id,name from jdbc1");jdbc1为表名,id,name为表中的字段
while(rs.next()){
System.out.println(rs.getString("name")+" "+rs.getInt("id"));(注意:数据库中新建的表和添加的数据要commit,否则会查不出来)
}
}