当前位置 : 主页 > 编程语言 > c++ >

原生JDBC连接数据库

来源:互联网 收集:自由互联 发布时间:2021-06-30
JDBC.java import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class JdbcConn {public static void main(String[] args) throws ClassNotFoundEx
JDBC.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JdbcConn {
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.111.11.111:1557/ecidb", "ECIS", "ECIS");
		String sql = "";
		PreparedStatement pstmt = conn.prepareStatement(sql);
		pstmt.setString(1, "0001");
		ResultSet rs = pstmt.executeQuery("");
		while (rs.next()) {
			System.out.println(rs.getInt(1) + "-" + rs.getString(2));
		}
		rs.close();
		pstmt.close();
		conn.close();
	}
}
网友评论