jdbc查询代码,Java代码库,德仔网

代码语言

代码分类

【Java】 jdbc查询

作者:fangley / 发布于2014/8/6/ 644


	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.ResultSet;
	import java.sql.Statement;
	
	public class jdbcSelect {
	 public static void main(String[] args) {
	
	 Connection conn = null;
	 Statement stat = null;
	 ResultSet rs = null;
	
	 try {
	 //使用jdbc加载数据库驱动
	 Class.forName("com.mysql.jdbc.Driver");
	 //使用jdbc获取数据库连接
	 conn = DriverManager.getConnection("jdbc:mysql:///product", "账号", "密码");
	
	 String sql = "select id,productname,productprice,provider from product";
	
	 stat = conn.createStatement();
	 rs = stat.executeQuery(sql);
	
	 while (rs.next()) {
	 int id = rs.getInt("id");
	 String productname = rs.getString("productname");
	 String productprice = rs.getString("productprice");
	 String provider = rs.getString("provider");
	 System.out.println("id : " + id + " productname : " + productname + " productprice : " + productprice + " provider : " + provider);
	 }
	
	 } catch (Exception e) {
	 e.printStackTrace();
	 } finally {
	 System.out.println("关闭资源!");
	 try {
	 rs.close();
	 } catch (Exception e) {
	 e.printStackTrace();
	 }finally{
	 try {
	 stat.close();
	 } catch (Exception e) {
	 e.printStackTrace();
	 } finally {
	 try {
	 conn.close();
	 } catch (Exception e) {
	 e.printStackTrace();
	 }
	 }
	 }
	 }
	
	 }
	}

试试其它关键字

　jdbc查询　

同语言下

可能有用的

fangley贡献的其它代码(8)