随手写个JDBC连接Oracle的Demo,权当复习,随后推出MySQL版的
每天坚持敲代码,我在成神的狂奔
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCTestDemo {
public static void main(String[] args) {
String driver ="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:xe";
try {
Class.forName(driver);
Connection connection=DriverManager.getConnection(url, "scott", "tiger");
PreparedStatement ps=connection.prepareStatement("select empno from emp");
ResultSet rs =ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getInt(1));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}