Jdbc demo

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();
	}