a.java

来自「JAVA语言实现与MYSQL的连接主要提供代码有JAVA 基础知识都可学习数据库」· Java 代码 · 共 25 行

import java.sql.*;
public class A {

	public static void main(String[] args) {
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			Connection con = DriverManager.getConnection("jdbc:mysql://net200/test","java","java1234");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from account");
			while(rs.next()) 
			{
				System.out.println(rs.getString("name")+"\t"+rs.getFloat("balance"));
			}
			rs.close();
			stmt.close();
			con.close();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
}