Jdbc demo

iteye_8127

于 2008-10-24 16:02:54 发布

阅读量142

点赞数

分类专栏： Java 文章标签： JDBC MySQL SQL

Java 专栏收录该内容

20 篇文章

订阅专栏

String url = "jdbc:mysql://127.0.0.1:3306/mysql";
String username = "root";
String password = "123456";
try {
	Class.forName("com.mysql.jdbc.Driver");
	Connection con = DriverManager.getConnection(url,username,password);
	String sql = "select * from table";
	Statement st = con.createStatement();
	ResultSet rs = st.executeQuery(sql);
			
	while(rs.next()){
      // 次序从1开始
	System.out.println(rs.getString(1));
	}
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	} catch (SQLException e) {
		e.printStackTrace();
	}