用JDBC实现简单的数据库查询的一个例子

最新推荐文章于 2024-06-06 00:19:40 发布

cindyhbbl

最新推荐文章于 2024-06-06 00:19:40 发布

阅读量1.8k

点赞数

分类专栏： JDBC

本文链接：https://blog.csdn.net/cindyhbbl/article/details/8664076

版权

JDBC 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

public class JavaJdbc {
	
	private static Connection getConn() throws Exception
	{
		Connection conn = null;
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@10.111.11.11:1521:ora11g","mima","mima");
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return conn;
	}
	
	private static void queryData() throws Exception
	{
		Connection conn = getConn();
		PreparedStatement ps = null;
		ResultSet rs = null;
		try
		{
			String sql = "select * from 'TB_DIC_CHANNEL";
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next())
			{
				System.out.println(rs.getString(2));				
			}
		}catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void main(String[] args) throws Exception {
		queryData();
	}

}