三、JDBC

最新推荐文章于 2024-09-14 19:55:29 发布

rooke

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量70

点赞数

分类专栏： JDBC 文章标签：数据库

本文链接：https://blog.csdn.net/rooke/article/details/84079054

版权

JDBC 专栏收录该内容

4 篇文章 0 订阅

订阅专栏


public static final String DBDRIVE = "oracle.jdbc.driver.OracleDriver";
	 public static final String DBURL = "jdbc:oracle:thin:@169.254.24.29:1521:orcl";
	 public static final String DBUSER = "scott";
	 public static final String DBPASSWORD= "tiger";
	public static void main(String[] args) 
	{
		Connection conn =null;
		PreparedStatement pstmt = null;
		ResultSet rs =null;
		String sql = "select * from user where name like ?";
		try {
			Class.forName(DBDRIVE);
		    conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
		    pstmt = conn.prepareStatement(sql);
		    pstmt.setString(1, "%xiaoming%");
		    rs = pstmt.executeQuery();
		    while(rs.next())
		    {
		    	int id = rs.getInt(1);
		    	String name = rs.getString(2);
		    	System.out.print("编号" + id + ":");
		    	System.out.println("姓名" + name + ":");
		    }
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}