从数据库中读出记录

最新推荐文章于 2021-03-18 06:29:04 发布

刘利新西安

最新推荐文章于 2021-03-18 06:29:04 发布

阅读量527

点赞数

分类专栏： JDBC

JDBC 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

CREATE TABLE users( 
username varchar(15) NOT NULL, 
name varchar(255) NOT NULL, 
pass varchar(15) NOT NULL, 
CONSTRAINT users_pkey PRIMARY KEY (username))
;

insert into users values ('Binod','Binod Kumar Suman','satyam');
insert into users values ('Pramod','Pramod Kumar','Patni');

import java.sql.*;

class DatabaseTest {
	public static void main(String args[]) {
		try {
			System.out.println("********** USER INFORMATION ************");
			System.out.println("\n");
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = DriverManager.getConnection(
					"jdbc:mysql://localhost/tutorial", "root",
					"HuaDi5");
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM users");
			while (rs.next()) {
				System.out.print("USERNAME :: " + rs.getString(1) + " ");
				System.out.print("NAME :: " + rs.getString(2) + " ");
				System.out.println("PASSWORD ::" + rs.getString(3));
			}
			rs.close();
			stmt.close();
			conn.close();
		} catch (SQLException se) {
			System.out.println("SQL Exception :: " + se);
		} catch (Exception e) {
			System.out.println(e);
		}
	}
}

原文：http://binodsuman.blogspot.com/2008/11/jdbc-simple-example.html

源代码：http://pan.baidu.com/share/link?shareid=422133&uk=3878681452